Tuesday, January 02, 2018

Quick SQL: from Packaged App to built-in feature in Oracle APEX 5.2

I blogged about Quick SQL already a few times as I saw not many developers knew about it.

In Oracle APEX 5.1 you can install Quick SQL by going to the Packaged Apps section and install it from there:



I really love Quick SQL as it allows me to build my data model very fast, but also shows me the structure of the tables in a very efficient way. That is why I created a script that can reverse engineer existing tables into the Quick SQL format.

From Oracle APEX 5.2 onwards you won't find Quick SQL in the packaged app section anymore... but no worries, it's not gone, it's now built-in the APEX framework itself :)

Go to SQL Workshop - SQL Scripts:


Hit the Quick SQL button:


Here you have Quick SQL :)


You can run your script after you save, straight from this interface.

Note: the screenshots are taken from Oracle APEX 5.2 Early Adopter, so things might change in the final release of APEX 5.2.

5 comments:

  1. i want to design only Point of Sale screen in apex my rest application already on oracle forms 12c please any body give idea how it will be design


    ReplyDelete
  2. i want to design only Point of Sale screen in apex my rest application already on oracle forms 12c please any body give idea how it will be design



    ReplyDelete
  3. A very useful article, thanks for the information

    ReplyDelete
  4. i want to design only Point of Sale screen in apex my rest application already on oracle forms 12c please any body give idea how it will be design


    ReplyDelete
  5. Hi Dimitri. What would we do now if we wanted to give access to Quick SQL to a 'Citizen Developer' (i.e. someone not conversant with SQL but able to specify their own data formats)? Previously we could have made the packaged app available through the usual methods, but now it seems we'd have to give them an actual log in to the APEX workspace development environment instead? Does that make sense? It seems like a backwards step to remove the packaged application to me..

    ReplyDelete