LuckyLucks
asked on
Bulk insert into global temporary table
Hi ,
create a global temporary table mytable as follows in Oracle:
create global temporary table mytable (
column definitions
) on commit preserve rows;
However, I also want to bulk insert hundreds of rows without writing a SQL insert statement hundreds of time.
select * from mysourcePool; -- hundreds of rows to be used in bulk insert data
How do I combine both operations?
create a global temporary table mytable as follows in Oracle:
create global temporary table mytable (
column definitions
) on commit preserve rows;
However, I also want to bulk insert hundreds of rows without writing a SQL insert statement hundreds of time.
select * from mysourcePool; -- hundreds of rows to be used in bulk insert data
How do I combine both operations?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.