5.4 Using Quick SQL

Rapidly design and prototype data models using a markdown-like shorthand syntax that expands to standards-based Oracle SQL.

Note:

As described in Getting Started with Quick SQL, Quick SQL requires Oracle REST Data Services (ORDS) 23.3.0 or later.

• Getting Started with Quick SQL
  Learn about common Quick SQL use cases and the basic rules of Quick SQL shorthand syntax.
• Accessing Quick SQL
  Access Quick SQL by clicking SQL Workshop, Utilities, and then Quick SQL.
• About the Quick SQL Page
  Learn about the layout and controls available on the Quick SQL page.
• Accessing Quick SQL Help
  Access Quick SQL Help by clicking Help above the left Quick SQL pane.
• Loading Quick SQL Sample Models
  Learn about Quick SQL shorthand syntax by loading Quick SQL sample models.
• Generating SQL with SQL Shorthand Syntax
  Generate a SQL script for simple tables and views by entering SQL shorthand syntax in the the left Quick SQL pane.
• Managing Quick SQL Models and Scripts
  Save entered Quick SQL shorthand syntax as a model for future use, or save the generated SQL as a SQL script.
• Creating an Application from a Generated SQL Script
  Create an application from a saved script in SQL Scripts.
• Configuring Quick SQL Settings
  Configure settings inline to explicitly set SQL syntax generation options, or click the Settings button at the top of the right pane to declaratively set the generation options.
• Recommendations When Using Quick SQL
  Learn about recommended approaches to creating effective data models.
• Database Terminology Used in Quick SQL
  Learn about common database terms used in Quick SQL.
• About Supported Data Types
  Learn about supported data types.