Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: Oracle
hi ,
 
i am new to oracle , i got one requirement like
 
Prob: already we are using sql*loader to load client flat file data into one table(temp).
to distribute from this temp table to other table we are written on Stored Procedure.
 
now recently client added 100 columns to the flatfile.now we have to write conditions based on client flatfile columns and these should be stored in existing table columns
 
ex: assume one table is there like
 
create table ELIG(EBO1 VARCHAR(10),EB02 VARCHAR(20),)
 
CLIENT FLAT FILE CONTAINS COLUMNS LIKE
 
1ACTIVE 1COVEREDINNET 1COVEREDOUTNET 2ACTIVE 2COVEREDINNET 2COVEREDOUTNET 4ACTIVE 4COVEREDINNET 4COVEREDOUTNET 5ACTIVE 5COVEREDINNET

Y Y N Y Y N Y Y N Y Y
Y Y N Y Y N Y Y N Y Y
Y Y Y Y Y Y Y Y Y Y Y
Y Y Y Y Y Y Y Y Y Y Y
 

now i have to store the above flat file every number data into existing elig table 2 columns based on condition.here column numbers in flat file are fixed.ex 1 active column number in flat file is always 30 only
 
please share some ideas with me
Posted 30-Dec-12 19:21pm

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 OriginalGriff 355
1 Maciej Los 180
2 Richard MacCutchan 115
3 arvind mepani 104
4 Tino Fourie 92


Advertise | Privacy | Mobile
Web01 | 2.8.140709.1 | Last Updated 31 Dec 2012
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid