Home » SQL & PL/SQL » SQL & PL/SQL » insert records from a table into another table ?
insert records from a table into another table ? [message #23406] Thu, 05 December 2002 13:56 Go to next message
Hung Tran
Messages: 1
Registered: December 2002
Junior Member
How do i insert records from a table into another table ?

Report message to a moderator

Re: insert records from a table into another table ? [message #23409 is a reply to message #23406] Thu, 05 December 2002 15:13 Go to previous message
Todd Barry
Messages: 4819
Registered: August 2001
Senior Member
 
insert into t2 (col_a, col_b)
  select a, b
    from t1
   where ...;

Report message to a moderator

Previous Topic: What must be inserted into a NUMBER data type?
Next Topic: regarding conversion of oracle database
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue May 14 21:15:10 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.