Home » RDBMS Server » Server Utilities » Re: When clause of SQL*Loader
Re: When clause of SQL*Loader [message #368085] Mon, 13 March 2000 07:48
Jason
Messages: 32
Registered: February 1999
Member
Look at this example, (01) is the first character, (30:37) are characters 30 to 37:
LOAD DATA
APPEND
INTO TABLE my_selective_table
WHEN (01) 'H' and (01) 'T' and (30:37) = '19991217'
(
region CONSTANT '31',
service_key POSITION(01:11) INTEGER EXTERNAL,
call_b_no POSITION(12:29) CHAR
)

Please note that this examle is on the OraFaq site under the Sql*Loader link in the left hand navigation frame. Its pays to have a good look around.
Previous Topic: Re: Executing Mutliple CTL files from sqlloader
Next Topic: Oracle* and windows 2000
Goto Forum:
  


Current Time: Mon May 23 21:31:29 CDT 2022