OraFAQ Forum: Server Utilities » SQL*Load with default value

Home » RDBMS Server » Server Utilities » SQL*Load with default value

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

SQL*Load with default value [message #118647]

Fri, 06 May 2005 13:14

vqd2697
Messages: 36
Registered: October 2004

Member

Is this the right syntax to load the default value into the column using SQL*Load?

LOAD DATA APPEND INTO TABLE TESTING
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
TRAILING NULLCOLS
(
PRODUCT_ID Default "TEST",
MODEL_ID,
PEER_ID,
VAR_ID
)

Many thanks,

Vu

Report message to a moderator

Re: SQL*Load with default value [message #118651 is a reply to message #118647]

Fri, 06 May 2005 13:27

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

LOAD DATA APPEND INTO TABLE TESTING
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
TRAILING NULLCOLS
(
PRODUCT_ID constant 'TEST',
MODEL_ID,
PEER_ID,
VAR_ID
)

Report message to a moderator

Re: SQL*Load with default value [message #118659 is a reply to message #118647]

Fri, 06 May 2005 14:19

vqd2697
Messages: 36
Registered: October 2004

Member

Many thanks. It's working now

Report message to a moderator

Previous Topic:	Cannot do import of Function based Indexes
Next Topic:	DATAFILE SYSTEM IN STATUS SYSOFF

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jul 04 06:49:13 CDT 2024