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!
It would be very convenient if the Oracle Database provided a simple syntax to select every attribute from a table except one column.
For example:
SELECT *EXCEPT COMMISSION_PCTFROM EMPLOYEES;
SELECT *
EXCEPT COMMISSION_PCT
FROM EMPLOYEES;
This idea was inspired by this thread.