URGENT-*9 [message #73648] |
Fri, 11 June 2004 03:18 |
Bharath Kumar V
Messages: 4 Registered: April 2004
|
Junior Member |
|
|
Hi,
I am Having code in control file as below
load data
into table table1
when col1 = '000'
col1 POSITION (1:3),
col2 POSITION (*4),
i want to know what this *9 will do. Will it take 4th position of the data file or some thing else. PLease help
Regards
Bharath.
|
|
|
Re: URGENT-*9 [message #73650 is a reply to message #73648] |
Fri, 11 June 2004 06:33 |
Frank Naude
Messages: 4580 Registered: April 1998
|
Senior Member |
|
|
Hi,
Looks like invalid syntax to me. "*" is the current position. "*+4" will be the current position advanced by 4 positions.
For more info, look at "Specifying the Position of a Data Field" in the Oracle Utilities Users Guide.
Best regards.
Frank
|
|
|
Re: URGENT-*9 [message #73696 is a reply to message #73650] |
Mon, 21 June 2004 02:55 |
Ronald
Messages: 15 Registered: October 2001
|
Junior Member |
|
|
Hi,
I want to upload a text file to a table(Coma separated). Can anybody give me step by step help. If I have to use SQL Loader, Pls give me the command.
Thanx in advance,
Ronaldo.
|
|
|