Home » SQL & PL/SQL » SQL & PL/SQL » DDL statement in Procedure (Win Xp, Oracle 10g)
DDL statement in Procedure [message #346159] Sat, 06 September 2008 13:17 Go to next message
freakabhi
Messages: 74
Registered: November 2007
Location: mumbai
Member
Can we write any DDL statement in PL/SQL?

from,
freakabhi
Re: DDL statement in Procedure [message #346160 is a reply to message #346159] Sat, 06 September 2008 13:33 Go to previous message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
http://www.orafaq.com/forum/t/88153/0/
Please read & FOLLOW the Posting Guidelines as stated in URL above


Yes, there is a way by (ab)using EXECUTE IMMEDIATE; but you really, really should NOT do so.

Creating database object should be done via static SQL which is maintained under source code control.

[Updated on: Sat, 06 September 2008 13:34] by Moderator

Report message to a moderator

Previous Topic: Query about SQl
Next Topic: AND AND AND
Goto Forum:
  


Current Time: Sat Dec 10 01:13:10 CST 2016

Total time taken to generate the page: 0.04890 seconds