is it possible to use the DECODE function (or any other user function) in EXTERNAL TABLE ACCESS PARAMETER syntax?
it is in SQL LOADER isn't it?
in the example below i want to put a default date in case the birthdate is null, and put the city in the address field by using a function i wrote.
ther's a problem with the "double-quoted-string" (KUP-01005)
what is wrong in the syntax? and how can i do it otherwise?
create table ext_tab
default directory my_dir
(fields terminated by ','
missing field values are null
(id position(1:9) integer external(10),
name position(10:59) char nullif name=BLANK,
birthdate position(60:69) date "DD/MM/YYYY" "DECODE(:birthdate,'00/00/0000', '01/01/1900',:birthdate)",
address position(70:169) char nullif address=BLANK "get_city(:address)"