(+91) 900 7199 222 | (+91) 33 4060 2305
info@siliconcoder.com
SiliconCoder
Menu

PL/SQL

Course Content

  • Introduction:-What Is PL/SQL?, Architecture, SQL Vs. PL/SQL Vs T-SQL: Key Differences, Advantages of PL/SQL, Environment Setup.
  • Basic Syntax:-Declarations, Executable Commands, Exception Handling, Identifiers, Delimiters, Comments, Program Units.
  • Data Types:-Scalar(Numeric, Character, Boolean, Datetime), Large Object(BFILE, BLOB, CLOB, NCLOB), Composite, Reference, User-Defined Subtypes, NULLs.
  • Variables:-Declaration Of Varriable, Initializing Variables, Variable Scope, Assigning SQL Query Results to PL/SQL Variables.
  • Constants and Literals:-Declaring a Constant, PL/SQL Literals.
  • Operators:-Arithmetic, Relational, Comparison, Logical, String, Operator Precedence.
  • Conditions:-IF-THEN, IF-THEN-ELSE, IF-THEN-ELSIF, Case statement, Searched CASE statement, nested IF-THEN-ELSE.
  • Loops:-Basic LOOP, WHILE LOOP, FOR LOOP, Nested loops, Labeling a PL/SQL Loop, Control Statements.
  • Strings:-Fixed-length strings, Variable-length strings , CLOBs, Declaring String Variables, String Functions and Operators.
  • Arrays:-Varray, How To Create And Use? .
  • Procedures:-subprogram, calling program, Creating Functions And Procedures, Parts of a PL/SQL Subprogram, Parameter Modes in PL/SQL Subprograms, Methods for Passing Parameters.
  • Functions:-Creating a Function?, Calling a Function, Recursive Functions.
  • Cursor:- Implicit Cursors, Explicit Cursors, Declaring the Cursor, Opening the Cursor, Fetching the Cursor, Closing the Cursor
  • Records:-Table-Based Records, Cursor-Based Records, User-Defined Records.
  • Packages:-Specification, Package Body, Package Elements.
  • Collections :-Index-By Table, Nested Tables, Methods, Collection Exceptions.
  • Transactions :-What Is transaction?, Starting and Ending a Transaction, Commit, ROLLBACK, Savepoints, Automatic Transaction Control.
  • DBMS Output :-What Is DBMS Output?, Use Of DBMS Output, Subprograms.
  • Object Oriented PL/SQL:-Instantiating an Object, Member Methods, Map method, Order method, Inheritance, Abstract Objects.
  • Exceptions:-Syntax for Exception Handling, Raising Exceptions, User-defined Exceptions, Pre-defined Exceptions.
  • Triggers:- What is a Trigger?, Syntax of Triggers, Types of PL/SQL Triggers, Trigger Execution Hierarchy, Information about Triggers, CYCLIC CASCADING in a TRIGGER.