How to achieve "select 'stringX ('||long_column||')' ..."
Hi
Oracle 12.1
Now I know there is a hassle with long columns, but is there any possibility to achieve the following..?
And of course data_default is long column.
select owner, table_name, column_name, data_default , 'DEFAULT ('||data_default||')' as default_val -- how can I do this, I get ORA-00932: inconsistent datatypes: expected CHAR got LONGfrom dba_tab_colswhere data_default is not null and rownum <= 10;
Regards
Raul
1