I have a problem of converting LONG data type to varchar2 in a table. So I need to create a new table by using the max varchar2(4000) instead of the long defined in the current tables.
The round-about solution is to have a cursor for the table and then insert into a new table with varchar2(4000) data.
But is there any other standard / easy way available?
Table details :
I need to convert this "DATA" field into VARCHAR2(4000).
Thx for the early reply.