| select statement [message #70366] |
Tue, 04 June 2002 07:07  |
David Setiawan
Messages: 1
Registered: June 2002
|
Junior Member |
|
|
Hi...Let's say I have 5 columns: A, B, C, D, E
is there a select statement of some sort that selects every column but one of them...something like
select * except C or something.....or do you have to manually list all the columns you want to list if you don't want to list them all. I figured if you have 10 columns with long column names if there is a functionality where you can say select all but this column would be nice.
Thanks
|
|
|
|
| Re: select statement [message #70367 is a reply to message #70366] |
Tue, 04 June 2002 07:47  |
alapps
Messages: 11
Registered: June 2002
|
Junior Member |
|
|
Unfortunately, there is no shortcut available...
mytable
-------
a Varchar2(30)
b Varchar2(30)
c Varchar2(30)
d Varchar2(30)
e Varchar2(30)
select a,b,d,e
from mytable
is the only way to select all columns except c
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
