 sql*loader [message #152375] |
Thu, 22 December 2005 14:18  |
arismendez
Messages: 3
Registered: December 2005
|
Junior Member |
|
|
HI,
i will like to know how i can reference fields in sql*loader?? i wanna load a field from one table to another table, how i do that??
tnx for the help...
|
|
|
|
|
|
| Re: sql*loader [message #152539 is a reply to message #152392] |
Fri, 23 December 2005 13:53  |
arismendez
Messages: 3
Registered: December 2005
|
Junior Member |
|
|
INTO TABLE Inicio_Pedimento_500
WHEN registro500='500'
FIELDS TERMINATED BY '|'
(registro500 FILLER POSITION(1),Cve_Tipo_Movimiento, Cve_Patente, Cve_Pedimento, Cve_Aduana_Seccion,
Firma_electronica)
INTO TABLE Fechas_506
WHEN registro506='506'
FIELDS TERMINATED BY '|'
TRAILING NULLCOLS
(registro506 FILLER POSITION(1), Cve_Pedimento, Cve_Tipo_Fecha, Fecha,Cve_Aduana_Seccion, cve_Patente)---
i load rows in diferents tables like the ones in the top, but
in the second into table "fechas_506" i want to get cve_aduana_seccion and cve_patente from the first table "Inicio_Pedimento_500", how i do that??
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
