What about a command to ensure column 1 of the input is not blank?
of course I can use when clause on column to check whether its null or not. But when the "When Clause" fails , the oracle Oracle concurrent program give a warning . My goal is how to avoid the warning
Use like below
OPTIONS (SKIP = 1)
INTO TABLE xxxxx
FIELDS TERMINATED BY "," optionally enclosed by '"'
ORGANIZATION_CODE CHAR "TRIM(:ORGANIZATION_CODE)",
LOCATOR_NAME CHAR "TRIM(:LOCATOR_NAME)",
DESCRIPTION CHAR "TRIM(:DESCRIPTION)",
INVENTORY_LOCATION_TYPE CHAR "TRIM(:INVENTORY_LOCATION_TYPE)",
SUBINVENTORY_CODE CHAR "TRIM(TRANSLATE (:SUBINVENTORY_CODE,'*' || CHR (13) || CHR (10),'*'))"