Mega Code Archive

 

Categories / Oracle PLSQL / Table

 

Load data and set field terminated sign and OPTIONALLY ENCLOSed sign

create table dept ( deptno  number(2),   dname   varchar2(14),   loc     varchar2(13) ) / LOAD DATA                                                   INFILE *                                                    INTO TABLE DEPT                                             REPLACE                                                     FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'         (DEPTNO, DNAME, LOC )                                                           BEGINDATA                                                  10,Sales,"""USA""" 20,Accounting,"BC,USA" 30,Consulting,BC 40,Finance,BC 50,"Finance","",BC 60,"Finance",,BC drop table dept;