casting LONG
Hi,
using this query
SELECT COLUMN_NAME, cast(DATA_DEFAULT as varchar2(100))
FROM(USER_TAB_COLUMNS) WHERE 1=1 AND DATA_DEFAULT IS NOT NULL
it gives error
SQL Error: ORA-00932: inconsistent datatypes: expected NUMBER got LONG
how can i cast LONG to varchar2
thanks,
jomet.
---------------------------------------------
Once you start a working on something,
dont be afraid of failure and dont abandon it.
People who work sincerely are the happiest.
|
