Home » SQL & PL/SQL » SQL & PL/SQL » create new table from existing tables with no rows
create new table from existing tables with no rows [message #225155] Sun, 18 March 2007 09:55 Go to next message
satishachar
Messages: 17
Registered: July 2006
Location: Mumbai
Junior Member

can we create new table from existing tables with no rows
Re: create new table from existing tables with no rows [message #225156 is a reply to message #225155] Sun, 18 March 2007 10:00 Go to previous message
BlackSwan
Messages: 25041
Registered: January 2009
Location: SoCal
Senior Member
CREATE TABLE NEW_TABLE AS SELECT * FROM OLD_TABLE WHERE 1 = 2;

Why is this an expert question?

[Updated on: Sun, 18 March 2007 10:01] by Moderator

Report message to a moderator

Previous Topic: mutating trigger
Next Topic: how to set the UTL_FILE directory intialization in INIT.ORA in windows
Goto Forum:
  


Current Time: Tue Dec 06 13:50:59 CST 2016

Total time taken to generate the page: 0.07409 seconds