Oracle Magazine, Jan/Feb 2018
Database Developer and DBA ETL KING BLAKE TURNER 7844 SALES KING BLAKE WARD 7521 SALES KING CLARK 7782 ACCOUNTING KING CLARK MILLER 7934 ACCOUNTING KING JONES 7566 RESEARCH KING JONES FORD 7902 RESEARCH KING JONES FORD SMITH 7369 RESEARCH KING JONES SCOTT 7788 RESEARCH KING JONES SCOTT ADAMS 7876 RESEARCH Note in the previous example that even if a table contains a hierarchical relationship ORACLE MAGAZINE JANUARY FEBRUARY 2018 96 it can still be joined to other tables FILTERING VERSUS NAVIGATION Navigating the hierarchy is quite distinct from the filtering that comes with WHERE clause predicates in the SQL statement To demonstrate this the 14 rows in the EMP table have been duplicated to be a set of rows for multiple geographic regions as shown in Listing 7 There are now 42 rows in the table the standard set of 14 rows in each of the NORTH SOUTH and EAST regions Code Listing 7 Duplicating EMP table rows for multiple regions SQL alter table emp add region varchar2 10 Table altered
You must have JavaScript enabled to view digital editions.