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
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.,
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
Messages: 25524
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: 65082
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
In addition, I wonder what can be the business need to do that.

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

Current Time: Fri Jul 21 01:51:25 CDT 2017

Total time taken to generate the page: 0.07873 seconds