Oracle APEX 4.2 Reporting. (2013)

• Record Type: Book
• Other Names: Pathak, Vishal
• Contents: Cover; Copyright; Credits; About the Author; About the Reviewers; www.PacktPub.com; Table of Contents; Preface; Chapter 1: Know Your Horse Before You Ride It; What is really new in the new avatar of APEX?; APEX configurations; APEX configuration using DAD; Internal mod_plsql configuration; External mod_plsql configuration; APEX Listener configuration; Installing APEX engine and Listener; Installing the APEX engine in the database; Creating a WebLogic domain and starting the servers; Setting the APEX Listener; Configuring and deploying APEX Listener on the WebLogic domain. Creating APEX workspaceUnderstanding the APEX URL; The protocol; Hostname and port number; DAD name and web context; The f procedure; The application ID in the URL; The page number in the URL; Session management; The zero session ID; Request handling; Debugging; Error handling; TKPROF; Cache Management; Passing values and navigation; Making APEX printer friendly; Decoding the APEX page submissions; APEX behind the scenes; Other web interfaces; A pessimist's view of APEX; Cap of 200 page items; SQL Injection; Cross-site scripting; Summary; Chapter 2: Conventional Reporting in APEX. Creating database objects and installing the reference applicationImplementing external table authentication; Displaying environment properties using the USERENV namespace; Displaying the CGI environment variables; Implementing classic report search functionality; Enabling sorting and CSV download; Implementing group reports; Using the Break Formatting section in classic reports; Using JavaScript to modify report; Using grouping sets and HTML formatting in a query; Additional methods of formatting; Highlighting the searched text in a report; Editing a template for additional formatting. Implementing a matrix reportUnderstanding the with clause; Understanding the Oracle 11G's pivot operator; Understanding string aggregation; Data highlighting using Dynamic Actions and jQuery; Advanced formatting using APEX templates; Understanding dynamic query region in APEX; Implementing hierarchical reports; Hierarchical reports with drilldown; Creating dynamic messages using substitution variables; Creating dynamic breadcrumbs for drill ups; Creating a report with hierarchical query; Creating a hierarchical report using the recursive with clause; Creating a tree based on hierarchical data. Understanding methods to upload files in APEXUsing DA to set page items and side effects of PPR; A workaround to the side effects of PPR; Using substitution variables for labels; Auto feeding one APEX item based on another; Method to upload files using WWV_FLOW_FILES; Understanding download methods; Download using APEX format mask; Download using developer-defined stored function; Download using APEX_UTIL. GET_BLOB_FILE_SRC; Download using p process; Implementing soft deletion with AJAX and APEX templates; DML operations and report filtering using DA, JavaScript, and page processes.
• Publisher Details: Place of publication not identified : Packt Publishing
• Publication Date: 2013
• Extent: 1 online resource
• Subjects: 005.7565; COMPUTERS -- Programming Languages -- XML; Application software -- Development; Application software -- Development; COMPUTERS -- Programming Languages -- SQL; Electronic books; Electronic books
• Languages: English
• ISBNs: 1299832482; 9781299832480; 9781849684996; 1849684995; 9781849684989; 1849684987
• Notes: Note: Print version record.
• Access Rights: Legal Deposit; Only available on premises controlled by the deposit library and to one user at any one time; The Legal Deposit Libraries (Non-Print Works) Regulations (UK).
• Access Usage: Restricted: Printing from this resource is governed by The Legal Deposit Libraries (Non-Print Works) Regulations (UK) and UK copyright law currently in force.