@hsujan

Triggers in PL/SQL

Mar 2, 2025 · 11 min read · Triggers are PL/SQL blocks stored in the database that execute automatically before, after, or instead of a specific event. They help in performing actions like validation, logging, and enforcing business rules. Why Do We Use Triggers? To execute pr...

PL/SQL Packages

Feb 27, 2025 · 7 min read · Introduction to Packages A package is a way to group related PL/SQL objects (functions, procedures, types, variables, cursors, exceptions, etc.) together. Helps in organizing objects within a schema, making them easier to find and maintain. Preven...

Function and Stored Procedure in PL/SQL

Feb 22, 2025 · 9 min read · Function A function is a subprogram that returns a single value and can be used in SQL queries or PL/SQL blocks. ✅ Returns a value using the RETURN statement.✅ Can be used in SQL queries.✅ Can accept parameters (optional).✅ Used for calculations and ...

Exceptions in PL/SQL

Feb 20, 2025 · 6 min read · Exceptions are designed to handle runtime errors in PL/SQL. When a PL/SQL block encounters an error during execution, it raises an exception and terminates the process. Exceptions can occur in: Anonymous blocks (causing immediate termination) Sub...

Cursors in PL/SQL

Feb 12, 2025 · 6 min read · A Cursor is a database object that allows row-by-row processing of query results. It acts as a pointer to the result set of a SQL query and is used to retrieve and manipulate data efficiently. Types of Cursors in PL/SQL Implicit Cursor Created auto...