OraFAQ Forum: SQL & PL/SQL » oracle external table load

Home » SQL & PL/SQL » SQL & PL/SQL » oracle external table load (oracle 11g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

oracle external table load [message #664518]

Thu, 20 July 2017 12:07

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) "

Report message to a moderator

Re: oracle external table load [message #664520 is a reply to message #664518]

Thu, 20 July 2017 12:09

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

Barbara Boehmer
Messages: 9106
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'

Report message to a moderator

Previous Topic:	utl_file issue
Next Topic:	foreign key conflict issue

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Sep 22 16:22:25 CDT 2026