Home » Applications » Oracle Fusion Apps & E-Business Suite » row terminator in sqlldr control file
row terminator in sqlldr control file [message #603749] Thu, 19 December 2013 01:46 Go to next message
na.dharma@gmail.com
Messages: 82
Registered: May 2008
Location: bangalore
Member

Hi All,

In our functional specification, it's mentioned in the below statement. I have doubt on what is mean by row terminator, as per my understanding there is no option is available (row terminator) in SQLLDR control file.

SqlLdr control file Change:
Change the sqlldr control file to use "§§" as field terminator and "¦¦\n" as row terminator

Thanks
Re: row terminator in sqlldr control file [message #603754 is a reply to message #603749] Thu, 19 December 2013 02:21 Go to previous message
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Have a look at this discussion; pay special attention to Barbara's messages. Hint:

load data
infile test.dat "str X'5E'"
into table test_tab

[Updated on: Thu, 19 December 2013 02:21]

Report message to a moderator

Previous Topic: Query to find the employees EOS Loan
Next Topic: r12.1.3 - 10g server version check
Goto Forum:
  


Current Time: Mon Dec 23 02:07:22 CST 2024