Stay home stay safe-- Due to the Covid-19 outbreak all our course will be conducted online. For more inform please contact-9619341713 / 7045481713

  • +91-9619341713-Airoli/ 7045481713-Mahape/ 7045911713-Kalyan

Learn Basic Oracle

Learn Basic & Advanced Oracle from start for beginner

Courses
Course Overview

An Oracle database is a collection of data treated as a unit. The purpose of a database is to store and retrieve related information. A database server is the key to solving the problems of information management. In general, a server reliably manages a large amount of data in a multiuser environment so that many users can concurrently access the same data. All this is accomplished while delivering high performance. A database server also prevents unauthorized access and provides efficient solutions for failure recovery.

Requirements

  • Installing and configuring Oracle
  • Basic monitoring and tuning
  • Basic understanding of database security issues
  • Database design
  • Good knowledge of DBMS series of packages
  • Command over SQL and PL/SQL

Learn basic SQL Training
  • Relational and Object Relational Database Management System
  • Relational Database Concept
  • Definition of a Relational Database
  • Entity Relationship Model
  • Entity Relationship Modeling Conventions
  • Relational Database Terminology
  • Relational Database Properties
  • Communicating with a RDBMS Using SQL
  • SQL Statements
  • Capabilities of SQL SELECT Statements
  • Basic SELECT Statemen
  • Selecting All Columns
  • Selecting Specific Columns
  • Writing SQL Statements
  • Column Heading Defaults
  • Arithmetic Expressions
  • Using Arithmetic Operators
  • Operator Precedence
  • Using Parentheses
  • Defining a Null Value
  • Null Values in Arithmetic Expressions
  • Defining a Column Alias
  • Duplicate rows
  • Displaying Table Structure
  • Limiting Rows Using a Selection
  • Using the WHERE Clause
  • Comparison Conditions
  • Using the BETWEEN Condition
  • Using the IN Condition
  • Using the LIKE Condition
  • Using the NULL Conditions
  • Logical Conditions
  • Using the AND Operator
  • Using the OR Operator
  • Using the NOT Operator
  • Rules of Precedence
  • ORDER BY Clause
  • Sorting in Descending Order
  • Sorting by Multiple Columns
  • SQL Functions
  • Two Types of SQL Functions
  • Single-Row Functions
  • Character Functions
  • Case Manipulation Functions
  • Character-Manipulation Functions
  • Number Functions
  • Using the ROUND Function
  • Using the TRUNC Function
  • Using the MOD Function
  • Working with Dates
  • Arithmetic Operators with Dates
  • Date Functions
  • General Functions
  • NVL Function
  • Using the NVL2 Function
  • Using the COALESCE Function
  • The CASE Expression
  • Using the CASE Expression
  • The DECODE Function
  • What Are Group Functions?
  • Types of Group Functions
  • Group Functions Syntax
  • Using the AVG and SUM Functions
  • Using the MIN and MAX Functions
  • Using the COUNT Function
  • Using the DISTINCT Keyword
  • Group Functions and Null Values
  • Using the NVL Function with Group Functions
  • Creating Groups of Data: The GROUP BY Clause Syntax
  • Using the GROUP BY Clause on Multiple Columns
  • Excluding Group Results: The HAVING Clause
  • Nesting Group Functions
  • Obtaining Data from Multiple Tables
  • Cartesian Products
  • Generating a Cartesian Product
  • Types of Joins
  • Joining Tables Using Oracle Syntax
  • What is Equi Join?
  • Retrieving Records with Equijoins
  • Additional Search Conditions Using the AND Operator
  • Qualifying Ambiguous Column Names
  • Using Table Aliases
  • Joining More than Two Tables
  • Non-Equijoins
  • Retrieving Records with Non-Equijoins
  • Outer Joins
  • Outer Joins Syntax
  • Using Outer Joins
  • Self Joins
  • Creating Joins with the USING Clause
  • Retrieving Records with the USING Clause
  • Creating Joins with the ON Clause
  • Retrieving Records with the ON Clause
  • INNER Vs OUTER JOIN
  • Using a Subquery to Solve a Problem
  • Subquery Syntax
  • Guidelines for Using Subqueries
  • Types of Subqueries
  • Single-Row Subqueries
  • Executing Single-Row Subqueries
  • Using Group Functions in a Subquery
  • Multiple-Row Subqueries
  • Using the ANY Operator in Multiple-Row Subqueries
  • Using the ALL Operator in Multiple-Row Subqueries
  • Null Values in a Subquery
  • Data Manipulation Language
  • Adding a New Row to a Table
  • The INSERT Statement Syntax
  • Inserting New Rows
  • Inserting Rows with Null Values
  • Copying Rows from another Table
  • Changing Data in a Table
  • The UPDATE Statement Syntax
  • Updating Rows in a Table
  • Updating Two Columns with a Subquery
  • DELETE statement
  • Deleting Rows from a Table
  • Deleting Rows Based on another Table
  • Using a Subquery in an INSERT Statement
  • The MERGE Statement
  • The MERGE Statement Syntax
  • Database Transactions
  • Advantages of COMMIT and ROLLBACK Statements
  • Controlling Transactions
  • Rolling Back Changes
  • Implicit Transaction Processing
  • State of the Data before COMMIT or ROLLBACK
  • State of the Data after COMMIT
  • Committing Data
  • State of the Data after ROLLBACK
  • Locking
  • Implicit Locking
  • Database Objects
  • Naming Rules
  • The CREATE TABLE Statement
  • Referencing another User's Tables
  • The DEFAULT Option
  • Creating Tables
  • Tables in the Oracle Database
  • Querying the Data Dictionary
  • Creating a Table by Using a Subquery
  • The ALTER TABLE Statement
  • Adding a Column
  • Modifying a Column
  • Dropping a Column
  • The SET UNUSED Option
  • Dropping a Table
  • Changing the Name of an Object
  • Truncating a Table
  • TIMESTAMP Data Type
  • TIMESTAMP WITH TIME ZONE Data Type
  • TIMESTAMP WITH LOCAL TIME Data Type
  • What is Pseudocolumns ?
  • Rownum
  • Rownum in camparison
  • Objectives
  • What are Constraints?
  • Constraint Guidelines
  • Defining Constraints
  • The NOT NULL Constraint
  • The UNIQUE Constraint
  • The PRIMARY KEY Constraint
  • The FOREIGN KEY Constraint
  • FOREIGN KEY Constraint Keywords
  • The CHECK Constraint
  • Adding a Constraint Syntax
  • Dropping a Constraint
  • Disabling Constraints
  • Enabling Constraints
  • Viewing Constraints
  • What is a Sequence?
  • The CREATE SEQUENCE Statement Syntax
  • Creating a Sequence
  • Confirming Sequences
  • NEXTVAL and CURRVAL Pseudocolumns
  • Using a Sequence
  • Modifying a Sequence
  • Guidelines for Modifying a Sequence
  • Removing a Sequence
  • What is Database Objects
  • What is a View?
  • Why to use Views?
  • Simple Views and Complex Views
  • Creating a View
  • Retrieving Data from a View
  • Querying a View
  • Modifying a View
  • Creating a Complex View
  • Rules for Performing DML Operations on a View
  • Using the WITH CHECK OPTION Clause
  • Denying DML Operations (With read only Option)
  • Removing a View
  • Inline Views
  • What is an Index?
  • How Are Indexes Created?
  • Creating an Index
  • When to Create an Index
  • When Not to Create an Index
  • Confirming Indexes
  • Removing an Index
  • Objectives
  • Controlling User Access
  • Privileges
  • System Privileges
  • Creating Users
  • User System Privileges
  • Granting System Privileges
  • What is a Role?
  • Creating and Granting Privileges to a Role
  • Changing Your Password
  • Object Privileges
  • Granting Object Privileges
  • Using the WITH GRANT OPTION and PUBLIC Keywords
  • How to Revoke Object Privileges
  • Revoking Object Privileges
  • What is Synonyms?
  • C How Are Synonyms Created?
  • Removing Synonyms
PL/SQL Training
  • Introduction to PL/SQL
  • PL/SQL Execution Environment
  • PL/SQL Development Environment
  • Introduction to PL/SQL Procedures
  • Introduction to PL/SQL Functions
  • Introduction to PL/SQL Packages
  • Introduction to PL/SQL Triggers
  • Coding PL/SQL
  • The correct structure of a PL/SQL program block
  • Declare and initialize a variable
  • Declare and initialize data types and Boolean variables
  • IF Statement
  • IF-ELSIF Statements
  • Implement suitable control structures in PL/SQL
  • Implement a suitable loop construct in PL/SQL for a given scenario
  • Characteristics of FOR and nested loops in PL/SQL
  • Implementation of WHILE LOOP
  • Implementation of DO WHILE LOOP
  • EXIT Keyword
  • GOTO Statement
  • What is Sub Block?
  • Sub Blocks implementation
  • Modular Programming
  • Create and populate a user-defined record in PL/SQL
  • Create a record using the %ROWTYPE attribute and use it to insert and update a row
  • Create a record and use it to update a table
  • What is Cursor?
  • Cursor Types
  • Implicit Cursor
  • Use explicit cursors to retrieve data
  • Cursor attributes
  • For Loop Cursors
  • Advantages of For Loop Cursors
  • Default values in cursors
  • Use parameters to make cursors reusable in a given scenario
  • Use an explicit cursor to retrieve and update data
  • What is Exception?
  • Exception Section
  • About The Exception Section
  • Isolating the Specific Exception
  • Outline how each of the PL/SQL exception types are raised and handled
  • Trap predefined and non-predefined exceptions in PL/SQL
  • Trap user-defined exceptions and identify error codes and messages
  • Use nested blocks and the RAISE_APPLICATION_ERROR procedure when handling exceptions in PL/SQL
  • Handle exceptions in PL/SQL
  • Pragma Exception_Init
  • SQLcode & SQLerrm Example
  • SQL%Rowcount
  • Create, remove, and view PL/SQL stored procedures
  • Use IN, OUT, and IN OUT parameter modes to pass values to and from stored procedures and programs
  • Outline how to view values returned by OUT parameters
  • Create stored procedures with suitable parameters
  • Assign values to multiple parameters
  • Handle exceptions in stored procedures
  • Create a stored function
  • Execute a stored function
  • Call, remove, and view stored functions in PL/SQL
  • Definer Rights
  • Invoker rights
  • List all Procedures and Functions
  • Identify features of PL/SQL packages
  • Sequence steps for developing PL/SQL packages
  • Identify the syntax for creating a PL/SQL package
  • Identify tasks involved in managing PL/SQL packages
  • Identify features of the overloaded subprograms contained in PL/SQL packages
  • Identify features of forward referencing in PL/SQL packages
  • Identify features of the DBMS_LOB package
  • Identify the code to work with Large Object (LOB) values
  • Identify methods of selecting Character Large Object (CLOB) values
  • Identify features of temporary Large Objects (LOBs)
  • Identify features of Triggers
  • Identify the code to create a Data Manipulation Language (DML) trigger
  • Identify the code to create a Data Manipulation Language (DML) row Trigger
  • Match the options for managing triggers with their descriptions
  • Identify guidelines for testing triggers
  • Identify the benefits of triggers in different business application scenarios
  • Identify the syntax for creating triggers for DDL and system events
  • Creating Trigger on DDL Statements
  • LOGON & LOGOFF Trigger Example
  • CALL Statement in Trigger
  • Advantages of trigger
  • Conditional Security
Oracle DBA Training
  • Objectives
  • Understand Oracle Architecture
  • Create / Manage Database
  • Optimization of Database
  • Disaster Management
  • Duties & Responsibilities of DBA
  • Installation of Oracle Server & Application Tools
  • Allocation of Space and sizing storage requirements
  • Creation of Primary Database & Schema Objects
  • Modification of Database structure
  • Creating /maintaining of user
  • Performance Tuning
  • Backup & recovery
  • Optimal Flexible Architecture (OFA) complaint
  • Standard Architecture
  • Oracle Instance
  • Oracle Database
  • Single Process
  • Multi-Process
  • Database Structure
  • Logical (Tablespace, Segments, Extents, Schema Objects)
  • Physical (Control file, Data file, Redo log files)
  • Roll back segments
  • Transaction Management
  • Data Dictionary
  • Stand alone host
  • Multiple Databases
  • Networked Host
  • Clustered Servers
  • Invoking SVRMGRL
  • Startup
  • Start the Instance
  • Mount The Database
  • Open the Database
  • Shutdown
  • Normal
  • Immediate
  • Transactional
  • Abort
  • Alter Database
  • Enable Restricted Session
  • Parameter file
  • Tablespaces & Datafiles
  • Managing Tablespaces
  • Managing / Sizing Schema Objects
  • Managing Datafiles
  • Allocation of Space
  • Segments
  • Extents
  • Database Blocks
  • Index
  • Temporary
  • Rollback
  • Tables
  • Views
  • Indexes
  • Partitioning of tables & Indexes
  • Snapshots
  • Sequences
  • Synonyms
  • Database Links
  • Create a Database
  • Determine Instance
  • Copy & Edit Parameter Settings
  • Start the Instance
  • Connect the Instance
  • Physically Create the Database
  • Add Control File
  • Multiplexing Control files
  • Add Redo log Members
  • Multiplexing Redo log Members
  • Data dictionary users
  • Display Data Dictionary Views
  • Rollback segments
  • Create rollback segments
  • Alter Rollback segments
  • Guidelines for Managing RBS
  • Managing Locks
  • Types of Locks
  • Table Locks
  • Dictionary Locks
  • Dead Lock Detection
  • Monitor locking Activity
  • Create User
  • Alter User
  • Drop User
  • Monitor User
  • Profiles
  • Create Profile
  • Alter Profile
  • Drop Profile
  • Managing database security for Users
  • User Authentication
  • Types of Privileges
  • Different Roles
  • Default Roles
  • Dropping Roles
  • Changing Default Roles
  • Granting System Privileges & roles
  • Granting object Privileges
  • Revoke system Privileges & roles
  • Revoking Object Privileges
  • Cascading effects
  • Listing Privileges & Role Information
  • SQL Tuning
  • Memory Tuning
  • SGA
  • Library Cache
  • Dictionary Cache
  • Redo log Buffer Cache
  • I/O Tuning
  • Disk Contention
  • Space in data block
  • Trace files & Alert Files
  • Contention for Rollback segments
  • Tune free lists
  • Tune Checkpoints
  • SQL Trace facility & TKPROF Utility
    • Multiple Database/ Distributed Database Management
    • Database Auditing & Security
    • NET8
  • Operating System Backups (Cold Backups)
  • Online Backup (Hot Backups)
  • Recovery Structure
  • Archive Modes
  • Change Archive Modes
  • Enable Archive Processing
  • Archive Log Files
  • Database Errors
  • Recovers from User error
  • Recovery from Statement Failures
  • Recover from Instance failure
  • Recovery from Media Failure
  • Recovery with Archiving
  • Recovery Without Archiving
  • Disable Archive Processing
  • Backup Control file
  • Recover a Control file
  • Legato Storage Manager
  • Recovery Manager (RMAN)
  • Export
  • Export Basics
  • Export Parameters
  • Incremental Export
  • Cumulative Export
  • Complete Export
  • Import
  • Import basics
  • Import modes
  • Import Parameters
  • Incremental Import
  • Cumulative Import
  • Complete Import
  • SQL*Loader
  • Basics
  • Direct path Loads
  • Conventional Path Loads
  • Logging information
  • Control file
  • Data file
  • Discard File
  • Bad file
  • Case Studies
    • Monitoring Common Problem Areas & Useful DBA Scripts
    • Oracle Standard Installation
    • Oracle (OFA) Installation
    • Oracle Database Connectivity With Front Ends
Oracle Apps DBA Training
  • Oracle E-Business Suite Home Page
  • Oracle E-Business Suite Architecture
  • Oracle E-Business Suite Technology Stack
  • Installation Tools
  • Oracle E-Business Suite Products
  • Overview of Rapid Install
  • Supported Platforms and Environments
  • Prerequisites and Preparatory Tasks
  • Starting Rapid Install
  • Obtaining Help
  • Installation Types and Options
  • Standard Installation
  • Express Installation
  • Required Post-Installation Steps
  • Conditional Post-Installation Steps
  • Administration and Maintenance Tasks
  • Oracle E-Business Suite Technology Stack
  • Desktop Tier
  • Application Tier
  • Database Tier
  • Oracle E-Business Suite Technology Layer
  • Oracle Applications DBA
  • Oracle Application Object Library
  • Oracle E-Business Suite Utilities
  • Oracle E-Business Suite Environment Files
  • Application Tier Service Control Scripts
  • Character Sets
  • Globalization Features
  • Language Support
  • File System Overview
  • INST_TOP Directory Structure
  • Database Tier File System
  • Application Tier File System
  • APPL_TOP Directory Structure
  • Product Directories
  • Technology Stack Directory
  • Database Directories
  • Database Overview
  • Oracle E-Business Suite Database Objects and Schemas
  • Implementing Multiple Organizations
  • Reporting Currencies
  • Monitoring Features
  • Performance Features
  • Scalability Features
  • Database Tier Server Control Scripts
  • Shared Application Tier File System
  • Load Balancing
  • Network Features
  • Overview
  • Setting the Environment
  • The AD Utilities
  • Command Line Arguments and Flags
  • AD Utilities Features and Prompts
  • Parallel Processing Options and Distributed AD
  • Log and Restart Files
  • Maintenance Mode
  • Preliminary Tasks
  • Prompts and Log Files
  • Generate Applications Files Menu
  • Generate Message Files
  • Generate Form Files
  • Generate Report Files
  • Generate Product JAR Files
  • Maintain Applications Files Menu
  • Relink Applications Programs
  • Copy Files to Destinations
  • Convert Character Set
  • Maintain Snapshot Information
  • Checking for Missing Files
  • Performing File System Tasks
  • Compile/Reload Database Entities Menu
  • Compile APPS Schema
  • Compile Menu Information
  • Compiling Flexfield Data in AOL Tables
  • Reloading JAR Files into Database
  • AD Controller Overview
  • Worker Status Flow
  • Restarting an AD Utility
  • Shutting Down Managers
  • AD Relink Overview
  • Running AD Relink
  • AutoConfig Overview
  • Context Files
  • AutoConfig Tasks
  • Running AutoConfig
  • AutoConfig Log Files
  • Rolling Back an AutoConfig Session
  • Running AutoConfig in Test Mode
  • Other AutoConfig Features
  • AD Configuration
  • AD File Identification
  • AD Job Timing Report
  • AD Splicer Overview
  • AD Splicer Control Files
  • Editing newprods.txt File
  • Post-Splice Steps
  • File Character Set Converter
  • Patch Terminology and Components
  • Downloading Patches
  • AutoPatch Features
  • Patch Wizard
  • Running AutoPatch
  • OAM Timing Reports
  • Other Patching Topics
  • Applied Patches Information
  • Principles and Terminology
  • Cloning Scenarios
  • Prerequisite Steps
  • Cloning Steps
  • Finishing Tasks
  • Refresh a Target System
  • Clone a Multi-Node System
  • Add a Node to an Existing System
Learn Basic Oracle RAC DBA Training
  • What is a Cluster
  • Grid Foundation Components
  • Oracle Clusterware Architecture
  • Oracle Clusterware Software and Storage
  • Describe ASM Architecture
  • Creating and Managing ASM Disk Groups
  • Creating and Managing ASM Cluster File systems
  • Administering Oracle Clusterware
  • Troubleshooting Oracle Clusterware
  • Hardware Requirements
  • Network Requirements
  • Software Requirements
  • DNS and DHCP Configuration
  • Grid Plug and Play Considerations
  • Single Client Access Names
  • Post installation tasks
  • ASM Instance
  • ASM Disks
  • ASM Disk Groups
  • ASM Redundancy
  • Linux OS Software Installation
  • Create OS Group and User Accounts
  • Networking
  • Synchronizing the Time on ALL Nodes
  • Configuring Kernel Parameters
  • Set shell limits for the oracle & grid user
  • Create the Oracle Inventory Directory
  • Creating the Oracle Grid Infrastructure Home Directory
  • Creating the Oracle Base Directory
  • Creating the Oracle RDBMS Home Directory
  • Stage the Oracle Software
  • Check OS Software Requirements
  • Cluster Verification Utility
  • Types of Shared Storage
  • Partition the Shared Disks
  • Installing and Configuring ASMLib
  • Using ASMLib to Mark the Shared Disks as Candidate Disks
  • Basic/Advanced Grid Infrastructure Install (without GNS and IPMI)…
  • Grid Infrastructure Home Patching
  • RDBMS Software Install
  • Run ASMCA to create disk groups
  • Installing The Oracle Database Software
  • Creating A Cluster Database
  • Post database Creation Tasks
  • Managing Clusterware with Enterprise Manager
  • Determining the Location of the Oracle Clusterware Configuration Files
  • Backing Up and Recovering the Voting Disk
  • Adding, Deleting, or Migrating Voting Disks
  • Locating the OCR Automatic Backups
  • Oracle Local Registry
  • Migrating OCR Locations to ASM
  • Managing Network Settings
  • Managing Oracle Clusterware
  • ASM Initialization Parameters
  • Adjusting ASM Instance Parameters in SPFILEs
  • Starting and Stopping ASM Instances Using srvctl
  • Starting and Stopping ASM Instances Using ASMCA and ASMCMD
  • Starting and Stopping ASM Instances Containing Cluster Files
  • Starting and Stopping the ASM Listener
  • Administering ASM Disk Groups
  • Creating and Deleting ASM Disk Groups
  • ASM Disk Group Attributes
  • ASM Disk Group Maintenance Tasks
  • Viewing ASM Disk Statistics
  • Using addNode.sh to add a Node to a Cluster
  • Rolling Patches and Rolling Upgrades
  • Installing a Patchset with the OUI Utility
  • Installing a Patch With The opatch Utility
  • Add/Deleting the Instance
  • Add the Node
  • Remove the Node
  • Single-Instance Conversion Using rconfig
  • Single-Instance Conversion Using DBCA
  • Oracle Clusterware Log Files
  • Gathering Log Files Using diagcollection.pl
  • Component-level Debugging
  • RAC-Specific Wait Events, Global Enqueues, and System Statistic
  • Implementing the Most Common RAC Tuning Tips
  • Using the Cluster Database Performance Pages
  • Using the Automatic Workload Repository in RAC
  • Using Automatic Database Diagnostic Monitor in RAC
Oracle Service Business Training
  • Overview of service-oriented architecture (SOA)
  • Overview XML, XSD, WSDL, Webservices
  • Why is OSB?
  • Introducing the Service Oriented Architecture
  • Describing the Oracle Service Bus Architecture
  • Introducing the Role of Oracle Service Bus
  • Overview of weblogic server
  • Overview of OSB server and meta data schemas
  • Creating domain in weblogic server.
  • Install OSB Server
  • Overview of start and stop steps of OSB server and Admin Server.
  • Business Service
  • Proxy Service
  • Message Flow
  • Resources of OSB
  • Change Centre in OSB
  • Export and Import of OSB Coding
  • How to create and use of Customization file in OSB
  • Introducing the Oracle Service Bus Resources
  • Explaining the Message Context Model and the Message Context Variables
  • Understanding the Message Flow and the Nodes/Elements of a Message Flow
  • Describing the Communication Actions You Can Add to a Route or a Stage in a Message Flow
  • Describing the Flow Control Action You Can Add to a Route or a Stage in a Message Flow
  • Describing the Message Processing Actions You Can Add to a Stage in a Message Flow
  • Describing the Reporting Actions You Can Add to a Stage in a Message Flow
  • Using XQuery Mapping and Transformations
  • Describing Oracle SOA Suite Transport (SOA-DIRECT)
  • How to Import XSD/WSDL
  • How to Create Business service using other WS
  • Describing JCA Transport
  • Describing and Configuring Error Handling in Oracle Service Bus
  • Configuring Validation in Oracle Service Bus
  • Explaining the Usage of the Reporting Action
Oracle Weblogic Admin Training
  • Intro about Web logic Server
  • What is an application server
  • Middleware
  • J2EE Technologies
  • Web & WLS Terms
  • Web Logic Server Architecture
  • Download of WebLogic
  • Installing of Web Logic Server 11g (GUI /Console /Silent) on both Windows/Linux
  • Starting and Stopping Web Logic Server
  • Various types of Start/Stop of Servers
  • Intro about Admin, Managed Servers, Domain, Machine and Node Manager
  • Configuring Admin Servers
  • Configuring Managed Servers
  • Configuring Node Manager
  • Configuring of Machine
  • Console Administration
  • Command Line Administration
  • Configuration of Domain using Dev and Prod Mode
  • Difference between Dev and Prod Mode of Domain
  • The Benefits of Oracle WebLogic Cluster
  • Types of Cluster (Vertical/Horizontal)
  • Configuring Vertical / Horizontal Cluster
  • Communication Among Clustered Server Instances
  • The Key Criteria for Selecting Suitable Cluster Architecture
  • Preparing Your Environment for a Cluster
  • Creating and Configuring a Cluster for Vertical / Horizontal.
  • Adding Servers to a Cluster
  • Starting Up and Shutting Down Clustered Servers.
  • Finding Weblogic Sever Version
  • PassBasis Commands
  • What is Classpath? How to set Classpath in WebLogic
  • Importance of setWLSEnv/setDomainEnv.sh file
  • Importance of config.xml file
  • Importance of boot.properties file
  • Importance of nodemanger.properties file
  • Monitoring and handling of Servers, Domains
  • Enabling of Administration Port
  • Virtual Host
  • Overview of Deployment
  • Various types of Deployment
  • Java Applications
  • Web Applications
  • Advanced Deployment
  • Overview of Deployment
  • Various types of Deployment
  • Java Applications
  • Web Applications
  • Advanced Deployment
  • Introduction to JNDI
  • Overview of JDBC
  • Data Sources
  • Types of Data Sources (Generic/GridLink/Multi)
  • Configuration of Data Sources
  • Administration of Data Sources
  • Explaining the Components of JDBC URLs
  • Monitoring and Testing a Data Source
  • Overview of Transactions (XA and Non-XA)
  • Describing JMS
  • Describing How Oracle WebLogic Server JMS is Implemented
  • Configuring JMS Server
  • Configuring Connection Factories
  • Configuring Queues and Topics
  • Configuring Persistent Messages
  • Deploying an Application that Uses JMS
  • Monitoring JMS Resources and Messages
  • Over view of Security Realms
  • Configuring Users and Groups
  • Admin Server Password Reset
  • Build
  • Overview of Log Management
  • Various Types of Log File for Trouble Shooting
  • Server Log and access logs
  • Log Management
  • Rotation/Archiving/ log files
  • Troubleshooting issues in WebLogic
  • The JVM
  • Memory Management
  • Garbage Collection Mechanism
  • GC Performance Improvements
  • Heap Management
  • Thread Management
  • Thread / heap Dump
  • Oracle Patching /Upgrade
  • Backup Plan in Web logic
  • Introduction to WLST
  • Modes
  • Script Generation
  • Script Recording
Oracle SOA Training
  • Overview of service-oriented architecture (SOA)
  • Overview XML, XSD, WSDL, Web services
  • Why is SOA?
  • What is SCA?
  • Overview of weblogic server
  • Overview of SOA server and meta data schemas
  • Creating domain in weblogic server.
  • Install SOA Server
  • Overview of start and stop steps of SOA server and Admin Server.
  • Synchronous Pattern
  • Asynchronous pattern
  • One way invoke
  • Define a composite application
  • Describe SOA Composite Editor
  • Explain Component Type Files.
  • Explain SOA composite.
  • Lab
  • Understand BPEL designer (JDeveloper) and activities
  • Creating your first BPEL Process – HelloWorld
  • Xpath Expression Builder
  • Deploying the SOA Composite application.
  • Managing Deployments/Un-Deployments with Enterprise Manager 11g
  • Orchestrating Services with BPEL for Synchronous, Asynchronous and One-way Service
  • Overview of Partner Link. Why do we need myRole-PartnerRole concept
  • Lab
  • Create a synchronous process
  • Create an asynchronous process
  • Create One-way
  • XSLT mapping tool
  • XSLT map Testing and analysing at design time.
  • Understanding activities XSL, Switch, flow and While.
  • Lab
  • Processing with Parallel Flows
  • Using Flown activity
  • Conditional Branching
  • Lab
  • Develop BPEL process to use pick(Receive inputs from Multiple Operations)
  • Develop BPEL process that can time out a call to an Async process, using OnAlarm branch
  • Understanding File, Database and JMS Adapter
  • Lab
  • Read and write a file using file adapter
  • Poll for new rows in a table using DB adapter
  • Insert data into JMS queue using JMS adapter
  • Working with Mediator Components
  • Explain the Mediator component and its features
  • Parallel Flows and sequential flows.
  • Lab
  • Creating a Mediator Component
  • Adding Routing Rules
  • Create XSL Transformations with XSLT Mapper
  • Create Content Based Routing filters
  • Human Workflow Service Concepts
  • Features of workflow service
  • Lab
  • Sending an approval notification
  • Modeling workflows
  • Introduction to Business Rules.
  • Introduction to Decision tables
  • Lab
  • Using Business Rules and Decision tables in BPEL
  • Explain Fault Types
  • System faults
  • Business faults
  • Process based Fault handling
  • Policy based fault handling
  • Lab
  • Using Throw activity to throw faults
  • Using Fault Handler to handle faults
  • Compensation handler
  • Using policy files
Oracle ADF Training
  • What is Oracle ADF?
  • MVC architecture
  • Benefits of ADF
  • ADF architecture
  • ADF Faces
  • JDeveloper tools
  • Applications and projects
  • Database connections
  • Overview of Business components
  • Steps to create business components
  • Business Components diagram
  • Application flow overview
  • What is an entity object?
  • Entity object class diagram
  • Creating entity objects
  • Customizing attribute properties
  • Entity associations
  • Entity object definition file
  • Database synchronization, moving, and renaming
  • Entity diagrams
  • What is a view object?
  • View object class diagram
  • Steps to create a view object
  • Bind variables
  • Query-by-example view criteria
  • Adding view object instance to application module
  • Testing view objects
  • Read-only master-detail tables
  • Master-detail-detail
  • Inline detail tables
  • Built-in conversion
  • Custom converters
  • Entity object validation
  • Creating validation rules
  • Error messages
  • ADF Faces validation
  • ADF table overview
  • Table selection and sorting
  • Result set scrolling and navigation
  • Table and Column attributes
  • Editing records
  • Table bindings
  • Deleting records
  • Row Disclosure
  • Creating Context Menus
  • Handling multiple selections
  • ADF Trees
  • ADF TreeTables
  • JSF lifecycle
  • ADF Faces Rich Client lifecycle
  • ADF page lifecycle
  • Monitoring the lifecycle
  • Subforms
  • Control flow rules
  • Common input components
  • Managed beans and scopes
  • Drop-down menus
  • Multiple select components
  • Search concepts
  • Query-by-example
  • Search forms and bind variables
  • Bounded vs. unbounded task flows
  • ADF controller activities
  • Managed beans and scoping
  • State tracking
  • Save points
  • Exception handling
  • Passing values between pages
  • Bookmarking
  • Using bounded child task flows
  • Transaction handling
  • Managing the browser back button
  • Bounded task flows in dialogs and popups
  • Managing task flow templates
  • Using page fragments
  • Using ADF regions
  • Dynamic regions
  • Managing contextual events
  • Communicating with ADF Regions
  • Bread crumbs
  • Reusable menu concepts
  • Process train
  • Partial page navigation
  • Navigating programmatically
  • Container-managed security
  • JAAS
  • ADF security overview
  • Enabling security
  • Creating users, groups, and roles
  • Page and task flow permissions
  • Security Expression Language
  • Securing entity objects
  • Row-level security
  • Logging in and out
  • Custom Java classes – EO and VO
  • Custom validation methods – EO
  • Calculated attributes – EO and VO
  • Finding, creating, removing, and modifying EOs and VOs
  • What is a web service?
  • SOAP, WSDL, UDDI
  • Web service data control
  • Securing a web service
  • Consuming a web service – JSP
  • Web service proxy
  • Business Components Browser
  • Expression language builder
  • Page definition errors
  • Java logging
  • Breakpoints
  • Breakpoint groups
  • Debugging configuration
  • The Stack
  • Deployment steps
  • WebLogic admin basics
  • Deployment Profiles
  • Deployment Options
  • Deploying an application with JDeveloper
  • Testing your application
Introduction to Oracle Applications and OAF
  • Oracle Applications Framework
  • OAF and MVC
  • OAF Process Flow
  • More about OAF
  • JDeveloper Features
  • Building OAF Application in JDeveloper
  • Configuring JDeveloper Preferences
  • Understand the basics of BC4J
  • Understand an Entity Object
  • Understand a View Object
  • Understand an Application Module
  • Understand the terminology
  • Building a basic OA Framework page
  • List of Values
  • Building Search Regions
  • Using JDeveloper debugger
  • Examine Runtime variables and arguments
  • Modify Runtime variables and arguments
  • Understanding OA Framework Controller
  • Enhance an OA Framework page
  • OA Framework : Message Dictionary
  • Initial Setup Flow
  • Controller Event Flows
  • Request Flow (GE
  • Submit Flow (POST)
  • General Naming Rules
  • Package Naming
  • Page and Region Naming
  • Item Naming
  • Exception types and Classes
  • Bundled exceptions
  • Dialog pages
  • Debugging messages
  • Client Validations
  • Required values and Data types
  • Server Validations
  • Entity object and View object validations
  • Using Auto Submit
  • Using Partial Submit
  • Trigger and Target Components
  • Implementing Partial Page Rendering
  • OA Framework State Caches
  • Passivation
  • “Back” button support
  • Types of Extension
  • Overriding Default Values
  • Override Attribute Validation
  • BC4J and JDBC Guidelines
  • SQL Tracing
  • Monitor Connection Pool
  • OA Framework Performance Standards
  • OA Framework page menus
  • Registering functions for OA Framework pages
  • Creating Responsibilities and Users
  • Using JSP test page
  • Date and Timezone Internationalization
  • Number and Currency Internationalization
  • Testing Internationalization
  • Creating Deployment Profiles
  • Deploying Model
  • Deploying View and Controller
Oracle Form Developer Training
  • Grid Computing
  • Oracle 10g Products
  • Oracle Application Server 10g Architecture
  • Benefits and Components of Oracle Developer Suite 10g
  • Running a Forms Developer Application
  • Working in the Forms Developer Environment
  • Creating a Basic Forms Module
  • Creating a Master-Detail Forms Module
  • Modifying the Data Block
  • Modifying the Layout
  • Using the Property Palette
  • Managing Object Properties
  • Creating and Using Visual Attributes
  • Controlling the Behavior and Appearance of Data Blocks
  • Controlling Frame Properties
  • Creating Control Blocks
  • Deleting Data Blocks
  • Creating Text Items
  • Controlling the Behavior and Appearance of Text Items
  • Creating LOVs
  • Defining Editors
  • Creating Check Boxes
  • Creating List Items
  • Creating Radio Groups
  • Creating a Display Item
  • Creating an Image Item
  • Creating a Push Button
  • Creating a Calculated Item
  • Creating a Hierarchical Tree Item
  • Creating a Bean Area Item
  • Overview of Windows and Canvases
  • Displaying a Forms Module in Multiple Windows
  • Creating a New Window
  • Displaying a Forms Module on Multiple Layouts
  • Creating a New Content Canvas
  • Creating a New Stacked Canvas
  • Creating a New Toolbar Canvas
  • Creating a New Tab Canvas
  • Grouping Triggers into Categories
  • Defining Trigger Components: Type, Code, and Scope
  • Specifying Execution Hierarchy
  • Using the PL/SQL Editor
  • Writing Trigger Code
  • Using Variables and Built-ins
  • Using the When-Button-Pressed and When-Window-Closed Triggers
  • The Debugging Process
  • The Debug Console
  • Setting Breakpoints
  • Debugging Tips
  • Running a Form in Debug Mode
  • Stepping through Code
  • Coding Item Interaction Triggers
  • Defining Functionality for Check Boxes
  • Changing List Items at Run Time
  • Displaying LOVs from Buttons
  • Populating Image Items
  • Populating and Displaying Hierarchical Trees
  • Interacting with JavaBeans
  • Built-ins and Handling Errors
  • Controlling System Messages
  • The FORM_TRIGGER_FAILURE Exception
  • Using Triggers to Intercept System Messages
  • Creating and Controlling Alerts
  • Handling Server Errors
  • SELECT Statements Issued During Query Processing
  • WHERE and ORDER BY Clauses and the ONETIME_WHERE Property
  • Writing Query Triggers
  • Query Array Processing
  • Coding Triggers for Enter-Query Mode
  • Overriding Default Query Processing
  • Obtaining Query Information at Run Time
  • Validation Process
  • Controlling Validation Using Properties
  • Controlling Validation Using Triggers
  • Performing Client-Side Validation with PJCs
  • Tracking Validation Status
  • Using Built-ins to Control When Validation Occurs
  • Navigation Overview
  • Understanding Internal Navigation
  • Using Object Properties to Control Navigation
  • Writing Navigation Triggers: When-New
  • BC4J and JDBC Guidelines
  • SQL Tracing
  • Monitor Connection Pool
  • OA Framework Performance Standards
  • OA Framework page menus
  • Registering functions for OA Framework pages
  • Creating Responsibilities and Users
  • Using JSP test page
  • Date and Timezone Internationalization
  • Number and Currency Internationalization
  • Testing Internationalization
  • Creating Deployment Profiles
  • Deploying Model
  • Deploying View and Controller
Oracle Apps Technical Course Content
  • Role of Technical Consultant
  • Architecture
  • Architecture of Oracle Application Package
  • Product Directory Structures
  • Users
  • Responsibilities
  • Role of Apps Database User
  • File Objects in Oracle Applications
  • Database objects in Oracle Applications
  • Profile Options
  • Registration
  • Table Registration
  • Table Registration using AD_DD package
  • View Registration
  • Sequence Registration
  • New Application/New Module Development
  • Form Registration
  • Form Functions
  • Non-Form Functions
  • Basic Report Registration
  • Parametric Report Registration
  • Registration of SQL*Plus files
  • Registration of SQL*Loader files
  • Report Development
  • Customization of Reports – Adding DFF Info
  • Customization of Reports – Removing Parameter s
  • Flexfield Report with Single Structure
  • Interface Development
  • Interface Scenarios
  • Usage of Standard Import Programs
  • Daily Rates Import
  • GL_Interface
  • Up-gradation
  • Forms Up-gradation
  • Reports Up-gradation
  • Menus Up-gradation
  • XML Publisher
  • Introduction
  • Generating XML File through Report Builder
  • Creating a Template
  • Generating RTF Output
  • Register XML Report in APPS
  • Discoverer Administration Edition
  • Creating a private end user layer for a new tutorial
  • database user
  • Connecting to discoverer administrator , using the load
  • wizard and the work area
  • Modifying the Business Area
  • Working with Custom Folders
  • Creating Joins
  • Customizing Items
  • Designing a complex Folder
  • Working with Hier archies
  • Form Development Process
  • Template Form Architecture
  • Appsstand Architecture
  • FNDMENU Architecture
  • Coding Standards
  • Name Conventions
  • Form Development Process
  • WHO Information Tracking
  • Row LOV
  • Queries find Window
  • Customization of Forms
  • Programming of Non-Form Functions
  • Calendar s
  • Flexfields
  • Introduction to Key and Descriptive Flexfields
  • Enabling a DFF
  • DFF Registration
  • KFF Registration
  • Define a KFF Flexfields Structure
  • Invoking DFF form of New Form
  • Invoking KFF Form of New Form
  • Report Development
  • Report Coding Standar ds
  • User Exits in Report design
  • Customization of Reports – Adding Parameter s
  • Customization of Reports – Adding Logos
  • Discoverer User Edition
  • Creation of Simple Workbook
  • To design parameterized workbook
  • To change Heading items
  • To insert new sheet in the Workbook
  • To add and remove items from Workbook
  • To create duplicate sheet in Workbook
  • To add title to the Worksheet
  • To insert date, time, page numbers and image on
  • Header /Title of Workbook
  • To apply Conditional For matting
ERP –Oracle Applications-Finance Functional Consultant
  • Introduction to ERP
  • What is oracle
  • History of Oracle & People behind Oracle Corp
  • What is Oracle Application/E-Business suite
  • Versions available in Oracle
  • Versions available in Oracle Application
  • What are major modules available in Oracle
  • ERP’s available in the market
  • Why Oracle application is so popular
  • What Basically Implementation is?
  • Overview of Implementation of Oracle Application
  • Companies Implementing Oracle Application
  • Overview of AIM
  • Job Opportunities & Academic requirement
  • Introduction
  • Calendars
  • Flex fields
    • Accounting Flex field
    • GL Ledger Flex field
  • Chart of accounts
  • Accounting Setup Manager
  • Define Legal Entities
  • Define Ledgers
  • Define Accounting Options
  • Add Legal Entities to Ledgers
  • Assign BSV to Legal Entities
  • Ledger sets
  • Definition Access Sets
  • Auto copy journals
  • Reversal journals
    • Manual reversal
    • Auto reversal
  • Suspense Journals
  • Recurring Journals
    • Standard
    • Skeleton
    • Formula
  • Inter Company & Intra company journals
    • Without Qualifying method
    • With Qualifying method
  • Reporting Currency Ledgers
    • Balance Method
    • Journal Method
    • Sub Ledger Method
    • Adjustments Only
  • Revaluation Process
  • Consolidation Workbench
  • Summary of Accounts
  • Period Close Process
  • MOAC Setup
    • Define Locations
    • Define Business Group
    • Define Operating Units
    • Define Security Profiles
    • Define HR Organization
    • Define Security and User Access
    • Define Purchasing Options
    • Define Jobs
    • Define Positions
    • Define Employees
    • Define Employee/Position Hierarchies
    • Define Buyers
    • Define Approval Groups
    • Approval Group Assignments
  • Process Setups
    • Define Master Items
    • Create Requisitions
    • Define Suppliers
    • Create Purchase Orders
    • Approving Purchase Orders
    • Creating Receipts
    • Self Billing Invoices (Auto Invoice)
    • Create Document Styles
    • Create Complex Work Orders
    • Create Accounting
    • Returns
    • Receiving Options
    • Close/ Cancel P.O Requisition P.O Gaps
  • Oracle Payables
    • MOAC Setup
    • Define Financial Options
    • Define Payables Option
    • Invoice Work Bench
      • Standard
      • Credit Memo
      • Debit Memo
      • Mixed Invoices
      • Pre Payments
      • Retain Age Release
      • Payment Request
      • Expense Report
      • Withholding Tax Invoices
      • Interest Invoices
      • Transportation Invoices
      • Recurring Invoices
      • Define Grants & Roles (User Management)
      • Define Banks
      • Define Branches
      • Define Bank Accounts
      • Define Payables Documents
      • Define Organization Access
      • Define Netting Accounts
    • Payment Workbench
      • Manual Payments
      • Quick Payments
      • Netting Payments
      • Bills Receivables
      • Refund Payments
    • Period Close Process
    • Holds
    • Manual Hold
    • System Hold
    • Invoice Matching With P.O
    • Quick Match
    • Match (P.O)
    • Adjustment Invoices
    • Corrections
    • Payment Terms
    • Distribution Set
      • Full Type
      • Skeleton Type
    • Cancellation Invoices
  • Oracle Payments (ipayments)
    • System Security Options
    • XML Publisher Format Template
    • Payment Format
    • Payment Methods
    • Payment Method Defaulting Methods
    • Payment Process Profile
    • Payments Manager
  • Fixed Assets
    • Flex filed
      • Category Flex field
      • Asset Key
      • Location
    • Define System Controls
    • Define Fiscal Years
    • Define Calendars
      • Depreciation Calendar
      • Prorate Calendar
    • Define Prorate Conventions
    • Define Depreciation Methods
    • Define Asset Categories
    • Define Asset Books
    • Addition of Assets
    • CIP Addition
    • Quick Addition
    • Manual Addition
    • Mass Addition
    • Mass addition of Assets from Payables
    • Run Depreciation
    • Mass Retirements
    • Mass Revaluation
    • Mass Changes
    • Mass Transfers
    • Mass Re-Classifications
    • Create Accounting
    • Transferring Assets to GL
  • Oracle Receivables
    • MOAC Setups For Receivables
    • Configure System Options
    • Introduction to TCA
    • TCA Setups
    • DQM
      • Security
      • Profile Classes
      • Customers
      • Parties
      • Organizations
      • Relationships
      • Administration & Security
    • Auto Accounting
    • Transaction Types
    • Transaction Batch Sources
    • Document Sequencing
    • Transaction Workbench
      • Invoices
      • Credit Memo
      • Debit Memo
      • Deposits
    • Guarantee
    • Charge back
    • Bills Receivables
    • Transaction With Rules
      • Invoicing Rules
      • Accounting Rules
    • EBT (Enterprise Business Taxes)
      • Geography Codes
      • Tax Regimes
      • Taxes
      • Tax Statuses
      • Tax Jurisdiction
      • Tax Rates
      • Tax Rules
      • Application Tax Options
      • Configuration Tax Options
      • Create Party Tax Profile
      • Create Party Tax Profile for third parties
  • Sub Ledger Accounting Methods
    • Event Entities
    • Event Classes
    • Event Types
    • Process Categories
    • Sources
    • Mapping set
    • Journal Entry Description
    • Journal Line Types
    • Journal Line Definitions
    • Application Accounting Definitions
    • Sub ledger Accounting Methods
    • Customizing SLA
  • Cash Management
    • MOAC for Cash Management
    • Define System Parameters
    • Define Reconciliation Controls At Internal Banks
    • Manual Reconciliation
    • Automatic Reconciliation
    • Bank Account Transfers
  • Oracle Technical - Application Object Library
    • Introduction to Application Object Library
    • About Application Folders
    • Introduction to Interfaces
    • Types of Interfaces
    • Understanding SQL *Loader
    • Interface – Journal Import Using – Excel Data
    • Interface – Budget upload Using – Flat file Data
    • Introduction to Concurrent Programs
    • Concurrent Programs – – SQL Loader
    • Concurrent Programs – Journal Line Report – Oracle D2K Reports
  • Highlights of the Program
    • Check our Course Curriculum before you join anywhere
    • Attend 1 Free Demo Classes without any Registration
    • Free FAQ’s Prepared by Faculty
    • Learn Oracle Financials from the Experts to build your Career
Oracle Reports Developer Training
  • Grid Computing
  • Oracle 10g Products
  • Oracle Application Server 10g Architecture
  • Benefits and Components of Oracle Developer Suite 10g
  • Running a Forms Developer Application
  • Working in the Forms Developer Environment
  • Business Intelligence
  • Enterprise Reporting
  • Oracle Reports Developer
  • Oracle Database 10g
  • Oracle Developer Suite 10g
  • Oracle Application Server 10g
  • OracleAS Reports Services
  • OracleAS Reports Services Architecture for the Web
  • Understanding User Requirements
  • Designing Reports
  • Tabular
  • Master-Detail
  • Master with Two Details
  • Matrix
  • Retrieving and Sharing Data
  • Running a Report
  • Reports Developer Executables
  • Invoking Reports Builder
  • Reports Builder Modules
  • Report Data and Layout
  • Reports Builder Components
  • Object Navigator
  • Report-Level Objects
  • Data Model Objects
  • Report Module Components
  • Building a Paper Report
  • Viewing the Paper Report Output
  • Saving the Report Definition
  • Reentering the Wizard
  • Creating Break Reports
  • Break Report Labels
  • Creating Mailing Labels and Letters
  • What Is the Paper Design?
  • The Paper Design Window
  • Modifying a Report
  • Aligning Columns
  • Setting a Format Mask
  • Manipulating Objects
  • Modifying Visual Attributes
  • Applying Conditional Formatting
  • Using Report Templates
  • Modifying a Template
  • Customizing the Template Margin
  • Adding Web Links to a Template for Report HTML Output
  • Predefining Your Own Templates
  • Adding a Template Preview Image
  • What Is JSP Technology?
  • JSP Advantages
  • Simple JSP Example
  • Building a Web Report
  • Using the Report Wizard
  • Report Editor: Web Source View
  • JSP Tags
  • Web Source Example
  • The Data Model Objects
  • Modifying Properties of a Query
  • Applying Changes
  • Changing the Group Structure
  • Group Hierarchy
  • Ordering Data in a Group
  • Query Modifications
  • Filtering Data in a Group
  • Data Source Types
  • Pluggable Data Sources
  • Using XML as a Data Source
  • Document Type Definition File
  • OLAP Data Source
  • Using Text as a Data Source
  • Using JDBC as a Data Source
  • Using REF Cursor Queries
  • Data Model Columns
  • Maintaining Data Source Columns
  • Producing File Content Output
  • Creating a Column
  • Creating Summary Columns
  • Displaying Subtotals
  • Displaying Percentages
  • Creating a Formula Column
  • Viewing the Paper Layout
  • Designing Multi-panel Report
  • Printing Multi-panel Reports
  • Different Objects in the Paper Layouts
  • The Paper Layout Layers
  • Report Processing
  • Paper Layout Tools
  • Report Bursting
  • Viewing the Paper Layout
  • Designing Multi-panel Report
  • Printing Multi-panel Reports
  • Different Objects in the Paper Layouts
  • The Paper Layout Layers
  • Report Processing
  • Paper Layout Tools
  • Report Bursting
  • Modifying Paper Layout Object Properties
  • Common Layout Properties
  • Sizing Objects
  • Anchors
  • Layout Object Relationships
  • Pagination Icons in the Paper Layout
  • Controlling Print Frequency
  • Using Format Triggers
  • Properties of a Repeating Frame
  • Specifying Print Direction
  • Controlling the Number of Records per Page
  • Controlling Spacing Between Records
  • Minimum Widow Records
  • System Variables
  • Valid Source Columns
  • Displaying File Contents
  • Comparing Static and Dynamic Reporting
  • Adding Dynamic Content
  • Creating a Report Block
  • Invoking the Report Block Wizard
  • Examining the Web Source Code
  • rw:foreach Tag
  • rw:field Tag
  • Customizing Reports JSPs
  • Why Use XML Report Definitions?
  • Creating XML Report Definitions
  • Partial Report Definitions: Format Modification Example
  • Partial Report Definitions: Format Exception Example
  • Full Report Definition: Data Model Modification Example
  • Running XML Report Definitions
  • Debugging XML Report Definitions
  • Creating User Parameters
  • Referencing Parameters in a Report Query
  • Using Bind References
  • Using Lexical References
  • Hints and Tips When Referencing Parameters
  • Creating a List of Values
  • Referencing System Parameters
  • Building a Paper Parameter Form
  • Adding a Graph to a Paper Report
  • Adding a Graph to a Web Report
  • Selecting the Graph Type
  • Selecting the Graph Data
  • Adding Options to the Graph
  • Customizing Web Graphs
  • The rw:graph Tag
  • Customizing Graphs Using the Graph.XML File
  • The Matrix Data Model
  • The Matrix Paper Layout
  • Creating Matrix Summaries
  • Creating the Matrix Manually
  • The Matrix with Group Data Model
  • The Matrix with Group Layout
  • Building a Nested Matrix
  • Nested Matrix Paper Layout
  • Types of Triggers in Reports
  • Trigger Code
  • Using Report Triggers
  • Using Data Model Triggers: PL/SQL Group Filter
  • Using Data Model Triggers: Parameter Validation
  • Using Layout Triggers
  • Using Format Triggers
  • Event-Based Reporting
  • Contents of the SRW Package
  • Outputting Messages
  • Executing a Nested Report
  • Restricting Data
  • Initializing Fields
  • Creating a Table of Contents
  • Performing DDL Statements
  • Setting Format Attributes
  • Running Reports Using OracleAS Reports Services
  • Report Request Methods
  • Oracle Application Server Components
  • Enabling Single Sign-On Access
  • Running the Web Layout: JSP Run-time Architecture
  • Running the Paper Layout: Servlet Run-time Architecture
  • Running a Paper Report on the Web
  • Queue Manager
  • Tuning Reports
  • Performance Measurement
  • Non SQL Data Sources
  • Investigating the Data Model
  • Investigating the Paper Layout
  • Running the Report
  • Different Development and Run-Time Environments
  • Developing Reports to Run in Different GUIs