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!

SELECT - using column number instead of column names

368114Aug 1 2003 — edited Aug 1 2003

Hi all,
Please accept my appology if my question is a stupid one..

I have a situation.. i want to write a SP in which i want to get the data from a table and i don't know the column names.
What i need to do is to get the refrence of column data by column ID i.e. something like

select coulumns[0] from TableName.

where columns is some sort of collection or so..
any help will be very helpful

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 29 2003

Added on Aug 1 2003

5 comments

468 views