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
Messages: 74
Registered: November 2007
Location: mumbai
Can we write any DDL statement in PL/SQL?

Re: DDL statement in Procedure [message #346160 is a reply to message #346159] Sat, 06 September 2008 13:33 Go to previous message
Messages: 25537
Registered: January 2009
Location: SoCal
Senior Member
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: Tue Jul 25 16:04:54 CDT 2017

Total time taken to generate the page: 0.15289 seconds