Top.Mail.Ru Yandeks.Metrika
Forum: "Bases";
Current archive: 2002.01.08;
Download: [xml.tar.bz2];


The problem with finding the Long field in Oracle Find similar branches

Nailka   (2001-12-04 16:16) [0]

Good people!
Any thoughts on how to solve the search problem in a Long field (size up to 2 Gigabytes) in Oracle 7.3. The manual says that in a field of this type only operators of the type Insert, Update, etc. are valid. and that’s it. A field of type Varchar2 has a length of 2000 characters, and I need to store and search on 64K order. Maybe someone already solved a similar problem?

Yuvich   (2001-12-04 16:29) [1]

I solved a similar problem like this:
- you make a table where the blob is stored by the master.
- attach a child table to it (let's call it info).
There are only two fields in this table - the foreign key of the wizard and the varchar2 (2000) field (let's call it text).
When the application received the final text that needs to be written, then you hit it on the lines of the text field, the size of the text, and do the inserts in info as much as the number of lines. To display the full text in the application, you select all the lines and concatenate them. After editing (for example) again, hit the lines and write again in info.

Well, there you can hang all sorts of features such as "version control", "accounting for the one who changed", etc.

Nailka   (2001-12-04 17:04) [2]

Thank you for your help, I also thought about such an option, the truth will follow everything a little gimmickily. My database used to be local and the search on LIKE worked (although the Upper operator could not be used), but now Oraklovsky put it on the server - it got out, Mlyn

Pages: 1 whole branch

Forum: "Bases";
Current archive: 2002.01.08;
Download: [xml.tar.bz2];


Memory: 0.56 MB
Time: 0.037 c
1 - 22211
2001-12-13 22:46
Good evening, day, morning. People help !!! how to dial a number, switch to tone mode, and enter a random code *

1 - 22181
2001-12-21 11:12
How to prohibit mouse form movement?

1 - 22116
2001-12-19 19:08
Does anyone have a thread hash MD5?

3 - 21997
2001-12-05 11:46
How to create a user with permissions like sysdba

1 - 22157
2001-12-20 13:55
Find two carriage returns in a row.

afrikaans albanian Arabic armenian azerbaijani basque belarusian bulgarian catalan Chinese (Simplified) Chinese (Traditional) croatian Czech danish Dutch English estonian filipino finnish French
galician georgian German greek haitian Creole hebrew Hindi hungarian icelandic indonesian Irish italian Japanese Korean latvian lithuanian macedonian malay maltese norwegian
persian polish portuguese Romanian russian serbian slovak Slovenian Spanish swahili Swedish thai turkish Ukrainian urdu vietnamese welsh yiddish bengali bosnian
cebuano Esperanto gujarati hausa hmong igbo javanese kannada khmer lao latin maori marathi mongolian nepali punjabi somali tamil telugu yoruba
English French German Italian Portuguese Russian Spanish