Oracle Application Express Basics
Duration 4 days Introducing Oracle Application Express • Explaining the General Concepts
• Identifying the Main Components
• Creating a Workspace and Workspace Administrator
• Logging In to Oracle Application Express
• Installing and Running a Sample Application
• Installing a Packaged Application Interacting with the Database by Using SQL Workshop • Browsing, Creating and Modifying Objects
• Processing Ad Hoc SQL Statements
• Managing Scripts
• Creating, Running and Saving SQL Queries Building an Application • Identifying the Components of an Application
• Creating an Application from Scratch
• Creating an Application from a Spreadsheet Creating Reports • Generating Reports Using Wizards
• Editing Report Attributes
• Adding Links in Reports
• Saving or Printing Reports in Different Formats Creating Forms • Creating a Form on a Table With a Report
• Creating a Tabular Form
• Creating a Master-Detail Form
• Editing Form Attributes Working with Pages and Regions • Viewing Page Definitions
• Editing Page Attributes
• Creating a New Region
• Viewing Region Attributes
• Adding Comments Adding Items and Buttons • Creating Items
• Editing Item Attributes
• Creating Buttons
• Editing Button Attributes Understanding Session State and Debugging • Implementing Session State
• Setting a Session State Value
• Clearing the Session State
• Reviewing the Session State
• Reviewing the Messages in Debug Mode Including Page Processing • Explaining the Difference Between Page Rendering and Page Processing
• Creating Computations
• Validating Input Data
• Process Data
• Creating Application Branching Adding Shared Components That Aid Navigation • Providing an Overview of Shared Components
• Managing Parent and Standard Tabs
• Managing Navigation Bars
• Managing Lists
• Managing Breadcrumbs Adding Other Shared Components • Managing List of Values
• Managing Trees
• Accessing Shared Component Reports
• Setting User Interface Defaults Displaying Dynamic Content • Filtering Reports Using Dynamic Queries
• Creating Charts Using a Wizard
• Creating a Calendar Working with Themes and Templates • Switching to a Different Theme
• Viewing Existing Templates
• Managing Templates
• Adding a Logo
• Referencing a Cascading Style Sheet
• Changing a Field to Use a Class in the Referencing Stylesheet Administering Oracle Application Express Workspaces • Managing Users
• Requesting a Schema or Storage
• Purging Session State
• Monitoring Developer Activity Log
• Monitoring Workspace Activity
• Viewing Activity Reports Implementing Security • Differentiating Between Authentication and Authorization
• Providing an Authentication Scheme
• Creating an Authorization Scheme Using Access Control
• Enabling and Configuring Session State Protection Deploying Your Application • Defining Supporting Objects
• Exporting Your Application
• Importing Your Application
• Installing Supporting Objects Using Utilities • Importing and Exporting Data
• Generating Data Definition Language (DDL) Statements
• Viewing Object Reports
• Monitoring the Database
|
