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!

New table out of columns

679415May 12 2010 — edited May 12 2010

Hi All,

I am a starter in oracle.

I have a table wit columns:
-------------------------------------------------------
amt1 date1 amt2 date2 amt3 date3
------------------------------------------------------
10 10/9 20 11/09 30 12/09
------------------------------------------------------

i want to create a new table or view from the above which looks like below

amt date
10 10/09
20 11/09
30 12/09

Kash

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 9 2010

Added on May 12 2010

3 comments

1,034 views