• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Tim Cooke
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Liutauras Vilda
Sheriffs:
  • Rob Spoor
  • Junilu Lacar
  • paul wheaton
Saloon Keepers:
  • Stephan van Hulst
  • Tim Moores
  • Tim Holloway
  • Carey Brown
  • Scott Selikoff
Bartenders:
  • Piet Souris
  • Jj Roberts
  • fred rosenberger

PL/SQL Online Training

 
Ranch Hand
Posts: 31
Oracle
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
PL/SQL Online Training (One to One Online Training)

Duration : 6 Sessions

For Course Fee, Demo and Time Slots, Contact at training@oracleappstechnical.com | sridevikoduru@oracleappstechnical.com | +91 – 9581017828 | http://www.oracleappstechnical.com

PL/SQL Course Contents

Introduction to PL/SQL

Advantages of PL/SQL
The PL/SQL Block
Basic PL/SQL Block Structure
The Declaration Section
The Execution Section
The Exception Section
Generation Output

Variables And Constants

Data types
Scalar Data types
Composite Data types
Variables (%type, %rowtype)
Variable Assignment
Scope of Variables
Constants
Writing Sample programs demonstrating all above Functionalities

Conditions and Loops

Conditional Control
Iterative Control
Guidelines
Sample, While, and For Loops
While Loop
For Loop

Cursors

Implicit and Explicit Cursors
Cursors Actions
Declaring a Cursors
Opening a Cursors
Fetching Data from ad Cursor
Closing a Cursor
Cursor Attributes
Cursors and Loops
Cursors For Loops

Exception Handling

Guidelines
Types of Exceptions
Named System Exceptions
Named User-Defined Exceptions
Unnamed System Exceptions
Unnamed User-Defined Exceptions
SQL ERRM and SQL Code

Procedures

Writing Procedures using Oracle SQL,PLSQL
Types of Program Units
Named and Unnamed Block Structures
Diff between Anonymous Blocks and named Blocks
Procedures Parameters
Parameter Modes
IN
Out
IN Out
Testing Procedure from anonymous blocks
Calling procedure from another procedure
User Defined Functions

Using Functions within Oracle

Difference ways of Callings a function
Named Notation
Functions
Function Parameters
Referencing a Function

Packages

Defining and Using Packages
Advantages of Using Packages
Overloading
Dependency
Abstraction – Information Hiding
Inheritance
Defining Global Variables

Database Triggers

Trigger Types
Trigger Events
Trigger Restrictions
Trigger Body
Complication of Database Triggers
Trigger Syntax
Usage of Instead of Triggers

An Overview of Oracle Large Objects

BLOB
CLOB
PL/SQL Table
VARRAY
BFILE
Nested Tables

FAQ’S in PL/SQL

About Training

I am Sridevi Koduru, Senior Oracle Apps Trainer at Oracleappstechnical.com  With 10 Yrs Exp on Oracle Apps and 14 Yrs IT Exp Providing Online Training on Oracle Apps Technical, Oracle Apps Financial Functional, Oracle Apps SCM, OAF, SQL, PL/SQL and D2K. I have Provided Training for 1000+ Professionals Most of them are Working in Real Time now.

Contact for (One to One Personal Online Training) on Oracle Apps Technical, Oracle Apps Financial Functional, Oracle Apps SCM, OAF, SQL, PL/SQL and D2K at training@oracleappstechnical.com   | sridevikoduru@oracleappstechnical.com | +91 – 9581017828 | http://www.oracleappstechnical.com

LinkedIn profile - https://in.linkedin.com/in/sridevi-koduru-9b876a8b

We are Specialized Online Trainers on Oracle Apps Technical, Oracle Financial Functional, Oracle Apps SCM.
 
pie. tiny ad:
Building a Better World in your Backyard by Paul Wheaton and Shawn Klassen-Koop
https://coderanch.com/wiki/718759/books/Building-World-Backyard-Paul-Wheaton
reply
    Bookmark Topic Watch Topic
  • New Topic