Connor and Chris will both be at AI World from October 12 to October 17 , the premier Oracle conference of 2025. If you're in Vegas, please come say Hi or pop into our sessions
Thanks for the question, Sai Pradyumn.
Asked: January 20, 2017 - 8:16 am UTC
Last updated: October 09, 2023 - 4:54 am UTC
Version: Oracle 11
Viewed 10K+ times! This question is
SQL> variable rc refcursor SQL> exec open :rc for SELECT * FROM DUAL D99; PL/SQL procedure successfully completed. SQL> SQL> declare 2 l_theCursor integer default dbms_sql.open_cursor; 3 begin 4 dbms_sql.parse( l_theCursor, 'SELECT * FROM DUAL D99', dbms_sql.native ); 5 end; 6 / PL/SQL procedure successfully completed. SQL> SQL> select sql_text, parse_calls, executions 2 from v$sql 3 where sql_text like 'SEL%D99%'; SQL_TEXT PARSE_CALLS EXECUTIONS ---------------------------------------------------------------- ----------- ---------- SELECT * FROM DUAL D99 2 1
Sai Pradyumn, January 21, 2017 - 11:31 am UTC
Alain L., October 06, 2023 - 6:44 am UTC
Check out more PL/SQL tutorials on our LiveSQL tool.
PL/SQL reference manual from the Oracle documentation library