Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.
CREATE TABLE diff (plan_ctry VARCHAR2(3), division VARCHAR2(2)) ORGANIZATION EXTERNAL ( DEFAULT DIRECTORY DPR_DATA_DIR ACCESS PARAMETERS(RECORDS DELIMITED BY NEWLINE BADFILE DPR_LOG_DIR:'diff.bad' DISCARDFILE DPR_LOG_DIR:'diff.dsc' LOGFILE DPR_LOG_DIR:'diff.log' FIELDS TERMINATED BY ',' MISSING FIELD VALUES ARE NULL REJECT ROWS WITH ALL NULL FIELDS (plan_ctry CHAR, division CHAR(2) "RTRIM(CHR(13))" )) LOCATION ( DPR_DATA_DIR:'test.csv' ) ) REJECT LIMIT UNLIMITED /
|How to View Errors for Materialized Views in Oracle SQL Developer||2||53|
|Oracle SQL Char delimited error||5||29|
|where to add if or exception to exit and not end email when no datafound||1||40|
|Identify records which do NOT qualify for a view||9||19|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
9 Experts available now in Live!