Home » RDBMS Server » Server Utilities » passing value
passing value [message #186280] Mon, 07 August 2006 05:02
sanjit
Messages: 65
Registered: November 2001
Member
How to pass the first row value in Sql*loader program.

I have a datafile coming as 
DEPT,INDICATOR
EMP_ID,EMP_NAME,POSITION
....
EMP_ID,EMP_NAME,POSITION
END

and I my temp table is 
TEMP_TABLE
EMP_ID
EMP_NAME
POSITION,
DEPT
INDICATOR


can anyone tell me, what is best way to pass dept and indicator value in easch row.

should it required to create another table or does it works here.

Report message to a moderator

Previous Topic: Re:Re: import problem with oracle 10.1.0 on Win2K
Next Topic: Copy data from one oracle server to another
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Jun 30 06:44:03 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.