مجموعة 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