I execute a pl/sql blcok as following:
begin
select count(*) from sys_base where part_num='11111';
end;
I want to view the execute the sql plan select count(*) from sys_base where
part_num='11111'' .
However, in the v$sql I just get 'begin select count(*) from sys_base where
part_num='11111'' end;'
so I can't view th plan . How can I view the sqls wrapped in pl/sql procedure.
Is there any way I can get the sql plan from a procedure or funcation
