Oracle Magazine, March/April 2019
Database Developer LOW CODE Now suppose youve been tasked to quickly build an application to manage the employees of your organization In this Oracle Magazine article youre going to build a new data model to manage these employees and then build an Oracle APEX application on top of this new data model Employees have jobs and they also belong to a department so you will need to model these entities as well This articles sample is built in Oracle APEX 181 If youre not already running Oracle APEX 181 or later you can request a free workspace at apex oracle com Alternatively you can go to the Oracle Technology Network to download the Database App Development Virtual Machine which includes a preconfigured Oracle Database 18c Enterprise Edition database Oracle APEX 182 Oracle REST Data Services Oracle SQL Developer and Oracle SQL Developer Data Modeler DESIGNING THE INITIAL TABLE Begin your exploration of Quick SQL by modeling the departments table 1 In Oracle APEX click the SQL Workshop tab 2 Click the Utilities icon and then click the Quick SQL icon At livesql oracle com ORACLE MAGAZINE MARCH APRIL 2019 71 click Quick SQL on the menu 3 In the left text area Quick SQL Shorthand type departments and then press the Enter key on your keyboard This is your table name 4 Type two spaces type name and then press Enter 5 Type two spaces type cost center and then press Enter The Quick SQL shorthand you entered should result in this departments name
You must have JavaScript enabled to view digital editions.