Oracle Magazine, July/August 2017
Database Developer and DBA ETL Similarly if the LOCATION filename changes from day to day I can override the filename each time I query the external table SQL select from ext_ emp 2 external modify location emp 2016 10 02 dat EMPNO ENAME JOB MGR HIREDATE SAL 7902 FORD ANALYST 7566 03 DEC 81 3000 7934 MILLER CLERK 7782 23 JAN 82 1300 7566 JONES MANAGER 7839 02 APR 81 2975 The EXTERNAL MODIFY clause permits modification of the external table definition without requiring DDL changes and the likely resultant process control implications The EXTERNAL MODIFY clause allows the modification or override of the following clauses only DEFAULT DIRECTORY LOCATION ACCESS PARAMETERS BADFILE LOGFILE DISCARDFILE REJECT LIMIT SUMMARY With Oracle Database 12c Release 2 extensions to external table functionality provide more flexible data access across the datasources that are becoming commonplace in a polyglot persistence landscape Partitioned external tables deliver a more direct mapping to the partitioning mechanism in those nonrelational data ORACLE MAGAZINE JULY AUGUST 2017 99
You must have JavaScript enabled to view digital editions.