Home » RDBMS Server » Server Utilities » SQLLoader: how to concatenate differents positions on one column
SQLLoader: how to concatenate differents positions on one column [message #69568] Fri, 01 February 2002 05:59 Go to next message
petiteau serge
Messages: 2
Registered: February 2002
Junior Member
To create a table with a SQLloader utility,
i need to concatenate differents position of a file to create one single column. Is it possible to use pipe to concatenate differents position in the ctl file. the file.
Thanks
Re: SQLLoader: how to concatenate differents positions on one column [message #69570 is a reply to message #69568] Fri, 01 February 2002 18:21 Go to previous messageGo to next message
Suresh Vemulapalli
Messages: 624
Registered: August 2000
Senior Member
yes possible...

LOAD
...
..

(dummy1 filler position(01:03),
field1 position(05:07),
dummy2 filler position(08:12),
field2 ":dummy1||:dummy2"
)

Note: dummy1,dummy2 are not columns in table.
Re: SQLLoader: how to concatenate differents positions on one column [message #70092 is a reply to message #69568] Thu, 11 April 2002 06:01 Go to previous message
petiteau serge
Messages: 2
Registered: February 2002
Junior Member
the solution with the dummy fields goes in abend
(ORA-01008: Toutes les variables ne sont pas liées)
have you an idea?
Thanks
Previous Topic: SQL*Loader-524 Error.. need help
Next Topic: Renaming column names
Goto Forum:
  


Current Time: Sun Dec 04 07:07:01 CST 2022