Oracle PL SQL

PL/SQL is Oracle’s procedural extension to industry-standard SQL. PL/SQL naturally, efficiently, and safely extends SQL. Its primary strength is in providing a server-side, stored procedural language that is easy-to-use, seamless with SQL, robust, portable, and secure.

Course Structure

• PL/SQL Advantages
• PL/SQL Block Structure
• PL/SQL Data Types
• PL/SQL Variable & Scope
• PL/SQL Constant Declaration
• PL/SQL server output ON
• PL/SQL Comment
• PL/SQL Conditional Control
• PL/SQL Loop Statement
• PL/SQL Sequential Control
• PL/SQL Case Statement
• PL/SQL Cursors
• Implicit Cursors
• Explicit Cursors
• For Loop Cursors Parameterized Cursors
• PL/SQL Transaction
• PL/SQL Exceptions
• User Defined Exception
• User Named Exception
• PL/SQL Procedures
• Procedure Syntax
• Procedure Example
• Procedure Drop
• PL/SQL Functions
• Function Syntax
• Function Example
• Function Drop
• PL/SQL Packages
• Packages Advantages
• Packages Syntax
• Packages Example
• Packages Alter
• Packages Drop
• PL/SQL Triggers
• Triggers Type
• Triggers Syntax
• Triggers Examples

We at Rolla Academy want to empower the students. This will eventually make them great assets for the organization they are working in or the ones they aim to work in the future. Our courses are student centric and so are our timings. We understand that the professionals have a busy schedule and thus we alter us according to them. Students are free to choose the timings for their classes. To attend the classes at your convenience, book your batch now.