问题一:
用sql loader导入数据时,怎样跳过某些纪录,比如IP_ADDRESS_SBT_C的值是'1''2''3'以外的纪录就跳过不导入。
TRAILING NULLCOLS
(
RESOURCE_ID SEQUENCE(1,1),
IP_ADDRESS_SBT_C "CASE WHEN :IP_ADDRESS_SBT_C = '1' THEN '04'
WHEN :IP_ADDRESS_SBT_C = '2' THEN '01'
WHEN :IP_ADDRESS_SBT_C = '3' THEN '02'
END",
)问题二:
IP_ADDRESS_SBT_C "CASE WHEN :IP_ADDRESS_SBT_C = '1' THEN '04'
WHEN :IP_ADDRESS_SBT_C = '2' THEN '01'
WHEN :IP_ADDRESS_SBT_C = '3' THEN '02'
WHEN :IP_ADDRESS_SBT_C = '4' THEN '03'
WHEN :IP_ADDRESS_SBT_C = '5' THEN '05'
END",
用sql loader导入数据时,就会出“超出258个字符”的错误,这个问题应该怎样解决?问题三:
RESOURCE_ID “concat('11', lpad(to_char(SEQUENCE(1,1)), 10, '0'))“
这个语句怎么修改?
谢谢!!!
用sql loader导入数据时,怎样跳过某些纪录,比如IP_ADDRESS_SBT_C的值是'1''2''3'以外的纪录就跳过不导入。
TRAILING NULLCOLS
(
RESOURCE_ID SEQUENCE(1,1),
IP_ADDRESS_SBT_C "CASE WHEN :IP_ADDRESS_SBT_C = '1' THEN '04'
WHEN :IP_ADDRESS_SBT_C = '2' THEN '01'
WHEN :IP_ADDRESS_SBT_C = '3' THEN '02'
END",
)问题二:
IP_ADDRESS_SBT_C "CASE WHEN :IP_ADDRESS_SBT_C = '1' THEN '04'
WHEN :IP_ADDRESS_SBT_C = '2' THEN '01'
WHEN :IP_ADDRESS_SBT_C = '3' THEN '02'
WHEN :IP_ADDRESS_SBT_C = '4' THEN '03'
WHEN :IP_ADDRESS_SBT_C = '5' THEN '05'
END",
用sql loader导入数据时,就会出“超出258个字符”的错误,这个问题应该怎样解决?问题三:
RESOURCE_ID “concat('11', lpad(to_char(SEQUENCE(1,1)), 10, '0'))“
这个语句怎么修改?
谢谢!!!
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货