OraFAQ Forum: Server Utilities

Home » RDBMS Server » Server Utilities » sql loader

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

sql loader [message #176762]

Fri, 09 June 2006 08:27

vasavi.kn
Messages: 3
Registered: May 2006

Junior Member

can u please answer these questions.
I dont know the full concepts of sql loader.
plz help me for these questions.

1.My table structure is like this XYZ (A B C) but in flat file I have written as C B A what it will happen whether it will insert or show error?
2. is it possible to insert alternate rows in table using loader?
3.If the flat file in xl format how will we insert into oracle table?
4.What are the validation we can do in loader

Report message to a moderator

Re: sql loader [message #176828 is a reply to message #176762]

Fri, 09 June 2006 18:59

andrew again
Messages: 2577
Registered: March 2000

Senior Member

http://www.orafaq.com/faq/sql_loader

Save excel file as .csv then you can load it with sqlloader

Report message to a moderator

Re: sql loader [message #176901 is a reply to message #176828]

Sun, 11 June 2006 12:48

Littlefoot
Messages: 21811
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Additionally, as you've said that you don't know the FULL concept of this Oracle utility, here it is.

Report message to a moderator

Previous Topic:	export & import tables and procedures @ schema level
Next Topic:	exp 10.2 & imp 10.1

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Jul 01 01:23:03 CDT 2024