导出数据时,只有指定了format 参数为3 时,才可以指定字段包围符。此参数无默
认值,如果导出时不指定此参数,导出的数据不会被字段包围符包围。本节的示例
都基于以下表结构和数据内容。
DROP TABLE IF EXISTS message;
COMMIT;
CREATE TABLE
message(id int, name varchar2(20), message varchar2(50));
INSERT INTO message VALUES(1,'Tom','I am Tom');
INSERT INTO message VALUES(2,'小明','HHHH"KKKK');
INSERT INTO message VALUES(3,'Peter','Hello!Hello!');
INSERT INTO message VALUES(4,'Yama','send mail');
INSERT INTO message VALUES(5,'Hellen','');
INSERT INTO message VALUES(6,'','');
INSERT INTO message VALUES(7,'Seven','a book store');
INSERT INTO message VALUES(8,'MMEE','yes');
INSERT INTO message VALUES(9,'George','Thank you.');
INSERT INTO message VALUES(10,'Lastman','no message');
COMMIT;