Search code examples
oracle-databaseinsertoracle-data-integrator

insert rows in different order in oracle table


I am using ODI 12c so the mission is to insert one plat file into one table Oracle

the file is like :

H030201707761133020171085009CA0126357320150506141438SL xxxx xxx xxx                         
***DEB062
09001SD
1003020171085009
....
...
..
.
.
.
0000010000001389600000013896               
509000002
199
***FIN062

I have one table 'A' which constitute one column 'COL' (lenght=250) where I want to save all my file's text (insert line by line). it save it but not like in my file order why !

it save it like

1003020171085009
xxxx
1003020171085009
....
...
..
***FIN062
.
H030201707761133020171085009CA0126357320150506141438SL xxxx xxx xxx
.               
509000002
199
0000010000001389600000013896

Solution

  • We found a solution .If you are using ODI you need only put nothing in INSERT_HINT input text .let it empty like in picture below...And it will save your lines as they are in the plat file

    enter image description here