de excel a oracle

[MarioHeredia]

Usas INTEGER EXTERNAL...

example...

LOAD DATA
INFILE '/home/mario/prueba.txt'
TRUNCATE
INTO TABLE TABLE_FORO_DEL_WEB
TRAILING NULLCOLS
( FECHA DATE "YYYY/MM/DD_HH24:MI:SS" terminated by whitespace,
CAMPO_CHAR CHAR terminated by whitespace,
CAMPO_NUMERICO INTEGER EXTERNAL terminated by whitespace,
OTHER_CAMPO_CHAR CHAR terminated by whitespace
)


Sldos, Mario.