Mega Code Archive

 

Categories / Oracle PLSQL / Table

 

FIELDS TERMINATED BY WHITESPACE

create table dept ( deptno  number(2),   dname   varchar2(14),   loc     varchar2(13) ) / LOAD DATA                                                   INFILE *                                                    INTO TABLE DEPT                                             REPLACE                                                     FIELDS TERMINATED BY WHITESPACE -- FIELDS TERMINATED BY x'09' (DEPTNO, DNAME, LOC )                                                           BEGINDATA                                                  10    Sales    BC drop table dept;