2 Replies Latest reply: Nov 21, 2013 10:19 AM by rp0428 RSS

    how to exclude columns from select sql?


      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??