APEX_D56782GC30_sg1.pdf | Oracle Database

Please download to get full document.

View again

of 516
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: 56 | Pages: 516

Extension: PDF | Download: 15

Share
Related documents
Description
THESE eKIT MATERIALS ARE FOR YOUR USE IN THIS CLASSROOM ONLY. COPYING eKIT MATERIALS FROM THIS COMPUTER IS STRICTLY PROHIBITED Developing Web Applications Student Guide - Volume I D56782GC30 Edition 3.0 December 2011 D75246 Oracle University and Enfoque Directo Aplicado Mexico SA De CV use only Oracle Application Express: Copyright © 2011, Oracle and/or its affiliates. All rights reserved. Dimpi Sarmah Disclaimer Salome Clement This document contains proprietary information and is
Transcript
  Oracle Application Express: Developing Web Applications Student Guide - Volume I D56782GC30 Edition 3.0 December 2011 D75246  Copyright © 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. uthors 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 Editors Malavika Jinka Richard Wallis Vijayalakshmi Narasimhan Graphic Designer  Maheshwari Krishnamurthy Publishers   Jayanthy Keshavamurthy Revathi V. Ramamoorthy    iii Contents 1 Course Overview Course Objectives 1-2  Agenda: Day 1 1-3  Agenda: Day 2 1-4  Agenda: Day 3 1-5  Agenda: Day 4 1-6  Agenda: Day 5 1-7 Order Management Database Application 1-8 Websheet Application 1-9 Course Environment 1-10 Workspace Details 1-11  Accessing the labs Directory 1-12 2 Introducing Oracle Application Express Objectives 2-2 Lesson Agenda 2-3 What Is Oracle Application Express? 2-4 Why Use Oracle Application Express? 2-5 Types of Applications 2-6  Applications Developed by Using Oracle Application Express 2-7 High-Level Architecture 2-8 Quiz 2-10 Lesson Agenda 2-11 What is a Workspace? 2-12 What Is an Internal Workspace? 2-13 Defining Roles 2-14 Oracle Application Express Components 2-16 Quiz 2-17 Lesson Agenda 2-18 Types of Installations 2-19 Logging In to a Workspace 2-20 Creating a Developer User 2-21  Available Sample Applications 2-22 Running the Sample Database Application 2-23 Sample Database Application 2-24    iv What Is a Packaged Application? 2-25 Installing a Packaged Application 2-26 Summary 2-27 Practice 2: Overview 2-28 3 Interacting with the Database by Using SQL Workshop Objectives 3-2 Lesson Agenda 3-3 What Is SQL Workshop? 3-4 Component Usage in SQL Workshop 3-5  Accessing SQL Workshop 3-6 Navigating in SQL Workshop 3-7 Lesson Agenda 3-8 Object Browser Interface 3-9 Creating Database Objects 3-10 What Is a Lookup Table? 3-11 Creating a Lookup Table 3-12 Viewing the Created Lookup Table 3-13 Quiz 3-14 Lesson Agenda 3-15 SQL Commands Interface 3-16 Running SQL Commands 3-18 Saving SQL Commands 3-19 SQL Scripts Interface 3-20 Creating and Uploading SQL Scripts 3-21 Importing and Exporting SQL Scripts 3-22 Lesson Agenda 3-23  Accessing Utilities 3-24 Query Builder Interface 3-25 Building and Running a Query in Query Builder 3-26 Saving a Query in Query Builder 3-27 Quiz 3-28 Lesson Agenda 3-29 Loading and Unloading Data 3-30 Loading Text and Spreadsheet Data 3-31 Viewing the Loaded Files in the Data Workshop Repository 3-32 Unloading to a Text File 3-33 Unloading to an XML File 3-34 Lesson Agenda 3-35 Viewing Object Reports 3-36 Generating DDL Statements 3-37
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