Best PL/SQL Training in Bangalore
Learn Oracle PL/SQL Course from Expert Trainers at RIA Institute of Technology
Â
Oracle PL/SQL Course Fee & Duration
Oracle PL/SQL Course
-
Course Duration : 2 Months
-
Training Hours : 50 Hours
-
Type : Online & Classroom
Oracle PL/SQL Course Syllabus
- Oracle PL/SQL Course Content
COURSE CONTENT/SYLLABUS FOR ORACLE PL/SQL COURSE : Duration- 50 Hours
PL/SQL Course Content - Part 1
1. PL/SQL BasicsÂ
- PL/SQL BlockÂ
- Anonymous Block StructureÂ
- Named Block StructureÂ
- Executing BlocksÂ
- Calling PL/SQL FunctionsÂ
- Executing PL/SQL Blocks and FunctionsÂ
2. Declaring VariablesÂ
- Variable Data TypesÂ
- Variable NamingÂ
- Variable AssignmentÂ
- Complex Variable TypesÂ
3. Within the BlockÂ
- Conditional ProcessingÂ
- The IF StatementÂ
- The CASE StatementÂ
- Iterative ProcessingÂ
- The LOOP StatementÂ
- The WHILE StatementÂ
- The FOR StatementÂ
4. Handling ExceptionsÂ
- Overview of ExceptionsÂ
- Causing System Generated ExceptionsÂ
- Handling System Generated ExceptionsÂ
- Identifying System Generated ExceptionsÂ
- OTHERS Exception HandlerÂ
- User Defined ExceptionsÂ
5. Use of SQL in PL/SQLÂ
- Implicit CursorsÂ
- %TYPE and %ROWTYPE AttributesÂ
- EXECUTE IMMEDIATE statementÂ
- Cursors AttributesÂ
- Implicit CursorÂ
- Explicit CursorsÂ
- Explicit CursorÂ
- Cursor FOR loopÂ
6. Nested BlocksÂ
- Nesting BlocksÂ
- Scope of VariablesÂ
- Scope of ExceptionsÂ
- Nested SubprogramsÂ
- Exception Propagation in Nested BlocksÂ
- Block Variable VisibilityÂ
7. Introducing SubprogramsÂ
- Anonymous blocksÂ
- Types of SubprogramsÂ
- Finding Subprograms in the Oracle Data DictionaryÂ
- Object DependenciesÂ
- Subprogram information in the Oracle Data DictionaryÂ
8. Stored Procedures and FunctionsÂ
- Creating SubprogramsÂ
- Modifying SubprogramsÂ
- Removing SubprogramsÂ
- Application MaintenanceÂ
- Exercise TitleÂ
- ParametersÂ
- Cursors as ParametersÂ
- Subprogram Development TechniquesÂ
- Addressing Compilation ErrorsÂ
- PL/SQL Subprograms with ParametersÂ
9. PackagesÂ
- Structure of PackagesÂ
- Purpose of PackagesÂ
- Wrap UtilityÂ
- Positional vs Named Parameter NotationÂ
- Subprograms Omitted from SpecificationsÂ
- Using PL/SQL PackagesÂ
10. Database TriggersÂ
- Purpose of TriggersÂ
- Invocation of TriggersÂ
- Coding TriggersÂ
- Validation TriggerÂ
- Modifying TriggersÂ
- Viewing TriggersÂ
- Enabling/Disabling TriggersÂ
- Trigger ErrorsÂ
11. Data Retrieval TechniquesÂ
- Cursor ReviewÂ
- Cursor ParametersÂ
- Cursor VariablesÂ
- Dynamic SQLÂ
12. Using Oracle Supplied PackagesÂ
- Oracle Supplied PackagesÂ
- Identifying Available PackagesÂ
- Identifying Package SubprogramsÂ
- Selected Oracle Supplied Package DemosÂ
- Packages related to Input/OutputÂ
PL/SQL - Part 2 - Advanced
1. Arrays and Bulk Binds
- Populating Collections Using Bulk Operations
- Bulk collect
- Bulk Collect from an Explicit Cursor
- Chunking Bulk Collections Using the LIMIT Clause
- Manually Limiting Bulk Collection Volumes
- Bulk Collection of DML Results
- FORALL
- Bulk INSERT Operations
- Bulk UPDATE Operations
- Bulk DELETE Operations
- Sparse Collections
- Host Arrays in Bulk Operations
- BULK_ROWCOUNT
- Handling Exceptions in Bulk Operations
- Unhandled Exceptions
- Handled Exceptions
- Bulk Operations that Complete
- Dynamic SQL and Bulk Operations
2. Table Functions and Pipelining
- Introduction
- Pipelining Table Functions
- Parallel Enabled Table Functions
- Creating Transformation Pipelines
- Deterministic
- Miscellaneous Information
Book a Free Demo Today!

Frequently Asked Questions
Call our Helpline now: +91 80506 01060 Â and know the exciting offers available for you!
RIA Institute of Technology offers 63+ IT & Non IT training courses in marathahalli, Bangalore with 10+ years of Experienced Expert level Trainers.
- Fully hands-on training
- 30+ hours course duration
- Industry expert faculties
- Completed 1500+ batches
- 100% job oriented training
- Certification guidance
- Own course materials
- Resume editing
- Interview preparation
- Affordable fees structure
- All Our trainers are more than 10+ years of experience in course relavent technologies.
- Trainers are expert level and fully up-to-date in the subjects they teach because they continue to spend time working on real-world industry applications.
- Trainers have experienced on multiple real-time projects in their industries.
- Are working professionals working in multinational companies such as Oracle, TCS, HCL Technologies, ZOHO, Birlasoft, IBM, Microsoft, HP, Scope, Philips Technologies, etc…
- Trained more than 2000+ students in a year.
- Strong theoretical & practical knowledge.
- Are certified professionals with high grade.
- Are well connected with hiring HRs in multinational companies.
No worries. RIA institute of Technology assures that no one misses single lectures topics. We will reschedule the classes as per your convenience within the stipulated course duration with all such possibilities. If required you can even attend that topic with any other batches.
RIA Institute of Technology provides many suitable modes of training to the students like
- Classroom training
- One to One training
- Fast track training
- Live Instructor LED Online training
- Customized training
You will receive globally recognized course completion certificate issued from RIA Institute of Technology.
We accept all major kinds of payment options. Cash, Card (Master, Visa, and Maestro, etc), Net Banking and etc.
Please Contact our course advisor/consultant on +91 8050601060. Or you can share your queries through info@riainstitute.in
Trusted By 25,000+ Ambitious Students Who Dream To Achieve Their Goals












Achieve Your Goals With Our Classroom & Online Courses
Get unlimited access to online & offline courses, learn any skill and gain knowledge from expert real-time trainers, achieve highly recognized certificates, get in touch with leading companies – kickstart your career!
