nvl (expr1, expr2)->expr1为NULL,返回expr2;不为NULL,返回expr1。注意两者的类型要一致 nvl2 (expr1, expr2, expr3) ->expr1不为NULL,返回expr2;为NULL,返回expr3。expr2和expr3类型不同的话,expr3会转换为expr2的类型 NULLIF (expr1, expr2) ->相等返回NULL,不等返回expr1 PS:NULL指的是空值,或者非法值。 本文来自ChinaUnix博客,如果查看原文请点:http://blog.chinaunix.net/u/19673/showart_285992.html
I know we can use oracle functions within sqlldr, while I follow the format, but got some error, anybody know why? Thanks. here is a snippet of my control file; load data infile "offer_ref.dat" truncate into table OFFER_REF fields terminated by "|" ( "OFFER_ID", "RESELLER_VERSION_ID", "OFFER_TYPE", "IS_A_LA_CARTE" "nvl(:is_a_la_carte,0)", ) And here is log file after run sqlldr: ...