Oracle Pl/Sql Course

Central Institute of Information Technology
In Nagpur

Price on request
You can also call the Study Centre
09011... More
Compare this course with other similar courses
See all

Important information

  • Course
  • Nagpur
Description

Important information
Venues

Where and when

Starts Location
On request
Nagpur
Plot No.2, Near RPTS Road, Opp. ICAD, Laxminagar, 440022, Maharashtra, India
See map

Course programme

* Introduction TO PLSQL
* PLSQL block Structure/Architecture
* Data Types
* Declaring Variables(Assignment, Default, Not Null, %Type, %Rowtype, Aggregate, Aliases, Scope)
* Datatype Conversion (Implicit and Explicit)
* Control Structures
* Conditional Control Statements
If ...Then
If ...Then ...Else
If ...Then ...ElsIf
* Iterative Statements
For(...Range...)Loop .. End Loop
While(...condition...)Loop ... End Loop
Loop ... End Loop --Explicite Exit Statement
* Exit Statement
* GoTo Statement
* Null Statement
* Into Statement
* Explicit Cursors
Declare,Open,Fetch,Close,Use with For,While,Loop Iterative Statements,Parameter passing,Attributes(C%Found,C%NotFound,C%RowCounts,C%IsOpen), Value of attributes at different conditions.
* Row Locking : For Update (/NoWait/Of ColumnName) Clause
* Table Locking:Lock Table
* Cursor Variables / Reference Cursor
* Dynamic DDL statement in PLSQL using DBMS_SQL Oracle PAckage.
* Implicit Cursors (Dml/Select Into)
Attributes(SQL%Found, SQL%NotFound, SQL%RowCounts, SQL%IsOpen)
* Exceptions Handling
* Sub-Programs (Procedures and Functions)
* Stored Programs (Procedures and Functions)
* Database Triggers
* Collections
* Records
* Object Types
* Stored Procedures
* Stored Functions
* Packages
* Oracle Supplied Packages
* Manipulating Large Objects
* Creating Database triggers
* Managing Dependencies


Compare this course with other similar courses
See all