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”...