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
verukonda2004
Messages: 1
Registered: July 2007
Junior Member
Hello,

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.

Report message to a moderator

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: 68665
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

Regards
Michel

Report message to a moderator

Previous Topic: Tns service name
Next Topic: Drop all users in the database
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Jul 01 11:02:31 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.