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: 12
Registered: April 2017
Junior 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: 1686
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: 8737
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: Repeat Cursor
Next Topic: xml question
Goto Forum:
  


Current Time: Tue Sep 19 10:29:49 CDT 2017

Total time taken to generate the page: 0.01598 seconds