Oracle SQL loader Use Cases

Oracle SQL loader Use Cases

Listing 1: ---------------------- dir *. csvtype abc.csv sqlplus scott/tiger @ orclcreate table emp1 (name varchar2 (80), salary number); hostnotepad abc. ctlload datainfile abc.csv into table emp fields terminated by ', 'trailing NULLCOLS (name, salary) sqlldr scott/tiger @ orcl abc. ctlexitshow userselect * from emp1; receivlisting 2: sorted set heading offset pagesize 0 spool c: \ whatever.txt select object_name | ',' | object_type from all_objectsspool offcreate table loaded asselect object_name, object_type from all_objectswhere 1 = 0; load datainfile 'C: \ whatever.txt 'into table loaded truncatewhen object_type <> 'index' fields termindated by',' (OBJECT_NAME, OBJECT_TYPE "TRIM (: object_type) ") sqlldr control = c: \ whatever. ctl log = c: \ whatever. log ----------------------------------- present by dylan.