Home » RDBMS Server » Server Administration » Re: Procedure Source
Re: Procedure Source [message #370528] Thu, 16 December 1999 05:58
hmg
Messages: 40
Registered: March 1999
Member
procedure =>
select text from user_source
where name = 'YOURPROCEDURE'
and type = 'PROCEDURE'
order by line;

trigger =>
set long 2000
select trigger_body from user_triggers
where trigger_name = 'YOURTRIGGER';

for the other information like "before update"
or "for each row" look at the the other columns
from user_triggers

Report message to a moderator

Previous Topic: Re: PL/SQL Dinamic problem
Next Topic: Delphi 4 / Oracle 8 : Creating Trigger
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Dec 04 05:42:48 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.