SQL and PL/SQL

SQL is essential where reports, charts, and calendars are concerned as it defines the scope and the conditions of the fetched data from the database. APEX includes some wizards and tools, such as the Wizard Report and Query Builder, which can greatly assist novice users in creating SQL queries, but basic SQL knowledge is still an advantage. The same can be said about PL/SQL, especially when we want to enhance the APEX built-in wizards and pre-defined processes capabilities, or when we use AJAX (on the server-side). For example, the APEX built-in wizards and the declarative pages natively support working with a composite Primary Key of up to two segments. Working with compound Primary Keys with more than two segments, is possible, but we will have to write our own DML code for that.

In this book, we'll assume that you have the basic skills and knowledge to handle the APEX tasks that involve SQL and PL/SQL.