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

Report message to a moderator

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.

Report message to a moderator

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

Report message to a moderator

Previous Topic: SQL*Loader-524 Error.. need help
Next Topic: Renaming column names
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Apr 25 05:00:04 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.