how to split the row(array) in to fields and store in to oracle database in unix

Shell Programming and Scripting
1

Hi,

the csv file with the delimeter #.

A#B#C#D#E#F#G#H
1#2#3#4#5#6#7#8
Z#x#c#V
7#2#8#9
N.

I want to read the file line by line and store in rowarray.
then the rowarray content should be spilt or made to fields using the delimeter #.
i am not sure can we store the fields in to column array.then it may be loaded to database.

then these fields are to be loaded to a oracle database.
may be in awk.provide the code if possible.

thanks
barani

2

What does the table look like ?

tyler_durden

3

a simple tabel with numbers of columns.
we are going to store the data from the csv file.
there are number of lines in the csv file we have spilt the line using delimeter # in to fields and these fields should be stored to table.
the csv file contains string,int date datatypes.

Thanks
barani

4

Not clear about the exact requirement.But you can do something like:

awk -F# '{ 
row=$0; 
for(i=1;i<=NF;i++) {
 row_split_col=$i;
.......do with the columns...
  }  }' file