SQL Language (MOSC)

MOSC Banner

How to achieve "select 'stringX ('||long_column||')' ..."

edited Sep 6, 2019 5:49PM in SQL Language (MOSC) 4 commentsAnswered ✓

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center