Long Datatype [message #38810] |
Thu, 16 May 2002 06:10 |
Pushparaj
Messages: 4 Registered: May 2002
|
Junior Member |
|
|
Is there any way to do a pattern search on a long datatype without writing the actual long value in to a file.
|
|
|
Re: Long Datatype [message #38850 is a reply to message #38810] |
Mon, 20 May 2002 22:08 |
|
Maaher
Messages: 7065 Registered: December 2001
|
Senior Member |
|
|
Yes, there is. There are several workarounds available. Here's one: http://www.arrowsent.com/oratip/tip23.htm.
You can make the VARCHAR2 variable longer, to contain more of the data, because now it is limited. If you work with a loop and some sort of "Offset", you can search the entire LONG column. Just thinkin'...
HTH,
MHE
|
|
|