مجموعة Oracle Developer التعليمية
وتحتوي على 242 درساً :
Getting started oracle features | system analysis & database design |
Introduction | Eliminating Repeating Data |
oracle server | Eliminating Partial Dependencies |
physical database structures | Eliminating Transitive Dependencies |
schema and schema objects | Example |
what is DBA | Physical Database Design |
what are DBA tasks | Concepts and Objects |
what is a tablespace | Oracle Forms Concepts |
default tablespace options | Items |
memory structure | Mandatory Form Objects |
background processes | Data Block/Layout Wizards |
managing users | Oracle Form Files |
managing users as DBA | Oracle Forms Developer & Services |
dropping a user | Introduction |
TABLESPACES | Products and Forms Development |
what is a tablespace | Oracle Forms Services |
create tablespace | Summit Office Supply Schema |
default tablespace options | Running Forms Developer Application |
add space to the database | Testing a Form with OC4J |
online & offline tablespace | Running a Form |
read-write & read only tablespace | Starting a Run-Time Session |
drop tablespaces | The Forms Runtime Engine |
system analysis & database design | Modes of Operation |
Introduction | Retrieving Data |
شرح بعض المفاهيم | Inserting, Updating, and Deleting |
Relational Data Structures | Working Developer Environment |
properties of a Database | Forms Builder Key Features |
Database Management System | Forms Builder Components |
Layers of Data Abstraction | Creating Noninput Items |
prevalent database models | Calculated Item Based on a Summary |
Exploring Relational Components | Creating a Hierarchical Tree Item |
Conceptual Design Components | Bean Area Items |
Databse Relationships | Creating Windows & Content Canvases |
Databse Business Rules | Windows and Canvases |
Logical/Physical Components | The Content Canvas |
Database Life Cycle | The Default Window |
Logical design using Normalization | Setting Window Properties |
Applying the Normalization Process | Form Module on Multiple Layouts |
Chosing a Primary Key | Working with Other Canvas Types |
Working with Data Blocks and Frames | Overview of Canvas Types |
Copying Properties | Creating a Stacked Canvas |
Creating a Control Block | The Toolbar Canvas |
Working with Text Items | The Tab Canvas |
Text Item Overview | Setting Tabs and Item Properties |
Modifying the Appearance of a Text Item | Introduction to Triggers |
Controlling the Data of a Text Item | Trigger Overview |
Altering Navigational Behavior | Grouping Triggers into Categories |
Adding Functionality to a Text Item | Defining Trigger Components |
Creating LOVs and Editors | Producing Triggers |
Overview of LOVs and Editors | Creating Triggers in Forms Builder |
LOVs and Record Groups | Setting Trigger Properties |
Creating an LOV Manually | PL/SQL Editor Features-syntax palette |
Creating LOV with the LOV Wizard | The Database Trigger Editor |
LOV Properties | Using Variables in Triggers |
LOVs Column Mapping | Using Built-In Definitions |
Defining an Editor | Using Triggers When-Button-Pressed |
Creating Additional Input Items | Debugging Triggers |
Input Items Overview | The Debug Console |
Setting Check Box Properties | Working Developer Environment |
List Items Overview | Forms Builder: Menu Structure |
Creating a List Item | Blocks, Items, and Canvases |
Radio Groups Overview | Types of Blocks |
Creating Noninput Items | Master versus Detail Blocks |
Noninput Items Overview - Display Items | Form Module Hierarchy |
Creating an Image Item | Customizing Your Forms Builder Session |
Push Buttons | Using the Online Help System |
Calculated Items | Forms Developer Executables |
Debugging Triggers | Forms Developer Module Types |
Setting Breakpoints in Stored Code | Environment Variables for Run Time |
Stepping Through Code | Defining Variables for Design Time |
Adding Functionality to Items | Testing a Form: The Run Form Button |
Item Interaction Triggers | Creating a Basic Form Module |
Coding Item Interaction Triggers | Creating a New Form Module |
Interacting with Check Boxes | Form Module Properties |
Changing List Items at Run Time | Creating a New Data Block |
Displaying LOVs from Buttons | Saving a Form Module |
Populating Image Items | Module Types and Storage Formats |
Populating Hierarchical Trees | Creating a Master-Detail Form |
Displaying Hierarchical Trees | Form Block Relationships |
Interacting with JavaBeans | Data Block Wizard |
Responding to events | Relation Object |
Getting values from java beans | Join Condition |
Run Time Messages and Alerts | Running a Master-Detail Form Module |
Introduction | Modifying the Structure of a Data Block |
Detecting Run-Time Errors | Working with Data Blocks and Frames |
Errors and Built-Ins | Managing Object Properties |
Triggers for Intercepting System | Property Palette |
Setting Alert Properties | Visual Attributes |
Planning Alerts | Data Block Behavior & Appearance |
SHOW_ALERT Function | Scroll Bar Properties |
Handling Errors by Oracle Server | Controlling Frame Properties |
Query Triggers | Displaying Multiple Property Palettes |
Query Processing Overview | Setting Properties on Multiple Objects |
SELECT Statements During Query | |
Writing Query Triggers | |
Using SELECT Statements in Triggers | |
Query Array Processing | |
Coding Triggers for Enter-Query Mode | |
Overriding Default Query Processing | |
Obtaining Query Information at Run Time | |
Writing Flexible Code | |
What Is Flexible Code? | |
System Status Variables | |
Referencing Objects by Internal ID | |
Using Object IDs | |
Referencing Items Indirectly | |
Sharing Objects and Code | |
Benefits of Reusing Objects and Code | |
What Are Property Classes | |
Inheriting from a Property Class | |
What Are Object Groups? | |
Subclass Information Dialog Box | |
Subclassing an Object | |
What Are Object Libraries | |
Working with Object Libraries | |
What Is a SmartClass | |
Reusing PL/SQL | |
What Are PL/SQL Libraries? | |
Creating Library | |
When several libraries are attached | |
Introducing Multiple Form Applications | |
Multiple Form Applications Overview | |
How to Start Another Form Module | |
OPEN_FORM to Provide Forms | |
Defining Multiple Form Functionality | |
Linking by Global Variables | |
Performing a Restricted Query on Startup | |
Creating and Passing Parameter Lists | |
Linking by Global Record Groups | |
Linking by Shared PL/SQL Variables |