OraFAQ Forum: Server Utilities » SQL Loader - load a file with a fixed value passed as parameter

Home » RDBMS Server » Server Utilities » SQL Loader - load a file with a fixed value passed as parameter

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

SQL Loader - load a file with a fixed value passed as parameter [message #244793]

Thu, 14 June 2007 02:25

ShaShalini
Messages: 59
Registered: January 2007

Member

Hello

I am using sql loader to load a text file in a temporary table . My problem is that the file does not contain one field. But from my application I can get the value of the field to be inserted in the table.

e.g I have table Temp_hs
( CompanyId Varchar2(10),
Name Varchar2(35),
Address1 Varchar2(35) );

But the file being provided for a particular company has only name and address. I want to load the company name also in the table.

Any idea how I can pass the company Id value for sqlloader to insert it in the temp table.

Thanks

Report message to a moderator

Re: SQL Loader - load a file with a fixed value passed as parameter [message #244815 is a reply to message #244793]

Thu, 14 June 2007 03:09

Michel Cadot
Messages: 68665
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Have a look at Setting a Column to a Constant Value

Regards
Michel

Report message to a moderator

Re: SQL Loader - load a file with a fixed value passed as parameter [message #244819 is a reply to message #244793]

Thu, 14 June 2007 03:12

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

Hi,
YOu can use SEQUENCE for company id field.
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96652/ch10.htm#1006946

check above link

Regards
Taj

Report message to a moderator

Re: SQL Loader - load a file with a fixed value passed as parameter [message #244839 is a reply to message #244815]

Thu, 14 June 2007 05:04

ShaShalini
Messages: 59
Registered: January 2007

Member

Hi

It works with CONSTANT

Thanks

Report message to a moderator

Previous Topic:	received ora-30036
Next Topic:	Problems with import

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Jul 01 08:23:20 CDT 2024