FOR FREE DEMO contact :
India(M): +91-8500-122-107 ,(whats app)
Land line +919988663117
Gtalk: raavi.sriraja@gmail.com
Email: raj@apexonlinetraining.com
WebSite:www.apexonlinetraining.com
Oracle PL SQL Interview Questions and Answers, Recorded Video Sessions, Materials, Mock Interviews Assignments Will be provided
ORACLE PL SQL COURSE SYLLABUS
(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
Loops
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
No comments:
Post a Comment