propblem with array [message #35929] |
Wed, 24 October 2001 09:30 |
Ramachandran
Messages: 4 Registered: April 2000
|
Junior Member |
|
|
Guys I am kind of new for pl/sql pl. help me to write pl/sql code with array processing which will process records quick. I am parsing text file utl_file
hello i appreciate any help, if possible pl. email the code
record format willbe
CS0101CALL12345678912/10/200112/11/2001100.00
table name
column name
record_type from position 1,2
group_number 3,2
format_number 5,2
call_type 7,4
cusip 11,9
call_begin_date 20,10
call_end_date 31,10
call_price 41to till end
i have pl/sql procedure it takes 1hr 30 min to insert 1 million record. parser is ready i want pl/sql code for assiginig the value to array and insert into table.
we are on oracle 8.1.7.2 on solaris
----------------------------------------------------------------------
|
|
|
Re: propblem with array [message #35935 is a reply to message #35929] |
Wed, 24 October 2001 15:13 |
Suresh Vemulapalli
Messages: 624 Registered: August 2000
|
Senior Member |
|
|
why you need array processing to insert values into table?. If i understood correctly, you r trying to load data from flat file to tables.
there are 2 options:
load data using SQLloader
or
using utl_file package.
SURESH
----------------------------------------------------------------------
|
|
|
Re: propblem with array [message #35946 is a reply to message #35929] |
Thu, 25 October 2001 04:38 |
Hans
Messages: 42 Registered: September 2000
|
Member |
|
|
I don't understand the structure of the flat file.
What means "column_name" ?
Appears "table_name" and "column_name" at the end of the file ?
Do you insert in one table or in different tables ? Normally the
Recordtype determines which table is the destination.
If you insert in different tables is the record structure the same in all tables ?
I think you have to insert in different tables and you use dynamic sql
for that and now you want use array processing to speed up the
performance. Is this right ?
CS0101CALL12345678912/10/200112/11/2001100.00
table name
column name
record_type from position 1,2
group_number 3,2
format_number 5,2
call_type 7,4
cusip 11,9
call_begin_date 20,10
call_end_date 31,10
call_price 41 to till end
----------------------------------------------------------------------
|
|
|