为快捷显示Oracle执行计划创建存储过程

第一种:不设置输出格式参数,即用默认的 SQL> create or replace procedure sql_explain(v_sql varchar2) 2 is 3 type explain_cursor_type is ref cursor; 4 explain_cursor explain_cursor_type; 5 a varchar2(2048); 6 begin 7 execute immediate 'explain plan for '||v_sql; 8 open explain_cursor fo