This topic has been archived. It cannot be replied.
-
工作学习 / IT技术讨论 / 请教一个oracle trggier的问题？在server端，如何查看一个trggier的源代码？
-oasis(oasis);
2003-5-12
{41}
(#1185384@0)
-
I use TOAD which is a visual tool from Quest Software.
-schen(欲语还休);
2003-5-13
(#1186497@0)
-
select text from dba_source where name ='XXXX';
or user_source, all_source
-miniboat(够级队长);
2003-5-13
(#1186933@0)
-
我的情况1.没有dba_source, I use desc dba_source...
2.user_source,all_source 没有trigger, 是不是因为我的数据库里面根本就没有trigger?
-oasis(oasis);
2003-5-13
{124}
(#1186952@0)
-
将引号中XXXX换成要查trigger 的名字，注意用大写。若有DBA 权利或select_catalog_role就能访问dba_source. 肯定能查到，不管是trigger还是SP
-miniboat(够级队长);
2003-5-14
(#1187485@0)
-
我的方法SELECT trigger_owner, trigger_name, table_owner, table_name,column_name, column_list, column_usage FROM sys.all_trigger_cols WHERE trigger_owner = :owner AND trigger_name = :trigger_name AND table_owner = :table_owner AND table_name = :table_name, 一定要用where啊, 否则会被DBA kill掉的.
-e_dragon(e_dragon);
2003-5-14
{290}
(#1187895@0)