Hi everybody,
We receive a bank statement periodically in .html format
from the site.The data in it is comma-delimited;
sample appearance of data is as below:-
DATE, NARRATION, VALUE DATE,AMOUNT
01.01.2003,00876345,10.01.
2003,1000
05.01.2003,CLEARING CHEQUE,15.01.2003,-5000
10.01.2003,00843692,20.01-
2003,2000
17.02.2003,00518932,23.01-
2003,2000
28.01.2003,00835871,29.01-
2003,2000
04.01.2003,CLEARING CHEQUE,16.01.2003,-5000
The narration column may either contain a cheque no. or a statement -> CLEARING CHEQUE.
The data of this file is to be inserted in an Oracle table BANK_RECO_TEMP whose structure is as follows:-
SQL> desc bank_reco_temp
Name Null? Type
--------------------------
----- -------- ----
BANK_DATE DATE
CHEQUE_NO VARCHAR2(50)
VALUE_DATE DATE
AMOUNT NUMBER(15,2)
Infact in those records where the narration column contains "CLEARING CHEQUE", a NULL should get inserted in the CHEQUE_NO column of the Oracle table.
Iam using Oracle8i Enterprise Edition Release 8.1.5.0.0.
The requirement is that -
What are the various ways in which i can insert this external data into an Oracle table? Please explain each method in detail.
Thanks in advance
Nusrat
Start Free Trial
