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


Current Time: Tue Dec 06 02:42:02 CST 2016

Total time taken to generate the page: 0.08429 seconds