Home » RDBMS Server » Server Utilities » TRAILING NULLCOLS vs TERMINATED BY.... (Oracle 9i.0.2, Windows. )
TRAILING NULLCOLS vs TERMINATED BY.... [message #474501] Mon, 06 September 2010 15:03 Go to next message
muktha_22
Messages: 527
Registered: December 2009
Senior Member
Hi,

I tried to load data of below
But it shows me error.

Into table emp
Trailing nullcols
Terminated by whitespace
(ename, age, city)
Begindata
Mutu 26 mumbai
Krish 25 chennai
Raja 30
Kali mumbai

Thanks in advance
Re: TRAILING NULLCOLS vs TERMINATED BY.... [message #474503 is a reply to message #474501] Mon, 06 September 2010 15:07 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>But it shows me error.
ERROR? What Error? I don't see any error

It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/
Re: TRAILING NULLCOLS vs TERMINATED BY.... [message #474504 is a reply to message #474503] Mon, 06 September 2010 15:11 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Follow the advice Barbara gave you in your previous topic:
http://www.orafaq.com/forum/t/161319/102589/

And FOLLOW THE GUIDELINES. How many times did we tell you to copy and paste what you have?

Regards
Michel
Re: TRAILING NULLCOLS vs TERMINATED BY.... [message #474509 is a reply to message #474504] Mon, 06 September 2010 15:26 Go to previous messageGo to next message
muktha_22
Messages: 527
Registered: December 2009
Senior Member
Hi Michel,

Sorry to bothering you.
I am using mobile internet and which is not connected to the PC.

Thanks
Re: TRAILING NULLCOLS vs TERMINATED BY.... [message #474511 is a reply to message #474501] Mon, 06 September 2010 15:41 Go to previous messageGo to next message
Barbara Boehmer
Messages: 9077
Registered: November 2002
Location: California, USA
Senior Member
You left out the word Fields and the lines are in the wrong order. It should be:

Load data
Infile *
Into table emp
Fields terminated by whitespace
Trailing nullcols
(ename, age, city)
Begindata
Mutu 26 mumbai
Krish 25 chennai

Additionally, you will not be able to load the last row, since the city contains the whitespace delimiter and it is on the next line. To load data that contains your delimiter, the data needs to be enclosed within double quotes and you need to specify that in your control file. If each row of data is not all on one line, then you have to have some means of determining where the end of that row of data is.

Re: TRAILING NULLCOLS vs TERMINATED BY.... [message #474512 is a reply to message #474509] Mon, 06 September 2010 15:42 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>I am using mobile internet and which is not connected to the PC.
If you CAN NOT or WILL NOT follow Posting Guidelines, then please be Professional and do NOT post your spam.
Previous Topic: Loading data to another schema
Next Topic: sqlldr / external table questions
Goto Forum:
  


Current Time: Fri Mar 29 00:26:51 CDT 2024