SQL Language (MOSC)

MOSC Banner

Dynamic column listing in CTAS

edited Feb 18, 2010 4:54AM in SQL Language (MOSC) 8 commentsAnswered
 Is there a way to do something like....

Create table my_table

as Select a.* minus a.name from emp a;

to select all columns but name?   

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center