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
Previous Topic: Re: PL/SQL Dinamic problem
Next Topic: Delphi 4 / Oracle 8 : Creating Trigger
Goto Forum:
  


Current Time: Fri Mar 29 07:56:20 CDT 2024