    SELECT /*+ordered */
           d.deptno, d.dname, SUM(e.sal + NVL(e.comm, 0)) AS sal
     FROM dept d
-    LEFT JOIN (SELECT * 
-                 FROM emp 
+    LEFT JOIN (SELECT *
+                 FROM emp
                 WHERE hiredate > DATE '1980-01-01') e
       ON e.deptno = d.deptno
    GROUP BY d.deptno, d.dname;

  FROM plscope_naming
 WHERE owner = USER
   AND object_name = 'PKG'
 ORDER BY object_type, line, col;  

-- ## View PLSCOPE_INS_LINEAGE


COLUMN COLUMN_NAME FORMAT A11
COLUMN OBJECT_NAME FORMAT A13
COLUMN OPERATION FORMAT A9
SELECT *
  FROM plscope_col_usage
 WHERE procedure_name IN ('LOAD_FROM_TAB', 'LOAD_FROM_SYN_WILD')
 ORDER BY owner, object_type, object_name, line, col, direct_dependency;

-- ## View PLSCOPE_NAMING

-- ### Create/compile a package
