Home » SQL & PL/SQL » SQL & PL/SQL » select statement options
select statement options [message #308279] Sun, 23 March 2008 10:49 Go to next message
dmkanz
Messages: 9
Registered: March 2008
Junior Member
Is it possible to write a select statement that picks all colums but excludes one.

select * from client;

If client has 15 columns is there an option with the * wildcard that will allow me to exclude a column.

I know I can pick each column separately in my select but what if I have multiple columns?

select * (except i.e contact_number) from client;

Hopefully this make sense.

Thanks

DM Kanz
Re: select statement options [message #308280 is a reply to message #308279] Sun, 23 March 2008 11:02 Go to previous messageGo to next message
BlackSwan
Messages: 25042
Registered: January 2009
Location: SoCal
Senior Member
>Is it possible to write a select statement that picks all colums but excludes one.
NO
Re: select statement options [message #308281 is a reply to message #308279] Sun, 23 March 2008 11:37 Go to previous message
Michel Cadot
Messages: 64122
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Hopefully no.
You MUST never use * in your program.
You MUST always name all columns in your statements.

Regards
Michel
Previous Topic: date format
Next Topic: how to seperate a sentance into array by a seperator ';' using pl/sql ?
Goto Forum:
  


Current Time: Wed Dec 07 04:46:25 CST 2016

Total time taken to generate the page: 0.11042 seconds