Home » RDBMS Server » Server Utilities » sql loader script
sql loader script [message #248736] Sun, 01 July 2007 02:22 Go to next message
sunithamcsit
Messages: 1
Registered: June 2007
Junior Member
hi to all

I am very new to sql loader, now I loaded 26 tables into the database, in that tables two tables are having same data only one column is difference. so,now i have to store this table using insert command through script.

can anyone please let me know the structure of that type insert command.

at the same time i need to set default value for one field in
control file, please let me know how to set default value, it is an numeric value.


please help me...
Re: sql loader script [message #248852 is a reply to message #248736] Mon, 02 July 2007 08:11 Go to previous messageGo to next message
MarcL
Messages: 455
Registered: November 2006
Location: Connecticut, USA
Senior Member
Did you even bother to try reading the manual ?
Re: sql loader script [message #248874 is a reply to message #248852] Mon, 02 July 2007 09:27 Go to previous message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
SQL*Loader Command-Line Reference

http://www.lc.leidenuniv.nl/awcourse/oracle/server.920/a96652/ch04.htm
Previous Topic: Privileges required for Datapump / DBMS_DATAPUMP
Next Topic: test trigger
Goto Forum:
  


Current Time: Wed Jun 26 13:53:18 CDT 2024