Oracle Application Express 3.2 -- Table of Contents -- Oracle Application Express 3.2 -- Credits -- About the Authors -- About the Reviewers -- Preface -- What is the aim of the book -- Who this book is for -- What this book covers -- Standards and assumptions -- Conventions -- Reader feedback -- Customer support -- Errata -- Piracy -- Questions -- 1. An Introduction to APEX -- Web-based -- Native Web based -- Data Centric -- A declarative development tool -- RAD tool -- Application Builder -- SQL Workshop -- Utilities -- Globalization, localization, and NLS -- APEX architecture -- Summary -- 2. What we need to know to effectively use APEX -- SQL and PL/SQL -- HTML and CSS -- JavaScript -- HTML -- The DOM (Document Object Model) -- DOM walking -- DOM methods -- DOM events -- The APEX context -- CSS -- The cascading effect -- The style sheets -- CSS properties -- CSS selectors -- HTML tags selectors: -- Pseudo-class selectors: -- HTML ID selectors: -- Class selectors -- Compound (nested) class selectors: -- Contextual selectors: -- The !important keyword -- The APEX angle -- Where to store our external CSS file? -- How to load our CSS code? -- Globalization and NLS -- JavaScript -- JavaScript features -- Object-Oriented -- Case sensitive -- JavaScript variables -- JavaScript arrays -- JavaScript operators -- Blocks of code -- Conditional blocks of code: -- Repetitive (loop) blocks of code: -- JavaScript functions -- The APEX angle -- Where to store our external JavaScript file? -- How to load our external JavaScript file? -- Globalization and NLS -- PL/SQL and JavaScript (advanced) -- JavaScript and server-side resources (advanced) -- The APEX JavaScript API -- x(pItemId) -- v(pItemId) -- s(pItemId, pValue) -- x_UpTill(pItemId, tagName, className) -- x_Show(pItemId) , x_Hide(pItemId) -- redirect (location) -- Summary.

3. APEX Basic Concepts -- Session state -- Session state firing points -- Session state and the application page life cycle -- Session state and the page rendering phase -- Using computations in the page rendering phase -- Using processes in the page rendering phase -- Special session state processes -- Session state and the page processing phase -- Computations and processes in the page processing phase -- Manually saving to session state -- Using the APEX_UTIL.SET_SESSION_STATE API procedure -- Session state and AJAX -- Using the f?p URL notation -- Referencing persistence session state -- Session state and stored procedures -- Using the v() and nv() functions wisely -- Session state scope and persistence -- Reviewing session state from the application builder -- Substitution strings -- APEX engine built-in substitution strings -- Substitution strings that contain data -- Substitution strings that contain HTML code -- Application substitution strings -- Application or page items -- Referencing substitution strings -- Using the #ITEM# notation -- Using the &ITEM. notation -- Referencing substitution strings in SQL and PL/SQL code -- The bind variable notation -- The APEX built-in v() and nv() functions -- Shortcuts -- Defining a shortcut -- The name field -- The type field -- The shortcut field -- Shortcuts availability -- Themes and templates -- Themes -- Templates -- Page templates -- Region templates -- Reports templates -- Breadcrumbs templates -- List templates -- Calendar templates -- Label templates -- Button templates -- Popup List Of Values template -- Templates and the APEX upgrade process -- Theme, templates, and good practice -- The f?p URL notation -- The p segments -- 1-App -- 2-Page -- 3-Session -- 4-Request -- 5-Debug -- 6-CC (Clear Cache) -- 7-itemName -- 8 itemValue -- 9-PR (Printer friendly).

Item values including the colon character -- APEX multi-lingual support -- The APEX built-in translation mechanism -- Single language applications -- Single application with Multi-lingual user interface -- National Language Support (NLS) in this book -- Summary -- 4. The Application Builder Basic Concepts and Building Blocks -- The APEX Workspace -- Start working with APEX -- Logging in to the APEX IDE -- The APEX IDE home page -- The APEX Application Builder -- The Application Builder home page -- The Import button -- The Create button -- The Application IDE home page -- The Pull Down menu section -- The application pages section -- The detailed list of application pages -- The Download link -- The Page component -- The Page Rendering column -- The Hide/Show icon bar -- The Page Processing column -- The Hide/Show icon bar -- The Shared Components column -- The Hide/Show icon bar -- The Action Bar -- Creating an application page -- Editing the Page Definition page -- The Page section -- A page region -- Creating a page region -- Editing a page region -- Region identification -- Caching -- Summary -- 5. APEX Items -- Naming conventions and rules -- Oracle Identifiers naming rules -- Case sensitive APEX item names -- Application items -- Application items and security issues -- Referencing application items -- Application items and JavaScript -- Page items -- The Name section -- The Name field -- The Display As field -- The Displayed section -- The Sequence field -- The Region field -- The layout fields -- The Drag and drop wizard -- The Label section -- The Label field -- The Horizontal / Vertical Alignment field -- The Template field -- The HTML Table Cell Attributes field -- The Element section -- The item dimension fields -- The HTML Form Element Attributes field -- The Form Element Option Attributes field -- The Pre/Post Element Text fields.

The Source section -- The Source Used field -- Only when current value in session state is null -- Always, replacing any existing value in session state -- The Source Type field -- Maintain session state -- Source value or expression -- Post Calculation Computation -- Format Mask -- The Default section -- The List of Values section -- Static LOV -- Dynamic LOV -- Defines LOV -- LOV related wizards -- The Security section -- The Conditions section -- The Condition Type field -- The Expression 1 / Expression 2 fields -- The Read Only section -- The Help text section -- The Configuration section -- The Comments section -- APEX pre-defined item types -- Text based items -- Multi-option based items -- Special functionality items -- Creating APEX items programmatically -- Summary -- 6. APEX Buttons -- Button styles -- HTML Button -- Image based button -- Template Driven button -- Button positioning -- Create new button(s) -- Button position -- Create a button in a region position -- Button attributes -- Image attributes or template (not for HTML) -- Display properties -- Position -- Sequence -- Branching (optional) -- Conditional display -- Create a button displayed among this region's items -- Edit a button -- The REQUEST feature -- The REQUEST scope -- Referencing REQUEST -- Condition by REQUEST -- Using JavaScript with "among this region's items" buttons -- Re-visit the Buttons section -- Summary -- 7. APEX Computations -- Create a page level computation -- Compute item -- Sequence -- Computation point -- Page Rendering computation points -- Page Processing computation point -- Computation type -- Computation -- Condition -- Create an application level computation -- Computation item -- Frequency -- Edit computations -- Computations and Session State -- Summary -- 8. APEX Validations -- Data validation -- How APEX validation works?.

Creating a new validation -- Validation level -- Create multiple not null validations -- Item -- Validation method -- SQL -- Exists -- Not Exists -- SQL Expression -- PL/SQL -- PL/SQL Expression -- PL/SQL Error -- Function Returning Boolean -- Function Returning Error Text -- Multi-lingual support for error messages -- Item Not Null -- Item string comparison -- Item specified is a valid date -- Regular Expression -- Sequence and Name -- Sequence and Validation Name -- Error Display Location -- On Error Page -- Inline -- Validation -- Conditions -- Page level validation -- Edit validations -- Client-side validation -- Implementing client-side validation -- Client-side versus server-side validations -- Summary -- 9. APEX Processes -- Application Processes -- Creating a new Application Process -- Name -- Sequence -- Point -- Source -- Error message -- Conditionality -- Edit Application Processes -- Localization and Application Processes -- Page level processes -- Creating a new page level process -- Process Type -- PL/SQL -- Reset Pagination -- On Demand -- Session State -- Data manipulation -- Automatic Row Fetch -- Automatic Row Processing (DML) -- Multi Row Update, Multi Row Delete, and Add rows to tabular form -- Web Services -- Form Pagination -- Close pop-up window -- Edit page level process -- Source: Automatic Row Processing (DML) -- On Demand processes -- Summary -- 10. APEX Branches -- Application flow -- Creating a new branch -- Branch point -- Branch type -- Branch to Function Returning a Page -- Branch to Function Returning a URL -- Branch to PL/SQL procedure -- Branch to page -- Branch to page accept processing (not common) -- Branch to Page Identified by Item (Use item name) -- Branch to page or URL -- Save state before branching -- Branches URL and JavaScript -- Branch to URL identified by item (Use item name).

Sequence and branch conditioning.