oracle – 在SQL * Plus中描述 – 是调用包还是运行SQL？ (或者

当我在SQL * Plus中描述Oracle TYPE时,SQL * Plus在“引擎盖下”做了什么“ – 它是否调用DBMS_METADATA(或类似的)？还是直接查询数据字典？

或完全不同的东西？

解决方法

对于

create type desc_type as object (
 dummy varchar2(1),constructor function desc_type (a number) return self as result,final member procedure m 

);
/

alter session set sql_trace=true;

desc desc_type

alter session set sql_trace=false;

drop type desc_type
/

我在跟踪文件中找到以下相关的SQL语句：

select procedure#,procedurename,properties,itypeobj# 
  from procedureinfo$where obj#=:1 
 order by procedurename desc,overload# desc

select position#,sequence#,level#,argument,type#,charsetid,charsetform,nvl(length,0),nvl(precision#,nvl(scale,nvl(radix,type_owner,type_name,type_subname,type_linkname,pls_type 
  from argument$
 where obj#=:1 and procedure#=:2 order by sequence# desc

select max(procedure#) from procedurec$where obj#=:1

select max(procedure#) from procedureplsql$where obj#=:1

select max(procedure#) from procedurejava$where obj#=:1

select procedure#,entrypoint# from procedurec$
 where obj#=:1 order by procedure#

select procedure#,entrypoint# 
 from procedureplsql$where obj#=:1 order by procedure#

select procedure#,ownerlength,classlength,methodlength,siglength,flagslength,cookiesize 
  from procedurejava$where obj#=:1 order by procedure#

select ownername,classname,methodname,signature,flags 
  from procedurejava$where obj#=:1 and procedure#=:2 order by procedure#

select count(*) 
  from vtable$where obj#=:1

select vindex,itypetoid,imethod#,iflags,itypeowner,itypename 
  from vtable$where obj#=:1 order by vindex

select externtype,externname 
  from type$where tvoid=:1

因此,在引擎盖下,SQL * Plus使用纯SQL.

（编辑：温州站长网）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!