Oracle Database Discussions

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!

need to select all columns but one.

TCSBPMUSERJan 31 2012 — edited Feb 1 2012

Hi,
I need a query which resembles the below mentioned query where there are 75 cols in the table mentioned in the table and only 74 cols are required in the output.
select col_1,col_2......,col_73,col_74 from tab_name;
please suggest

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 29 2012

Added on Jan 31 2012

#11g, #general-database-discussions

18 comments

2,199 views