How to insert data into two tables using single control file?
- 3 Answers
- 16683 Views
- Oracle, VTI, I also Faced
- E-Mail Answers
Answer Posted / rajiv
LOAD DATA
APPEND
DISCARDMAX 9999999
INTO TABLE UPLOAD_HDR
WHEN agreementno='~'
FIELDS TERMINATED BY ","
(
AGREEMENTNO CHAR(20),
FILENAME CHAR(30),
BATCHID constant 112)
INTO TABLE UPLOAD_TMP
WHEN agreementno <>'~'
FIELDS TERMINATED BY ","
TRAILING NULLCOLS
(
AGREEMENTNO POSITION(1) CHAR(20),
EMI_AMT INTEGER EXTERNAL(16),
BATCHID constant 112)
| Is This Answer Correct ? | 10 Yes | 1 No |
Post New Answer View All Answers
Do you know what is applysys in oracle application database schema, what is apps?
Are you familiar with internet architecture of oracle apps 11i?
Which oracle apps version you are very confident in?
What is oracle soa suite?
How to move the one file from one instance to another instance? And your scripts also?
please any one provide the oracle erp technical interview questions on modules(PO,AP,AR,INV,GL,OM)wise to my mail id..narendra_609@yahoo.co.in
Can you define an erp system?
what are the balancing segments in AR?
Which oracle applications pl/sql standard apis you are familiar, have you used most of them?
List the types of flexfield?
What are the Standard Reports and Forms in HRMS?
can we get profile values in report without using user exists is it possible how?
what is the difference between request group and request security in oracle apps?
How can a process be deployed in soa?
please send me forms, xml pulisher questions,answers
