home *** CD-ROM | disk | FTP | other *** search
/ Liren Large Software Subsidy 5 / 05.iso / a / a524 / 39.ddi / install / loader_ver.out next >
Encoding:
Text File  |  1991-03-04  |  1.7 KB  |  64 lines
  1.  
  2.  
  3. #Verifying SQL*Loader ...
  4.  
  5.  
  6.                #########################################
  7.  
  8. #Check the banners:
  9.  
  10. sqlload            1.0.18 - Production
  11.  
  12.  
  13.  
  14.                ########################################
  15.  
  16. #Demo testing:
  17.       # sqlload scott/tiger case1.ctl
  18.       # content of case1.ctl:
  19.       #          *********
  20.       # LOAD DATA
  21.       # INFILE *
  22.       # INTO TABLE DEPT
  23.       # FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '
  24.       # (DEPTNO, DNAME, LOC)
  25.       # BEGINDATA
  26.       # 12,RESEARCH,"SARATOGA"
  27.       # 10,"ACCOUNTING",CLEVELAND
  28.       # 11,"ART",SALEM
  29.       # 13,FINANCE,"BOSTON"
  30.       # 21,"SALES",PHILA.
  31.       # 22,"SALES",ROCHESTER
  32.       # 42,"INTL,SAN FRAN
  33.       #          **********
  34.  
  35.  
  36. SQL*Loader: Version 1.0.18 - Production on Sat Dec 15 06:22:14 1990
  37.  
  38. Copyright (c) Oracle Corporation 1979, 1989.  All rights reserved.
  39.  
  40. Commit point reached - logical record count 7
  41.       
  42.     #Content of case1.out
  43.  
  44. SQL> set echo on
  45. SQL> select * from dept;
  46.  
  47.     DEPTNO DNAME          LOC                                                   
  48. ---------- -------------- -------------                                         
  49.         12 RESEARCH       SARATOGA                                              
  50.         10 ACCOUNTING     CLEVELAND                                             
  51.         11 ART            SALEM                                                 
  52.         13 FINANCE        BOSTON                                                
  53.         21 SALES          PHILA.                                                
  54.         22 SALES          ROCHESTER                                             
  55.         42 INT'L          SAN FRAN                                              
  56.  
  57. 7 records selected.
  58.  
  59. SQL> 
  60.  
  61.  
  62.                #######    Loader.Verify Done    #######
  63.  
  64.