how to check the definition of a stored procedure in TOAD - 未名空间MITBBS历史存档

国际科技财经博客移民网络热点娱乐民生时事公众号

Redian新闻

>未名空间

>Database - 数据库

how to check the definition of a stored procedure in TOAD

how to check the definition of a stored procedure in TOAD# Database - 数据库

e*r2008-09-11 07:09

1 楼

I have a sample like this at hand.
EXEC DBMS_STATS.GATHER_TABLE_STATS(null,'JN_LINK_NAV_SPATIAL',estimate_
percent => 5, cascade => true);
thanks

t*i2008-09-11 07:09

2 楼

this is a procedure GATHER_TABLE_STATS in package DBMS_STATS in SYS schema

e*r2008-09-11 07:09

3 楼

How to visit package DBMS_STATS in SYS schema? hehe

schema

【在 t*********i 的大作中提到】

: this is a procedure GATHER_TABLE_STATS in package DBMS_STATS in SYS schema

t*i2008-09-11 07:09

4 楼

since you are using toad, find SYS in the drop down list on upperleft side,
click it; find the package or procedure label on left panel, click it, then
find the procedure.packages you want to see.
Ask your DBA for privilege if you don't have the permission to view sys/
system objects.
But I doubt they will give it to you if you are not a DBA...

e*r2008-09-11 07:09

5 楼

cool, got it , thanks a lot.

,
then

【在 t*********i 的大作中提到】

: since you are using toad, find SYS in the drop down list on upperleft side,
: click it; find the package or procedure label on left panel, click it, then
: find the procedure.packages you want to see.
: Ask your DBA for privilege if you don't have the permission to view sys/
: system objects.
: But I doubt they will give it to you if you are not a DBA...