dbTalk Databases Forums  

Triggers de-compile themselves

comp.databases.oracle.misc comp.databases.oracle.misc


Discuss Triggers de-compile themselves in the comp.databases.oracle.misc forum.



Reply
 
Thread Tools Display Modes
  #11  
Old   
Adam Cameron
 
Posts: n/a

Default Re: Triggers de-compile themselves - 08-07-2008 , 11:53 AM






Quote:
You'll need to look in USER_OBJECTS at LAST_DDL_TIME. It reflects the
time of the last compile for an object such as a procedure, package,
function or trigger.

David Fitzjarrell
Cheers David, I'll check that out.

--
Adam


Reply With Quote
  #12  
Old   
Adam Cameron
 
Posts: n/a

Default Re: Triggers de-compile themselves - 08-07-2008 , 11:53 AM






Quote:
You'll need to look in USER_OBJECTS at LAST_DDL_TIME. It reflects the
time of the last compile for an object such as a procedure, package,
function or trigger.

David Fitzjarrell
Cheers David, I'll check that out.

--
Adam


Reply With Quote
  #13  
Old   
Adam Cameron
 
Posts: n/a

Default Re: Triggers de-compile themselves - 08-07-2008 , 11:53 AM



Quote:
You'll need to look in USER_OBJECTS at LAST_DDL_TIME. It reflects the
time of the last compile for an object such as a procedure, package,
function or trigger.

David Fitzjarrell
Cheers David, I'll check that out.

--
Adam


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.