Oracle Application Express on APEX.ORACLE.COM was upgraded to v5.1 last week.
One of the new things coming in v5.1 is a new packaged app called ‘Quick SQL.’ VP of Development Tools Mike Hichwa demonstrated it at UKOUG Tech 16 this month, and the audience seemed to eat it up. Basically, it allows you to use a shorthand of sorts to describe a table or tables, and it will generate the DDL for you.
Heck, it will even generate data, and across tables with foreign key relationships for you too.
So I wanted to have a go at it.
Do you have a workspace yet? If not, it only takes a few minutes to sign up and get started.
Once you do, you can install Quick SQL.
Installing is just a matter of clicking the button.
Once it’s available, you can click the ‘Play/Run’ button. You’ll then be prompted to setup the application – basically, who is going to get to run it and/or administer it.
So after a click-click-click, we’re ready to rock and roll.
Cool, so let’s create a couple of tables that are ‘related.’ Oh, and I want some demo data too.
Maybe you don’t like exactly how this works out of the box? For example, you don’t want IDENTITY columns. No worries, you have preferences.
Alright, now I want to run this.
I have a few options. If I were running APEX 5.1 and the Quick SQL app in my own database, I’d just copy the generated code over to SQL Developer and run it.
But, I’m running this in the APEX Cloud, so I’m going to run it there. The SQL Workbench has a really nice script feature I can use. This lets me save this work as a ‘create’ script, and I can run it now, or over and over again if I decide to blow everything away and start from scratch.
Alright, so I have my two tables and my data – I should create an app, right?
Now, please don’t judge APEX or APEX 5.1 based on what I’m about to show you – because I AM NOT an APEX developer. But, in a few moments, I was able to figure out how to setup a master/detail form and throw in a picture, and run it with my new tables and data.
One Last Thing
While hacking my app together, I was very happy to see how NICE the design process is. As I was putting in my SQL…it was very quick to remind me I had made a mistake.