Who knows a function that convert long to varchar2?
I need this because I want to do the following SQL statement to work:
Select C1 from T1
Select C2 from T2
Where C1, C2 are of LONG data type.
I am trying to do an Insert-Select sql statement with one of the fields
being a Long datatype. I know that this will give me an "Illegal use
of Long Datatype" error. Is there any other way of doing the same
thing without actually going through a cursor and looping through the
Appreciate the help and thanks in advance,
Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't.