SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

control file

V prasadJun 15 2012 — edited Jun 15 2012

  Hi,


I have an requirement like to load only particular type of records.


I have a file, it's having 3 columns like below.


ORG_ID,PRIZEID,TOTENTRIES
1056642868|14214|23
1056642868|17838|1
1056642870|14318|9
1056642871|18246|1


I want to load only PRIZEID values '17838' AND  '18246'. rest of the records to be ignored.
how to write control file.

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 13 2012

Added on Jun 15 2012

2 comments

94 views