Home » SQL & PL/SQL » SQL & PL/SQL » sql*loader Create a field in loading
sql*loader Create a field in loading [message #21158] Tue, 16 July 2002 11:02 Go to next message
peter Pang
Messages: 1
Registered: July 2002
Junior Member
I have a field A and B and want to create a field
C=(A+B)/2 with sql*loader.
Is any way to do it. Thank you very much.

Peter
Re: sql*loader Create a field in loading [message #21169 is a reply to message #21158] Wed, 17 July 2002 00:11 Go to previous messageGo to next message
K. Prakash babu
Messages: 46
Registered: July 2001
Member
You can do it using trigger.
Shall you want it to be done with sql*loader only?????
Re: sql*loader Create a field in loading [message #21226 is a reply to message #21158] Thu, 18 July 2002 14:02 Go to previous message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
http://www.orafaq.net/faqloadr.htm#MODIFY
Previous Topic: Spooling takes too much time
Next Topic: How to delete all the rows from a table?
Goto Forum:
  


Current Time: Fri Apr 19 09:50:57 CDT 2024