Skip to Main Content

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 remove column name in select clause

973995Feb 26 2013 — edited Feb 26 2013
Hello Guys,

I just want to remove a column name in select clause. Because, I don't want to write all column names. I hope I express myself.

In other words, I want the following.
Select   * - unwanted_column  from table;

instead of this 

Select col1, col2, col3, col4, ........ col 10000 from table;
This post has been answered by Frank Kulash on Feb 26 2013
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 26 2013
Added on Feb 26 2013
4 comments
1,891 views