RE: Transform and Load

[Avoiding the Red Zone]

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

[Patrick Wallek]

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!]

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