Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

how to concatenage text to data_default col of all_tab_columns.

947771Jan 22 2013 — edited Jan 22 2013
Hi,


i want to concatinate text to a columen like this but it is show error ,so i thought to convert it but could not get correct code.

select 'dff' || data_default || 'df' from all_tab_columns


yours sincerley
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 19 2013
Added on Jan 22 2013
3 comments
771 views