Simpler Navigation for Servers and Operating Systems - Please Update Your Bookmarks
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
If you have bookmarked forums or discussion boards in Servers and Operating Systems, we suggest you check and update them as needed.
cancel
Showing results for 
Search instead for 
Did you mean: 

RE: Transform and Load

Avoiding the Red Zone
Occasional Contributor

RE: Transform and Load

Hi,

Could you please help me out here as I am trying to load data from one table into the other.

I have just been practicint on scott.emp which I have created a scott.emp_stage and I am trying to load the data from scott.emp_stage into scott.emp.

Can anyone help me with tis task.

Thanks,
Angus
2 REPLIES
Patrick Wallek
Honored Contributor

Re: RE: Transform and Load

What have you tried? Where is it going wrong? I assume this is Oracle? Are you trying to do this from SQLPLUS or some other utility like OEM?

In your subject you mention "Transform and Load". What are you trying to transform?
Sandman!
Honored Contributor

Re: RE: Transform and Load

Well to load data from one table into another it is best to use the SQL "insert into select..." cmd syntax. It would depend on the columns that make up your FROM and TO
viz.,

INSERT INTO table1 (col1, col2, ...)
SELECT col3, col4, ...
FROM table2