Re: SQL Help

| >I am trying to take data from one table and put it into another table.
One
| >table exists in one schema, the other in a different schema. The columns
| >aren't a one to one match, so I was hoping to manually specify where the
| >data from the source table goes in the destination table.
| >
| >Is this possible with an INSERT statement?
|
| Yes
| insert into <table>(<column1>,<column2>,....) select <column1>,...
| from table

Ahh, so it can be done.

|
| As defined in the sql reference manual online at
| http://tahiti.oracle.com
|
| Please try to avoid mere syntax questions.

Mere syntax questions? If I have any questions, I'll ask them, regardless of how "mere" anyone finds them. Received on Sat Nov 30 2002 - 22:13:37 CST