Click here to Skip to main content
13,406,671 members (46,974 online)
Rate this:
 
Please Sign up or sign in to vote.
See more:
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 20:21pm

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

  Print Answers RSS
Top Experts
Last 24hrsThis month


Advertise | Privacy |
Web04 | 2.8.180221.1 | Last Updated 31 Dec 2012
Copyright © CodeProject, 1999-2018
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100