Oracle APEX best practices / Learco Brizzi, Iloon Ellen-Wolff, Alex Nuijten.

Format:

Book

Author/Creator:

Brizzi, Learco.

Contributor:

Nuijten, Alex.

Ellen-Wolff, Iloon.

Series:

Professional expertise distilled

Language:

English

Subjects (All):

aOracle Application express.

Application software--Development.

Application software.

Physical Description:

1 online resource (298 p.)

Edition:

1st ed.

Place of Publication:

Birmingham : Packt Publishing, 2012.

Language Note:

English

Summary:

Make the most of Oracle Apex with this guide to best practices. It will help you look at the bigger picture when building applications and take more elements into account such as security and performance.Key Features"Oracle APEX Best Practices" will get you started with Oracle APEX for developing real-world applications that perform and maximize the full potential of Oracle APEXYou will also learn to take advantage of advanced SQL and PL/SQL along the wayCombines the knowledge of Oracle Apex Experts -- Alex Nuijten, Iloon Ellen-Wollf, and Learco BrizziSetting up your environment and getting ready for developing applicationsBook DescriptionHave you ever wanted to create real-world database applications? In this book you're not only getting APEX best practices, but will also take into account the total environment of an APEX application and benefit from it."Oracle APEX Best Practices" will guide you through the development of real-world applications. It will give you a broader view of APEX. The various aspects include setting up APEX environment, testing and debugging, security, and getting the best out of SQL and PL/SQL.In six distinct chapters you will learn about different features of Oracle APEX as well as SQL and PL/SQL.Do you maximize the capabilities of Oracle APEX? Do you use all the power that SQL and PL/SQL have to offer? Do you want to learn how to build a secure, fully functional application? Then this is the book you'll need. "Oracle APEX: Best Practices" is where practical development begins!What you will learnLesser known features of SQL and PL/SQLIncorporate printing capabilitiesCreate secure applicationsTroubleshooting and DebuggingSetting up your environmentBest practices for building real life applicationsWho this book is forThis book is filled with best practices on how to make the most of Oracle APEX. Developers beginning with application development as well as those who are experienced will benefit from this book. You will need to have basic knowledge of SQL and PL/SQL to follow the examples in this book.

Contents:

""Cover""; ""Copyright""; ""Credits""; ""About the Authors""; ""About the Reviewers""; ""www.PacktPub.com""; ""Table of Contents""; ""Preface""; ""Chapter 1: Prepare and Build""; ""History and background""; ""Installing APEX""; ""Runtime or full development environment""; ""Build status""; ""Tablespaces""; ""Converting runtime environment into a full development environment and vice versa""; ""Choosing a web server""; ""OHS""; ""EPG""; ""APEX Listener""; ""Creating a second administrator""; ""APEX web interface""; ""Command line""; ""Other accounts""; ""Database""; ""Data model""

""Creating the database objects""""Other tools""; ""PL/SQL usage""; ""Creating a workspace""; ""Creating administrators, developers, and users""; ""User Interface Defaults""; ""Attribute Dictionary""; ""Table Dictionary""; ""Creating User Interface Defaults""; ""Page Zero""; ""Structure of multiple applications""; ""Subscribe and publish""; ""Creating a framework""; ""Master and template application""; ""Login application�optional""; ""System application�optional""; ""Deploying""; ""Template workspace""; ""Creating applications""; ""List of values""; ""Mapping the model to pages""

""Base tables""""Master detail""; ""Intersection""; ""Simple report""; ""Other pages""; ""Summary""; ""Chapter 2: Leveraging the Database""; ""Instrumentation""; ""Efficient lookup tables""; ""Single-table hash clusters""; ""Index-organized tables""; ""Analytic functions""; ""Syntax overview""; ""Examples""; ""Running totals""; ""Visualizing the window""; ""Accessing values from other records""; ""Another way of accessing other rows in the result set""; ""Ranking�top N""; ""Stringing it all together""; ""Caveats""; ""Aggregate functions""; ""GROUPING SETS""; ""Rollup""; ""Cube""

""Identifying the totals and subtotals with grouping""""Offloading your frontend and scheduling a job""; ""One-off job""; ""Pipelined table functions""; ""Pipelined table functions in APEX""; ""Using images""; ""Searching the contents of documents""; ""Summary""; ""Chapter 3: Printing""; ""Printing architecture""; ""What is planned for the future version of APEX Listener?""; ""Installation and configuration of the Apache FOP report server""; ""How to configure Apache FOP""; ""Business Intelligence Publisher""; ""Installation of Business Intelligence Publisher version 11""

""Simple print test using BI Publisher""""How to debug or troubleshoot printing issues""; ""How to check if network services are enabled""; ""Creating a report with BI Publisher""; ""Creating the report query""; ""Designing the report layout""; ""Downloading XML data""; ""Designing with the RTF template (MS Word)""; ""Uploading the report layout""; ""Linking the report to your application""; ""How to create a report that can deliver output in different formats""; ""How to add a chart to a report""; ""Creating a chart in a report""; ""How to add dynamic images to a report""; ""Print API""

""How to bypass the 32K limit""

Notes:

Includes index.

ISBN:

1-283-83677-7

1-84968-401-4

OCLC:

923682260