Home » RDBMS Server » Server Utilities » With SQL Loader, how to get one concating field into a database column from a data file by combining
With SQL Loader, how to get one concating field into a database column from a data file by combining [message #72820] Fri, 07 November 2003 13:12
Swamy
Messages: 78
Registered: June 2002
Member
I have a data file as mentioned below. I want to conctinate from two different field position to load into a single database column. Is there any way like Position (7:9) || Position (2:5) into COLUMN1 of a database table? Please help me.

123456789
123456789
123456789

Report message to a moderator

Previous Topic: migrate from Oracle 7.3.4 to Oracle 9.2
Next Topic: Open more than one Database
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Jun 30 16:15:28 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.