demo12.sql

来自「VC++是微软公司开发的一个IDE(集成开发环境),换句话说,就是使用c++的一」· SQL 代码 · 共 18 行

select session_id sid, owner, name, type, 
    mode_held held, mode_requested request
from dba_ddl_locks;
create or replace procedure p as begin null; end;
/
exec p
select session_id sid, owner, name, type,
       mode_held held, mode_requested request
  from dba_ddl_locks
/
alter procedure p compile;
select session_id sid, owner, name, type,
       mode_held held, mode_requested request
  from dba_ddl_locks
/