sreej
asked on
ORACLE PL/SQL BULK INSERT
Hi experts,
I have PL/SQL procedure, which fetchs row and concatenate rows into a column with a delimiter and insert on to table. This process is done row by row.
For example,
source table
COLUMN1 COLUMN2
1 A
1 B
1 C
2 D
2 E
3 F
3 A
output table
COLUMN1 COLUMN2
1 A,B,C
2 D,E
3 F,A
Could any one provide/suggest how to process and insert the records in bulk.
Thanks
sree
I have PL/SQL procedure, which fetchs row and concatenate rows into a column with a delimiter and insert on to table. This process is done row by row.
For example,
source table
COLUMN1 COLUMN2
1 A
1 B
1 C
2 D
2 E
3 F
3 A
output table
COLUMN1 COLUMN2
1 A,B,C
2 D,E
3 F,A
Could any one provide/suggest how to process and insert the records in bulk.
Thanks
sree
ASKER CERTIFIED SOLUTION
![Avatar of Guy Hengel [angelIII / a3]](https://filedb.experts-exchange.com/files/public/2013/11/25/ddbe0ea6-aa6e-4279-b781-57b735dd3ea0.jpeg){kind=small}
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.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER