Home » RDBMS Server » Server Utilities » sql loader script
sql loader script [message #248736] Sun, 01 July 2007 02:22 Go to next message
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
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
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
SQL*Loader Command-Line Reference

Previous Topic: Privileges required for Datapump / DBMS_DATAPUMP
Next Topic: test trigger
Goto Forum:

Current Time: Fri Oct 28 05:52:16 CDT 2016

Total time taken to generate the page: 0.10935 seconds