Skip to Main Content
Forums

SQL Developer

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 exclude columns from select sql?

Aamir0731Nov 21 2013 — edited Nov 21 2013

Hii all,

I have already googled it and all i found that there is no way to exclude a column name in a sql(Oracle 11g).

For eg. select exclude(emp_name) from employee;

so output will all column bt not emp_name...

i have tried noprint for sqlplus ... what else i can use??
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 19 2013
Added on Nov 21 2013
#oracle, #select, #sql, #sql-developer
2 comments
3,578 views