To all Guru
I have a file like
test.txt
HTML Code:
111,122,212,123
data11,date12, data13, data14...data1n
data21,date22, data23, data24...data2n
data31,date32, data33, data34...data3n
...
...
..
datan1,daten2, datan3, datan4...datann
END
I have to load this data into oracle , where first line and last line is uniquly idetified and in between these there are details
which I am loading through sql*loader. I am skipping row=1 as that row #1 can be loaded.
1.Can any one tell me is there any way that value of row1 can be directly loaded in table by sql query, if yes then how we pass the value from unix to sql
Let first row data goes into table xyz and mapped column are a,b,c,d.
2. Is there any way to remove END in unix before handing over to loader in unix.
Thanks in advance