Home » RDBMS Server » Server Utilities » Reading Specific colums from data file
Reading Specific colums from data file [message #249393] Wed, 04 July 2007 04:39 Go to next message
Messages: 1
Registered: July 2007
Junior Member

Could any body can answer to my question.

Below I am giving the Case:

I am having a data file names SOURCE1.txt containing columns c1,c2,c3,c4 with '~' delimited.

My staging table structure is completely different from source1.txt. My staging table has the following structure like

STG_DATA(c11 varchar2(100),c12 varchar2(100),LOAD_DT date)

Challenge is: I need to pick up only c1 and c4 columns from SOURCE1.txt file. Only C1 and c4 would have to be loaded in to STG_DATA table.

Thanks in advance.
Re: Reading Specific colums from data file [message #249418 is a reply to message #249393] Wed, 04 July 2007 07:16 Go to previous message
Michel Cadot
Messages: 65144
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Database Utilities
Part II SQL*Loader
Chapter 9 Field List Reference
Section Specifying Columns and Fields
Subsection Specifying Filler Fields

Previous Topic: Drop all users in the database
Next Topic: Do we need to have a DBA privilege inorder to use IMP/EXP
Goto Forum:

Current Time: Mon Aug 21 01:43:51 CDT 2017

Total time taken to generate the page: 0.01313 seconds