OraFAQ Forum: Server Administration » Table build from another table

Home » RDBMS Server » Server Administration » Table build from another table

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Table build from another table [message #374770]

Fri, 29 June 2001 12:54

Ray
Messages: 58
Registered: January 2000

Member

HI,
Is there a way to create a table from another table with a SELECT or INSERT statement if the new table does not exist? Using Version 8.1.7. All of the columns and rows should be the same. Using this for a quick test and didn't want to create table and load data. Thanks in advance.

Report message to a moderator

Re: Table build from another table [message #374771 is a reply to message #374770]

Fri, 29 June 2001 13:16

Andrew again...
Messages: 270
Registered: July 2000

Senior Member

create table ABC_NEW as (select * from ABC);

Report message to a moderator

Re: Table build from another table [message #374774 is a reply to message #374770]

Fri, 29 June 2001 22:14

palanikarupaiyan@hotmail.
Messages: 18
Registered: June 2001

Junior Member

as other said create table ABC_NEW as (select * from ABC) , which create another table with loading data from the exiting table.....

If u do wanna creat new table with no data ,

create table ABC_NEW as (select * from ABC where 1= 2); will do.

Report message to a moderator

Previous Topic:	Sql to display responsibilities and menus
Next Topic:	Re: help

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jul 06 07:29:52 CDT 2024