Home » SQL & PL/SQL » SQL & PL/SQL » Trigger Related Questions
Trigger Related Questions [message #244726] Wed, 13 June 2007 23:29 Go to next message
akkumar81
Messages: 144
Registered: February 2007
Location: india
Senior Member

Dear Friends,

My Oracle Version 9i.Is possible to create DDL statements using
execute immmediate in Trigger.

Expecting Your Replies.,
Arunkumar
Re: Trigger Related Questions [message #244728 is a reply to message #244726] Wed, 13 June 2007 23:32 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
Yes, but it is a bad,bad, bad & VERY bad idea to do so.
Re: Trigger Related Questions [message #244756 is a reply to message #244726] Thu, 14 June 2007 01:07 Go to previous message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
In addition, I wonder what can be the business need to do that.

Regards
Michel
Previous Topic: can i put "set serveroutput on" inside the procedure ?
Next Topic: self join oracle
Goto Forum:
  


Current Time: Sat Dec 10 01:21:57 CST 2016

Total time taken to generate the page: 0.11586 seconds