Oracle PL SQL |100% real time online training , job support from usa | - New York, NY

Saturday, 5 October 2019

Item details

City: New York
Salary: $250


Contact name sri raja
Phone 8500122107

Item description

FOR FREE DEMO contact :

Email :

Phone/WhatsApp : +91-(850) 012-2107

USA Number : 214-628-3894

Gtalk :


Oracle PL SQL Interview Questions and Answers, Recorded Video Sessions, Materials, Mock Interviews Assignments Will be provided

the course content can be modified as per your requirements):

Introduction to PL/SQL

Advantages of PL/SQL

PL/SQL architecture

Datatypes in PL/SQL

PL/SQL program structure

Simple PL/SQL programs

Embedding SQL statements in PL/SQL

Conditional statements


Cursors :

About cursors in PL/SQL

Explicit cursors

For loop cursor

Cursor paramenters

For update clause

Where current of clause

Ref cursors

Implicit cursors

Exception Handling :

System defined exceptions

User defined exceptions

Sqlcode & sqlerrm

Pragma exception_init

Subprograms :

Introduction to subprograms

Difference between anonymous & named blocks

Stored procedures :-

Creatng procedures

Working with IN , OUT , INOUT parameters

Procedures with cursors

Procedures returning records

Pragma autotnomous transaction

Functions :

Difference b/w procedures and functions

Inline functions

Packages :

Introduction to packages

Package specification and package body

Overloading package members

Triggers :

Introduction to triggers

DML triggers

DDL triggers

Db auditing using triggers

DB level triggers

Collections in PL/SQL

Built-in packages in PL/SQL

Oracle 10g features

Oracle 11g features

DBA concepts

Copyright © 2018 Apex Online IT Trainings Inc. All Rights Reserved

Call us on : USA - +1 214 628 3894 | IND - +91 8500122107

for your course please follow the link :