重庆思庄Oracle、Redhat认证学习论坛

标题: 外部表例子 [打印本页]

作者: 郑全 时间: 2016-6-5 16:34
标题: 外部表例子
CREATE TABLE emp_load
( EMPLOYEE_ID number(10),
  last_name varCHAR2(20),
  department_id number(10),
  email varchar2(20),
  HIRE_DATE DATE,
  SALARY number(10))
  ORGANIZATION EXTERNAL
  (TYPE ORACLE_LOADER
DEFAULT DIRECTORY dir_exp
ACCESS PARAMETERS
   (FIELDS TERMINATED BY ','
   LRTRIM
   missing field values are null
   (EMPLOYEE_ID,
      LAST_NAME CHAR,
      department_id,
      email CHAR,
      HIRE_DATE DATE "fmYYYY/MM/DD",
      SALARY)
   )
LOCATION ('emp.dat')
);

关键在:
  missing field values are null

欢迎光临重庆思庄Oracle、Redhat认证学习论坛 (http://bbs.cqsztech.com/)