5.4.4 Generating Quick SQL with SQL Shorthand Syntax

Quickly develop a script for simple tables and views by entering SQL shorthand syntax in the the left pane and clicking Generate SQL.

Tip:

Viewing samples is a great way to learn about Quick SQL shorthand syntax. To view samples, click Help and then Samples. Select a sample by clicking Load Model.

To generate the Quick SQL with SQL shorthand syntax:

1. Navigate to the Quick SQL page:
   1. On the Workspace home page, click the SQL Workshop icon.
   2. Click Utilities.
   3. Click Quick SQL.
2. In the Quick SQL Shorthand pane (the left pane), enter SQL shorthand syntax.
   
   Description of the illustration shorthand_syntax.png
3. Click Generate SQL.

   The generated SQL appears in Oracle SQL Output pane.

   
   Description of the illustration quick_sql_with_sql_shorthand.png

   Note:

   You can save the generated script or review and run the script.

4. To save the SQL script:
   1. Click Save SQL Script.
      The Save Script dialog appears.
   2. In the Save Script dialog:

      • Script Name - Enter a name.

      • Click Save Script.

      The script is saved in SQL Scripts.

Note:

• Saving a SQL Script

• Configuring Quick SQL Settings