Hi all I have a requirement in Oracle 10g to run the substring command on a long datatype in a table. For example this is what I would like to do.
note: col1 is LONG datatype
select substr(col1,1,2000), substr(col1,2001,4001) from table1;
I'd also like to run the trim function if possible from start to end.
I remember someone in my last place had a pl/sql procedure with input/output variables. Can someone help.