Skip navigation

Select all but one column from a table

score 0
You have not voted. Active

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_PCT
FROM EMPLOYEES;

 

This idea was inspired by this thread.

Comments

Vote history