Home » RDBMS Server » Server Administration » Copy Data……….How to do???
Copy Data……….How to do??? [message #374793] Mon, 02 July 2001 22:25 Go to next message
kana
Messages: 1
Registered: July 2001
Junior Member
I have TABLE1 and TABLE2. TABLE1 has data but TABLE2 empty and I want to copy data from TABLE1 to TABLE2, How can I do???

Report message to a moderator

Re: Copy Data……?How to do??? [message #374795 is a reply to message #374793] Tue, 03 July 2001 01:31 Go to previous message
yushuai
Messages: 5
Registered: December 2000
Junior Member
If the two tables shares the same struct,then just do as what follows:
>intert into table2
>select * from table1;

Report message to a moderator

Previous Topic: Re: Pass parameters to sqlplus
Next Topic: alter view
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Jul 06 07:13:28 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.