D56782GC30_ag1

Please download to get full document.

View again

of 300
All materials on our website are shared by users. If you have any questions about copyright issues, please report us to resolve them. We are always happy to assist you.
Information Report
Category:

Documents

Published:

Views: 262 | Pages: 300

Extension: PDF | Download: 3

Share
Related documents
Description
apex
Tags
Transcript
  Oracle Application Express: Developing Web Applications Activity Guide – Volume I D56782GC30 Edition 3.0 December 2011 D75248  Copyright © December, 2011, Oracle and/or its affiliates. All rights reserved.   Disclaimer This document contains proprietary information and is protected by copyright and other intellectual property laws. You may copy and print this document solely for your own use in an Oracle training course. The document may not be modified or altered in any way. Except where your use constitutes fair use under copyright law, you may not use, share, download, upload, copy, print, display, perform, reproduce, publish, license, post, transmit, or distribute this document in whole or in part without the express authorization of Oracle. The information contained in this document is subject to change without notice. If you find any problems in the document, please report them in writing to: Oracle University, 500 Oracle Parkway, Redwood Shores, California 94065 USA. This document is not warranted to be error-free. Restricted Rights Notice If this documentation is delivered to the United States Government or anyone using the documentation on behalf of the United States Government, the following notice is applicable: U.S. GOVERNMENT RIGHTS The U.S. Government’s rights to use, modify, reproduce, release, perform, display, or disclose these training materials are restricted by the terms of the applicable Oracle license agreement and/or the applicable U.S. Government contract. Trademark Notice Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners. Authors Dimpi Sarmah, Salome Clement Technical Contributors and Reviewers  Anthony Rayner, Bryan Roberts, Chaitanya Koratamaddi, Christina Cho, Christopher Wensley, Drue Baker, Ganesh Pitchaiah, Hailing Huang, Hilary Farrell, Iloon Ellen, Jason Straub, Jean- Paul Fillon, Joel Kallman, Linda Ross, Nancy Greenberg, Madhavi Siddireddy, Maria Billings, Matthew Gregory, Michael Hichwa, Patrick Wolf, Sharon Kennedy, Terri Jennings, Yi Lu, Wayne Abbott This book was published using: Oracle Tutor      Copyright © 2011, Oracle and/or its affiliates. All rights reserved. Oracle Application Express: Developing Web Applications Table of Contents i Table of Contents Practices for Lesson 1: Course Overview ................................................................................................ 1-1   Practices for Lesson 1 ............................................................................................................................. 1-2   Practices for Lesson 2: Introduction to Oracle Application Express....................................................... 2-1   Practices for Lesson 2 ............................................................................................................................. 2-2   Practice 2-1: Using Oracle Application Express as a Workspace Administrator ......................................... 2-3   Practice 2-2: Using Oracle Application Express as a Developer ................................................................ 2-4   Practice Solution 2-1: Using Oracle Application Express as a Workspace Administrator ............................ 2-5   Practice Solution 2-2: Using Oracle Application as a Developer ................................................................ 2-8   Practices for Lesson 3: Interacting with the Database by Using SQL Workshop .................................... 3-1   Practices for Lesson 3 ............................................................................................................................. 3-2   Practice 3-1: Using Object Browser ......................................................................................................... 3-3   Practice 3-2: Using SQL Commands and SQL Scripts .............................................................................. 3-4   Practice 3-3: Using Utilities ...................................................................................................................... 3-5   Practice Solution 3-1: Using Object Browser ............................................................................................ 3-6   Practice Solution 3-2: Using SQL Commands and SQL Scripts ................................................................ 3-19   Practice Solution 3-3: Using Utilities ........................................................................................................ 3-27   Practices for Lesson 4: Building a Database Application ........................................................................ 4-1   Practice 4-1: Creating Applications .......................................................................................................... 4-2   Practice Solution 4-1: Creating Applications ............................................................................................. 4-3   Practices for Lesson 5: Creating Reports ................................................................................................ 5-1   Practices for Lesson 5 ............................................................................................................................. 5-2   Practice 5-1: Building and Manipulating an Interactive Report ................................................................... 5-3   Practice 5-2: Customizing an Interactive Report ....................................................................................... 5-5   Practice 5-3: Creating Classic Reports ..................................................................................................... 5-6   Practice Solution 5-1: Building and Manipulating an Interactive Report ..................................................... 5-7   Practice Solution 5-2: Customizing an Interactive Report .......................................................................... 5-38   Practice Solution 5-3: Creating Classic Reports ....................................................................................... 5-46   Practices for Lesson 6: Creating Forms ................................................................................................... 6-1   Practices for Lesson 6 ............................................................................................................................. 6-2   Practice 6-1: Creating a Form on a Table ................................................................................................. 6-3   Practice 6-2: Creating a Master Detail Form ............................................................................................. 6-4   Practice 6-3: Creating a Tabular Form ..................................................................................................... 6-5   Practice Solution 6-1: Creating a Form on a Table ................................................................................... 6-6   Practice Solution 6-2: Creating a Master Detail Form ............................................................................... 6-16   Practice Solution 6-3: Creating a Tabular Form ........................................................................................ 6-32   Practices for Lesson 7: Working with Pages and Regions ...................................................................... 7-1   Practices for Lesson 7 ............................................................................................................................. 7-2   Practice 7-1: Working with Pages and Regions ........................................................................................ 7-3   Practice Solution 7-1: Working with Pages and Regions ........................................................................... 7-5   Practices for Lesson 8: Understanding Session State and Debugging ................................................... 8-1   Practices for Lesson 8 ............................................................................................................................. 8-2   Practice 8-1: Understanding Session State .............................................................................................. 8-3   Practice 8-2: Debugging Your Application ................................................................................................ 8-4   Practice Solution 8-1: Understanding Session State ................................................................................. 8-5   Practice Solution 8-2: Debugging Your Application ................................................................................... 8-20     Copyright © 2011, Oracle and/or its affiliates. All rights reserved. Oracle Application Express: Developing Web Applications Table of Contents ii Practices for Lesson 9: Adding Items and Buttons ................................................................................. 9-1   Practices for Lesson 9 ............................................................................................................................. 9-2   Practice 9-1: Adding Items and Buttons ................................................................................................... 9-3   Practice 9-2: Manipulating Items .............................................................................................................. 9-4   Practice 9-3: Creating an Upload and Download Page ............................................................................. 9-6   Practice Solution 9-1: Adding Items and Buttons ...................................................................................... 9-7   Practice Solution 9-2: Manipulating Items................................................................................................. 9-23   Practice Solution 9-3: Creating an Upload and Download Page ................................................................ 9-48   Practices for Lesson 10: Including Page Processing .............................................................................. 10-1   Practices for Lesson 10: Creating Page Processes .................................................................................. 10-2   Practice 10-1: Creating and Manipulating Computations, Processes, and Validations ................................ 10-3   Solution to Practice 10-1: Creating and Manipulating Computations, Processes, and Validations ............... 10-5   Practices for Lesson 11: Using Application and Page Utilities................................................................ 11-1   Practices for Lesson 11 ........................................................................................................................... 11-3   Practice 11-1: Using the Advisor .............................................................................................................. 11-4   Practice 11-2: Managing Your Attribute Dictionary .................................................................................... 11-5   Practice Solution 11-1: Using the Advisor................................................................................................. 11-6   Practice Solution 11-2: Managing Your Attribute Dictionary ...................................................................... 11-13   Practices for Lesson 12: Adding Shared Components That Aid Navigation ........................................... 12-1   Practices for Lesson 12 ........................................................................................................................... 12-2   Practice 12-1: Creating Lists and List Regions ......................................................................................... 12-3   Practice 12-2: Creating and Editing Standard Tabs .................................................................................. 12-4   Practice 12-3: Managing Help Text in Your Application ............................................................................. 12-5   Practice 12-4: Adding Navigation Bar Entries ........................................................................................... 12-6   Practice 12-5: Adding Breadcrumbs and Tabs to an Existing Page ........................................................... 12-7   Practice Solution 12-1: Creating Lists and List Regions ............................................................................ 12-8   Practice Solution 12-2: Creating and Editing Standard Tabs ..................................................................... 12-16   Practice Solution 12-3: Managing Help Text in Your Application ............................................................... 12-24   Practice Solution 12-4: Adding Navigation Bar Entries .............................................................................. 12-30   Practice Solution 12-5: Adding Breadcrumbs and Tabs to an Existing Page .............................................. 12-38   Practices for Lesson 13: Displaying Dynamic Content ............................................................................ 13-1   Practices for Lesson 13 ........................................................................................................................... 13-2   Practice 13-1: Using Dynamic Actions on Your Page ................................................................................ 13-3   Practice 13-2: Importing and Using the Star Rating Plug-In....................................................................... 13-5   Practice 13-3: Creating and Modifying Flash Charts ................................................................................. 13-6   Practice 13-4: Creating a Calendar .......................................................................................................... 13-7   Practice 13-5: Creating a Tree Whose Nodes Link to a Different Page ...................................................... 13-8   Practice Solution 13-1: Using Dynamic Actions on Your Page .................................................................. 13-9   Practice Solution 13-2: Importing and Using the Star Rating Plug-In ......................................................... 13-35   Practice Solution 13-3: Creating and Modifying Flash Charts .................................................................... 13-45   Practice Solution 13-4: Adding a Calendar ............................................................................................... 13-54   Practice Solution 13-5: Creating a Tree Whose Nodes Link to a Different Page ......................................... 13-62   Practices for Lesson 14: Working with Themes, Templates, and Files ................................................... 14-1   Practices for Lesson 14 ........................................................................................................................... 14-2   Practice 14-1: Working with Themes, Templates, and Files ...................................................................... 14-3   Practice Solution 14-1: Working with Themes, Templates, and Files ......................................................... 14-5   Practices for Lesson 15: Administering Oracle Application Express Workspaces ................................. 15-1   Practices for Lesson 15 ........................................................................................................................... 15-2  
We Need Your Support
Thank you for visiting our website and your interest in our free products and services. We are nonprofit website to share and download documents. To the running of this website, we need your help to support us.

Thanks to everyone for your continued support.

No, Thanks