Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Long To Varchar2
Creating a data warehouse using data extraction - Oracle d/b to Oracle d/b. Some data is in a table is in Long datatype - need to extract and insert in varchar2 column.
Would like to use one select statement eg
Insert into xxxx (varchar_data, ...
Select substr(long_data,1,100) from xxxx => get error
Any thoughts on creating a function convert long to varchar2 (input long_data output varchar2?? Received on Tue Feb 20 2001 - 02:29:48 CST