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!

Add string at the end of column name

M TajuddinMar 4 2009 — edited Mar 4 2009

Hi All,

I am just wondering wether it is possible or not. I have created a table similar to another table by using -

create table table_name as select * from table_name1;

Now, I want to differentiate the column name from the previous table column names. I want to add E at the end of the all column names. Is it possible using sql Command in sql workshop or toad without doing it manually as I have more than 100 columns in that table?

Thanks in advance.

Regards,

M Tajuddin

This post has been answered by Walter Fernández on Mar 4 2009

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 1 2009

Added on Mar 4 2009

6 comments

1,761 views