Oracle Pl/Sql Course

Central Institute of Information Technology
In Nagpur

Price on request
You can also call the Study Centre
09011... More
Want to speak to an Advisor about this course?

Important information

Typology Course
Start Nagpur
  • Course
  • Nagpur

Important information

Where and when

Starts Location
On request
Plot No.2, Near RPTS Road, Opp. ICAD, Laxminagar, 440022, Maharashtra, India
See map
Starts On request
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

Achievements for this centre

Students that were interested in this course also looked at...
See all