Home » SQL & PL/SQL » SQL & PL/SQL » oracle external table load (oracle 11g)
oracle external table load [message #664518] Thu, 20 July 2017 12:07 Go to next message
POGAKU_SANTHOSH
Messages: 39
Registered: April 2017
Member
hi team,


I have a txt file which is in tab delimited file i want to load the file into database using oracle external table . I am using the below piece in my code but its not working can any one has a solution ?

"Feilds seperated by 'char(9) "

Re: oracle external table load [message #664520 is a reply to message #664518] Thu, 20 July 2017 12:09 Go to previous messageGo to next message
Bill B
Messages: 1971
Registered: December 2004
Senior Member
that's because it's not Feilds seperated by 'char(9)), its

FIELDS TERMINATED BY CHR(9)

[Updated on: Thu, 20 July 2017 12:12]

Report message to a moderator

Re: oracle external table load [message #664579 is a reply to message #664520] Sun, 23 July 2017 19:09 Go to previous message
Barbara Boehmer
Messages: 9077
Registered: November 2002
Location: California, USA
Senior Member
Tab delimited is x'9' not char(9), so it should be:

FIELDS TERMINATED BY x'9'
Previous Topic: utl_file issue
Next Topic: foreign key conflict issue
Goto Forum:
  


Current Time: Thu Mar 28 18:03:16 CDT 2024