Programming with Oracle PL/SQL Database

30 Sep 2025   08:30 AM CST

  • Free Webinar
  • Live Q&A
  • Free Participation Certificate
  • Learn from Industry Experts

Learn More About This Topic

Webinar Overview
The webinar provided an in-depth introduction to Oracle 19c PL/SQL, highlighting its role in developing efficient and secure database applications. The session began with an overview of PL/SQL basics, including the structure of anonymous blocks, variables, and control statements. Participants explored how to create stored procedures, functions, and packages to organize business logic effectively. A key focus was placed on error handling through exceptions, ensuring reliability in database programs. The workshop also covered advanced features such as cursors, triggers, and collections, enabling developers to handle complex data processing requirements. Security considerations, including privilege management and safe coding practices, were emphasized to protect applications from risks.
Key Points

  • Introduction to PL/SQL as Oracle’s procedural extension to SQL.
  • Writing anonymous blocks, stored procedures, and functions.
  • Use of variables, control structures, and cursors for program logic.
  • Error handling with exceptions for reliable applications.
Meet The Trainer
Naveen Kumar  Rukkanna
Naveen Kumar Rukkanna

An experienced Oracle consultant and corporate trainer with over 10 years in the field, I possess expertise in Oracle Prod/Dev/UAT DBA support, management of database objects, performance tuning, and troubleshooting. I have hands-on skills in Oracle SQL, PL/SQL, and related utilities, complemented by strong communication and analytical abilities.

Register for the Webinar
Registration successful!
Details have been shared over email.
Explore More Webinars
Introduction to AI Agents - A Beginner’s Guide
Show More

Webinar Summary:

The webinar “Introduction to AI Agents: A Beginner’s Guide” offers a foundational understanding of AI agents. It begins by explaining what an AI agent is and its role in generative AI. The session delves into the architecture of AI agents, providing insights into their structure and functionality. Participants will also learn about the significant impact AI agents have on generative AI technologies. The webinar concludes with a practical demo.

30 Sep 2025 | 07:30 AM CST   1 Hour

Relational Data Fundamentals - Understand & Organize Data Effectively
Show More

Webinar Summary:

In this webinar We shall study Structured, semi structured, unstructured data and normalisation, common database objects

30 Sep 2025 | 09:30 AM CST   1 Hour

Migrating Applications and Databases to AWS
Show More

Webinar Summary:

This session provided an overview of how to move applications and databases to the AWS Cloud using a structured, phased approach. It covered tools and services like AWS MGN, DMS, and SCT that simplify and automate migrations. Attendees learned about different types of migrations—homogeneous and heterogeneous—and key strategies to minimize downtime, ensure compatibility, and optimize workloads post-migration for scalability and cost-efficiency.

30 Sep 2025 | 07:00 PM CST   3 Hours

Explore Related Courses

Sales Management in CRM 2016