Hi all,
has anybody got experience with DBI. I'm retrieving data from Oracle and
running programs quite nicely on te output but after that I need to get my
results back into a table.
My results are in a comma delimited file. I need to read through the file
adding each line as a record in the table using the SQL:
my $query1=<<"QUERY";
INSERT INTO DIFFAMNTS VALUES ('PK',9197,171509,'THIS IS A TEST2
ROW','AA',1,77120,101032)
QUERY
Obviously thats a test line and the values I have in the insert would need
to be replaced with variables from the csv file. I'll probably create those
with a simple split.
any ideas?
Mark
_____________________________________________
Mark Martin
Computer Centre
National University of Ireland Maynooth
Tel: (01)708 4716/3830
Fax: (01)628 6249
