Oracle Magazine, July/August 2017
Database Developer and DBA ETL ORACLE MAGAZINE JULY AUGUST 2017 92 AU 7566 JONES MANAGER 783902 APR 812975 20 File emp_ nz dat NZ 8369 SMITH CLERK 790217 DEC 80800 20 NZ 8499 ALLEN SALESMAN 769820 FEB 81160030030 NZ 8521 WARD SALESMAN 769822 FEB 81125050030 NZ 8566 JONES MANAGER 783902 APR 812975 20 To obtain the set of all employees in both regions I can define a partitioned external table by using the conventional list partition syntax SQL create table ext_ emp 2 region varchar 2 3 empno number 4 4 ename varchar2 10 5 job varchar2 9 6 mgr number 4 7 hiredate date 8 sal number 72 9 comm number 72 10 deptno number 2 11 12 organization external
You must have JavaScript enabled to view digital editions.