OraFAQ Forum: SQL & PL/SQL » copy contents of a table to a new table

Home » SQL & PL/SQL » SQL & PL/SQL » copy contents of a table to a new table

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

copy contents of a table to a new table [message #8331]

Sun, 10 August 2003 07:41

hrishita
Messages: 13
Registered: August 2003

Junior Member

How to copy the contents of a table to another table after creating the second table.
These steps of creating the second table and copying the contents of first table to second table has to be in a single SQL statment

Can we do with copy command ? I tried but couldn't get it

Report message to a moderator

Re: copy contents of a table to a new table [message #8336 is a reply to message #8331]

Sun, 10 August 2003 17:04

William Robertson
Messages: 1643
Registered: August 2003
Location: London, UK

Senior Member

COPY is not an SQL statement. It's a (deprecated) SQL*Plus command.

Try INSERT, or else CREATE TABLE newtab AS SELECT cols FROM oldtab;

Report message to a moderator

Re: copy contents of a table to a new table [message #8340 is a reply to message #8331]

Mon, 11 August 2003 06:00

Zia Khattak
Messages: 22
Registered: July 2003

Junior Member

TRY THIS:

CREATE TABLE EMPNEW AS SELECT * FROM EMP;

IF YOU DONT WANT TO TRANSFER DATA THEN:

CREATE TABLE EMPNEW AS SELECT * FROM EMP
WHERE 1=2;

Report message to a moderator

Re: copy contents of a table to a new table [message #8344 is a reply to message #8340]

Mon, 11 August 2003 21:43

hrishita
Messages: 13
Registered: August 2003

Junior Member

got it thanx

Report message to a moderator

Previous Topic:	Where i will configure the job?
Next Topic:	procedure/function parameter as a record or table

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 18 20:15:23 CDT 2024