 |
|
ss
Oracle Tips by Burleson |
Generating the DDL
for the Application
HTML DB provides an easy way to export the Data
Definition Language(DDL) from the
application’s parsing schema into a file. With this utility, database
objects can easily be moved from the development server to the
production server.
1.
To export the DDL, navigate to the Generate DDL page via SQL
Workshop
à Utilities
à Generate DDL.
2.
The Schema Objects page will show a list of schemas available
in which to create a DDL script. The example application will only
have the EASYHDB schema. Click the Create Script button.
3.
On the Schema page, choose the EASYHDB schema and click Next.
4.
On the Object Type page:
The Display Inline
option can be chosen the DDL is to be generated to get a feel for how
the schema objects look.
It is possible to generate the DDL at this
point, and it will create all objects of the type chosen. The
choice for this example is going to be reduced to a subset of the
objects, so click Next.
The Object Name page will show a list of
all the objects available for DDL generation. On the prior page,
shown in Figure 14.1, all the options were chosen on purpose in
order to show the objects available on the Object Name page.
5.
On the Object Name page, select the items to generate DDL for
and click the Generate DDL button.
6.
On the Script page enter EasyHDB_DDL for the Script Name.
Providing a description is optional. Then, click the Create Script
button.
So far, the DDL generation has been run and the
script has been saved to the Script Repository with the name
EasyHDB_DDL. The DDL script will be created and stored in the Script
Repository. From here, the script can be exported to a file on the
operating system.
The above book excerpt is from:
Easy HTML-DB
Oracle Application Express
Create
Dynamic Web Pages with OAE
ISBN 0-9761573-1-4
Michael Cunningham & Kent Crotty
http://www.rampant-books.com/book_2005_2_html_db.htm
|