Insert data from pl/sql table in Oracle

[dilippanda]

Hi All,

I want to select data from emp table and store them in a pl/sql table.

After storing them in the pl/sql table i want to insert the records into emp1 from pl/sql table .

Note:While inserting records into emp1 i don't want any loops.

Please help me in this.

Thanks,
Dilip

[r035198x]

Hi All,

I want to select data from emp table and store them in a pl/sql table.

After storing them in the pl/sql table i want to insert the records into emp1 from pl/sql table .

Note:While inserting records into emp1 i don't want any loops.

Please help me in this.

Thanks,
Dilip

What do you have so far?
Two satements with structure [CODE=sql]insert into tableName (select * from otherTableName) [/CODE] should be able to do it.

[dilippanda]

Hi,

Actually i have to select data into a pl/sql table using bulk collect and then i want to insert all the records of the pl/sql table into my destination table with out using any loop.

Please guide me with a sample code.

Thanks,
Dilip

What do you have so far?
Two satements with structure [CODE=sql]insert into tableName (select * from otherTableName) [/CODE] should be able to do it.