Hi All, Can I run a TO_CHAR on a

[Muskaan]

Hi All,

Can I run a TO_CHAR on a LONG Datatype ? Long has a size of 2 GB. Is there a limitation on TO_CHAR ?

I need to dump the LONG data along with other columns of a table into a flat file, in the following format:

"COL1 data","COL2 data","COL3 data"

say col3 data is LONG, can I use TO_CHAR on it to dump it to the file? Printing it directly without any conversion does not work, since operation
select chr(34)||COL3||chr(34) from table_name
gives an error

your help is highly appreciated.

 

[Morpheus1981]

Try it, if doesn't works the answer is yes.