Oracle Magazine, March/April 2019
Database Developer LOW CODE three tables indexed foreign key constraints named check constraints and unique constraints database triggers to audit changes made to the tables and sample data More than 2000 lines of SQL script Amazing CREATING THE ORACLE APEX APPLICATION If youre using Quick SQL within Oracle APEX you can save and execute the statements of your generated SQL script to quickly create an Oracle APEX application on this data model 1 Click the Save SQL Script button 2 For Script Name type QuickSQLDemo and click Save Script 3 Click Review and Run 4 Click Run and then click Run Now After the tables and triggers have been created and the sample data inserted its time to create your application 1 Click Create App from Script 2 For Name type Employee Manager 3 In the Features region click Check All 4 Click Create Application 5 Click the Run Application icon and log in to your application You can navigate among the different pages of your application with reports and forms on your new tables Note that on the form for editing employees the job and department fields are controlled via a select list constraining the values to those defined in the related tables With 14 lines of Quick SQL shorthand and no code you now have a 28 page responsive web application shown in Figure 2 complete with user feedback activity monitoring and access control ORACLE MAGAZINE MARCH APRIL 2019 79
You must have JavaScript enabled to view digital editions.