Hi all,
I wanted to do conversion of a column having datatype long into varchar2(2000). For that I need to know the data length on that column.
I have tried this but its not working . Can anybody suggest me what should I do ?

SQL> select length(MAP_PAINTER) from lluser.wmap;
select length(MAP_PAINTER) from lluser.wmap
*
ERROR at line 1:
ORA-00932: inconsistent datatypes: expected NUMBER got LONG

Thanks -
Dhirendra



Oracle LazyDBA home page