分类:
2008-10-28 14:19:27
D:\OraDoc\OracleTools\ociuldr>cat a.ctl LOAD DATA INFILE 'emp.txt' INTO TABLE empt APPEND FIELDS TERMINATED BY '#' TRAILING NULLCOLS ( EMPNO , ENAME CHAR , JOB CHAR , MGR , HIREDATE DATE , SAL , COMM , DEPTNO ) D:\OraDoc\OracleTools\ociuldr>sqlldr scott/tiger@eygle2 control=a.ctl SQL*Loader: Release 10.2.0.1.0 - Production on 星期二 2月 27 16:01:24 2007 Copyright (c) 1982, 2005, Oracle. All rights reserved. 达到提交点 - 逻辑记录计数 14 D:\OraDoc\OracleTools\ociuldr>sqlplus scott/tiger@eygle2 SQL*Plus: Release 10.2.0.1.0 - Production on 星期二 2月 27 16:01:37 2007 Copyright (c) 1982, 2005, Oracle. All rights reserved. 连接到: Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production With the Partitioning option JServer Release 9.2.0.4.0 - Production SQL> set linesize 120 SQL> select * from empt; EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO ---------- ---------- --------- ---------- -------------- ---------- --- 7369 SMITH CLERK 7902 17-12月-80 800 20 7499 ALLEN SALESMAN 7698 20-2月 -81 1600 300 30 7521 WARD SALESMAN 7698 22-2月 -81 1250 500 30 7566 JONES MANAGER 7839 02-4月 -81 2975 20 7654 MARTIN SALESMAN 7698 28-9月 -81 1250 1400 30 7698 BLAKE MANAGER 7839 01-5月 -81 2850 30 7782 CLARK MANAGER 7839 09-6月 -81 2450 10 7788 SCOTT ANALYST 7566 19-4月 -87 3000 20 7839 KING PRESIDENT 17-11月-81 5000 10 7844 TURNER SALESMAN 7698 08-9月 -81 1500 0 30 7876 ADAMS CLERK 7788 23-5月 -87 1100 20 7900 JAMES CLERK 7698 03-12月-81 950 30 7902 FORD ANALYST 7566 03-12月-81 3000 20 7934 MILLER CLERK 7782 23-1月 -82 1300 10 已选择14行。 SQL>