Home » SQL & PL/SQL » SQL & PL/SQL » Insert statement (Oracle 9i)
Insert statement [message #412464] Thu, 09 July 2009 10:07 Go to next message
preethi 12$
Messages: 9
Registered: January 2008
Junior Member

I have a table test1 with records in it.
There is another empty table test2 with few columns similar to test1 table.

The requirement is to first assign variables to each of the columns present in test1.
Using these variables insert records into the test2 table for the similar columns. Can someone pls help me how to achieve this.

Re: Insert statement [message #412465 is a reply to message #412464] Thu, 09 July 2009 10:11 Go to previous messageGo to next message
Messages: 24963
Registered: January 2009
Location: SoCal
Senior Member
You need to help us by following the Posting Guidelines as stated below.
Go to the URL above click the link "Posting Guidelines"
Go to the section labeled "Practice" & do as directed.

This can & should be done with only pure SQL & no PL/SQL variables are required.
Re: Insert statement [message #412466 is a reply to message #412464] Thu, 09 July 2009 10:18 Go to previous message
Michel Cadot
Messages: 63923
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Previous Topic: Query to find table's with primary key
Next Topic: table column to be updated
Goto Forum:

Current Time: Wed Oct 26 01:38:05 CDT 2016

Total time taken to generate the page: 0.06333 seconds