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
To export the DDL, navigate to the Generate DDL page via SQL
à Generate DDL.
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.
On the Schema page, choose the EASYHDB schema and click Next.
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.
On the Object Name page, select the items to generate DDL for
and click the Generate DDL button.
On the Script page enter EasyHDB_DDL for the Script Name.
Providing a description is optional. Then, click the Create Script
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
The above book excerpt is from:
Oracle Application Express
Dynamic Web Pages with OAE
Michael Cunningham & Kent Crotty