（52-27）第48/49次：2016-01-18星期一，2016-01-20星期三

botang

parfile:

1. exclude=table:"in ('T_BANK_INVOICE')", procedure:" in ('SECURE_DML')"
   
2. query=hr.employees:"where department_id=90"

复制代码

（52-27）上完1Z0-052第17章

1. CREATE TABLE ext1
   
2.                   (employee_id       NUMBER(4),
   
3.                    first_name        VARCHAR2(20),
   
4.                     last_name         VARCHAR2(25),
   
5.                      hire_date         DATE)
   
6. ORGANIZATION EXTERNAL
   
7.      ( TYPE ORACLE_LOADER DEFAULT DIRECTORY dir1
   
8.        ACCESS PARAMETERS
   
9.        ( records delimited by newline
   
10.          badfile 'ext1_%a_%p.bad'
    
11.          logfile 'ext1_%a_%p.log'
    
12.          fields terminated by ','
    
13.          missing field values are null
    
14.      ( employee_id, first_name, last_name,
    
15.       hire_date char date_format date mask "dd-mon-yyyy"))
    
16.      LOCATION (dir1:'ext1.dat', dir2:'ext2.dat') )
    
17.      PARALLEL 20   REJECT LIMIT UNLIMITED;
    
18.      
    
19.      select  * from ext1;
    
20.      
    
21.      delete from ext1;
    
22.      
    
23.      update ext1 set first_name='XXX' where employee_id=100;
    
24.      
    
25.      create index ind1 on ext1(employee_id);
    
26.      
    
27.      alter  table ext1 add constraint c1 check ( employee_id <500 ) ;
    
28.      
    
29.      select  * from user_tables t where t.TABLE_NAME='EXT1';
    
30.      
    
31.      select  * from user_external_tables ;
    
32.      
    
33.      ----
    
34.      select  * from tpasswd;
    
35.      
    
36.      create table tpasswd (
    
37.          i_name  varchar2(50),
    
38.          i_passwd  char(1),
    
39.          i_uid  number,
    
40.          i_gid number,
    
41.          i_comment  varchar2(70),
    
42.          i_home  varchar2(30),
    
43.          i_shell  varchar2(30))  ;
    
44.      
    
45. drop table tpasswd;
    
46. 
    
47. select  * from tpasswd;
    
48. ---
    
49. CREATE TABLE ext_emp_query_results
    
50. ORGANIZATION EXTERNAL
    
51.   (
    
52.     TYPE ORACLE_DATAPUMP
    
53.     DEFAULT DIRECTORY dir1
    
54.     LOCATION (dir1:'emp1.exp',dir2:'emp2.exp')
    
55.   )
    
56. PARALLEL 20
    
57. AS
    
58. SELECT e.first_name,e.last_name,d.department_name
    
59. FROM   employees e, departments d
    
60. WHERE  e.department_id = d.department_id AND
    
61.        d.department_name in
    
62.                      ('Marketing', 'Purchasing');
    
63.                      
    
64. delete from ext_emp_query_results;
    
65. 
    
66. select  * from t05217_e;
    
67. 
    
68. select  * from user_encrypted_columns;
    
69. 
    
70. create table t5  ( a  encrypt identified by "redhat123")
    
71. ORGANIZATION EXTERNAL
    
72. ( TYPE ORACLE_DATAPUMP
    
73.    DEFAULT DIRECTORY "DIR1"
    
74.    LOCATION('empnew.dat') )
    
75. REJECT LIMIT UNLIMITED
    
76. as select * from t05217_e;
    
77. 
    
78. 
    
79. create table t4( a  number )   
    
80. ORGANIZATION EXTERNAL
    
81. ( TYPE ORACLE_DATAPUMP
    
82.    DEFAULT DIRECTORY "DIR1"
    
83.    LOCATION('emp_ext.dat') )
    
84. REJECT LIMIT UNLIMITED;
    
85. 
    
86. create table t6( a  number )   
    
87. ORGANIZATION EXTERNAL
    
88. ( TYPE ORACLE_DATAPUMP
    
89.    DEFAULT DIRECTORY "DIR1"
    
90.    LOCATION('empnew.dat') )
    
91. REJECT LIMIT UNLIMITED;
    
92. 
    
93. 
    
94. 
    
95. select  * from t6;
    
96. 
    
97. create table t7( a  number   encrypt  identified by "redhat123")   
    
98. ORGANIZATION EXTERNAL
    
99. ( TYPE ORACLE_DATAPUMP
    
100.    DEFAULT DIRECTORY "DIR1"
     
101.    LOCATION('empnew.dat') )
     
102. REJECT LIMIT UNLIMITED;
     
103. 
     
104. select  * from t7;

复制代码