Oracle Magazine, May/June 2019
Database Developer and DBA ETL ORACLE MAGAZINE MAY JUNE 2019 114 4 end 5 PL SQL procedure successfully completed SQL print c C SELECT A1 EMPNO EMPNO A1 ENAME ENAME A1 JOB JOB A1 MGR MGR A1 HIREDATE HIREDATE A1 SAL SAL A1 COMM COMM A1 DEPTNO DEPTNO FROM SCOTT EMP A1 Expanding the SQL text may seem like a waste of time and effort but here is another example of why looks can be deceiving when youre faced with a SQL statement for tuning Listing 3 shows a view that joins two database dictionary objects appropriately named LOOKS_ SO_ INNOCENT Listing 3 View definition for LOOKS_ SO_ INNOCENT SQL create or replace 2 view LOOKS_ SO_ INNOCENT as 3 select 4 o owner
You must have JavaScript enabled to view digital editions.