oracle - Can you SELECT everything, but 1 or 2 fields, without writer's cramp?

Question

Is it possible, in PLSQL, to select all of the fields in a table except for 1 or 2, without having to specify the fields you want?

Example, the employee table has the fields:

• id
• firstname
• lastname
• hobbies

Is it still possible to write a query similar to

select * from employee

while leaving the field hobbies without with having to write something like this?

select id, firstname, lastname from employee

Answer 1

No - you either get all fields (*) OR specify the fields you want.