Home » Developer & Programmer » Forms » How to create dynamic ddl -create table using pl/sql (oracle9i,oracle forms builder)
How to create dynamic ddl -create table using pl/sql [message #311789] Sun, 06 April 2008 19:36 Go to next message
firda
Messages: 3
Registered: April 2008
Junior Member
Hello experts,
i'm having a hard time looking for example codes in creating a dynamic table using pl/sql.
i am doing my final project using oracle9i form builder with oracle 9i database, and i am supposed to produce a dynamic ddl.
Anybody can help me in this?
Or kindly tell me where i can find information regarding this?
Thank You.
Re: How to create dynamic ddl -create table using pl/sql [message #311799 is a reply to message #311789] Sun, 06 April 2008 22:00 Go to previous messageGo to next message
rleishman
Messages: 3724
Registered: October 2005
Location: Melbourne, Australia
Senior Member
You cannot issue DDL directly in PL/SQL. Do a search on EXECUTE IMMEDIATE, and check out the documentation at http://tahiti.oracle.com

Ross Leishman
Re: How to create dynamic ddl -create table using pl/sql [message #311822 is a reply to message #311789] Mon, 07 April 2008 00:34 Go to previous messageGo to next message
firda
Messages: 3
Registered: April 2008
Junior Member
oo..
i see..
i'll try.
thanks a million 4 the fast reply..

firda
Re: How to create dynamic ddl -create table using pl/sql [message #312057 is a reply to message #311789] Mon, 07 April 2008 21:09 Go to previous messageGo to next message
bibsdash
Messages: 47
Registered: April 2008
Member
you can do it in two ways:

Call from the client or forms:

Use FORMS_DDL

Call from the database or server:

exceute immediate
Re: How to create dynamic ddl -create table using pl/sql [message #312062 is a reply to message #311789] Mon, 07 April 2008 21:28 Go to previous messageGo to next message
firda
Messages: 3
Registered: April 2008
Junior Member
hello bibsdash,
thanks!
i just saw the example from the online help.
looks like possible for me to do it. <-i am average.
i'm gonna try it.
thanks,again.

firda
Re: How to create dynamic ddl -create table using pl/sql [message #312063 is a reply to message #311789] Mon, 07 April 2008 21:30 Go to previous message
bibsdash
Messages: 47
Registered: April 2008
Member
You are welcome.
Previous Topic: Getting email Id from Outlook distribution file
Next Topic: About SQL Loader in Form
Goto Forum:
  


Current Time: Sun Dec 04 14:33:52 CST 2016

Total time taken to generate the page: 0.09629 seconds