Oracle Consulting Oracle Training Oracle Support Development
Home
Catalog
Oracle Books
SQL Server Books
IT Books
Job Interview Books
eBooks
Rampant Horse Books
911 Series
Pedagogue Books

Oracle Software
image
Write for Rampant
Publish with Rampant
Rampant News
Rampant Authors
Rampant Staff
 Phone
 800-766-1884
Oracle News
Oracle Forum
Oracle Tips
Articles by our Authors
Press Releases
SQL Server Books
image
image

Oracle 11g Books

Oracle tuning

Oracle training

Oracle support

Remote Oracle

STATSPACK Viewer

Privacy Policy

 

   
 

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:

  • Output: Select the Save As Script File option.

The Display Inline option can be chosen the DDL is to be generated to get a feel for how the schema objects look.

  • Object Type: Choose the object types for which to create the DDL.  The available choices are shown in Figure 14.1.

  • Click the Next button.

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

 

Download your Oracle scripts now:

www.oracle-script.com

The definitive Oracle Script collection for every Oracle professional DBA

Linux Oracle commands syntax poster

ION Oracle tuning software

Oracle data dictionary reference poster



Oracle Forum

BC Oracle consulting support training

BC remote Oracle DBA   

 

   

 Copyright © 1996 -2016 by Burleson. All rights reserved.


Oracle® is the registered trademark of Oracle Corporation. SQL Server® is the registered trademark of Microsoft Corporation. 
Many of the designations used by computer vendors to distinguish their products are claimed as Trademarks