sql text

12c 0

12c – SQL Text Expansion

No Oracle Database 12c, foi introduzida uma nova funcionalidade, o SQL Text Expansion. E na package DBMS_UTILITY, foi adicionada a procedure EXPAND_SQL_TEXT. SQL> variable retornoclob SQL> begin dbms_utility.expand_sql_text( input_sql_text => ‘select * from emp’, output_sql_text=> :retorno ); end; / PL/SQL procedure successfully completed. SQL> print retorno RETORNO ——————————————————————————- 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” Vamos verificar o efeito com uma política de...