MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.
Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.
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 "LPAD(TRIM(:DIVISION), 2, '0')" )) LOCATION ( DPR_DATA_DIR:'ZISCFUOG1.CSV' ) ) REJECT LIMIT UNLIMITED /
|best datatype for oracle table email creation||8||55|
|oracle numeric condition check||4||27|
|Using SQL*PLUS issue with where statement with trunc function||3||27|