SCOTT,ANALYST
KING,PRESIDENT
FORD,ANALYST
c、从数据文件读入并写入到表
scott@USBO> create table tb_emp(val varchar2(30), file_name varchar2(10));
scott@USBO> exec read_demo('emp.txt','db_utl_dir'); -->调用过程来实现，代码见文章尾部
PL/SQL procedure successfully completed.
scott@USBO> select * from tb_emp;
VAL FILE_NAME
----------------------------- ---------------------
JONES,MANAGER emp.txt
BLAKE,MANAGER emp.txt
CLARK,MANAGER emp.txt
SCOTT,ANALYST emp.txt
KING,PRESIDENT emp.txt
FORD,ANALYST emp.txt
6 rows selected.
d、读写混合模式示例
scott@USBO> set serveroutput on;
scott@USBO> exec rw_demo; -->调用过程来实现，代码见文章尾部
14
14
28
42
56
71
84
PL/SQL procedure successfully completed.
scott@USBO> ho ls
out.txt x.txt
scott@USBO> ho more out.txt
JONES,MANAGER
JONES,MANAGER
BLAKE,MANAGER
CLARK,MANAGER
SCOTT,ANALYST
KING,PRESIDENT
FORD,ANALYST
相关阅读：