Generate SQL by Using Quick SQL
Start course

This course walks you through how to use SQL Workshop in Oracle APEX.

Learning Objectives

  • Understand the basics of SQL Workshop and its components
  • Learn how to use SQL commands and SQL scripts
  • Learn how to load and unload data using the Data Workshop
  • Understand what Quick SQL is and you'll also learn how to load some Quick SQL samples

Intended Audience

  • Anyone who wants to enhance their knowledge of Oracle APEX


We recommend that you take this course as part of our Oracle APEX: Foundations learning path.


Welcome to the Oracle APEX Foundations Course. Today in this lesson on using SQL Workshop, I will be talking about generating SQL using Quick SQL. Let's get started. In this section, you'll learn what is Quick SQL and you'll also learn how to load some Quick SQL samples. What is Quick SQL?

Quick SQL allows you to rapidly design and prototype data models by using a markdown-like shorthand syntax that expands to standards-based Oracle SQL. The following are some of the top use cases of Quick SQL: Quickly create robust data models, save Quick SQL shorthand syntax as a model to iterate through model changes for use as a template model to jump start the next model design, easily generate random data, learn SQL, create table, select, insert, index, trigger, PL/SQL package, and view syntax by using the provided examples. Quick SQL is designed to reduce the time and effort required to create SQL tables, triggers, and index structures. This tool is not designed to be a replacement for data modelling.

After you generate the SQL, you can then tweak and expand it. Now let us see the two different ways of navigating to Quick SQL in the APEX workspace. From your workspace homepage, click the 'SQL Workshop', down arrow, select Utilities and then select Quick SQL. Alternatively, from your homepage, you can select the SQL Workshop icon, go to Utilities and select Quick SQL. You can load and view Quick SQL samples to learn about SQL shorthand syntax. You can load these samples by clicking either the Help button or the Load button. Here you see the different samples you can load when you click the load button. For example, if I click on the Departments and Employees, Load Model, I can see the Quick SQL shorthand syntax and the corresponding generated SQL on the right hand pane. Similarly, if I click on the 'Help' button, navigate to the Samples tab, and you can load the different samples from the given list. To summarize, in this section you learned what is Quick SQL and how to load Quick SQL samples. I hope you learned something useful. Thank you for watching.

About the Author
Oracle University
Training Provider
Learning Paths

Oracle University, the learning and training arm of Oracle, is a leader in cloud education, providing modern digital training, certification, and learning solutions across Oracle’s entire product portfolio that enable our customers to master their Oracle Cloud solutions and maximize their investments. Over 2 million certified professionals worldwide have placed their trust Oracle University to reach their learning goals. Learn about Oracle University.