URGENT HELP NEEDED
I have to find a way to search a substring in a field with LONG datatype. But as far as I know it is not possible to use LIKE for this datatype. Is there a way to convert LONG to VARCHAR?
Thank you.........
Printable View
URGENT HELP NEEDED
I have to find a way to search a substring in a field with LONG datatype. But as far as I know it is not possible to use LIKE for this datatype. Is there a way to convert LONG to VARCHAR?
Thank you.........
You can use interMedia Text Editor utility from Oracle 7.3 onwards to use LONG field in Where clause of the sql statement.See the documentation on interMedia