Home » SQL & PL/SQL » SQL & PL/SQL » propblem with array
propblem with array [message #35929] Wed, 24 October 2001 09:30 Go to next message
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 Go to previous messageGo to next message
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 Go to previous message
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


----------------------------------------------------------------------
Previous Topic: order by and group by clause
Next Topic: Pattern matching
Goto Forum:
  


Current Time: Fri Mar 29 08:33:11 CDT 2024