SELECT Statement

[pkohli88]

Hi,
Is there any easy way for selecting all fields EXCEPT one field from table.

Thanks In Advance

 

[johnherman]

CREATE TABLE temp-table as SELECT * FROM your-table

ALTER TABLE temp-table DROP COLUMN column-I-dont-want

SELECT * from temp-table



-------------------------
The trouble with doing something right the first time is that nobody appreciates how difficult it was - Steven Wright

 

[karluk]

In sql*plus you can define the column as "noprint" before running your query:

column column_name_to_exclude noprint
select * from your_table;