Hi Everyone, Today's topic is Packages.
In PL/SQL, a package is a schema object that contains definitions for a group of related functionalities.
A package includes variables, constants, cursors, exceptions, procedures, functions, and subprograms.
It is compiled and stored in the Oracle Database.
Typically, a package has
1. a specification
Hi Everyone, Today's topic is Triggers.
In Oracle, you can define procedures that are implicitly executed when an INSERT, UPDATE or DELETE statement is issued against the associated table. These procedures are called database triggers.
A trigger is a named PL/SQL block stored in the Oracle Database and executed automatically when a triggering event takes place.
Uses Of Triggers:
Enforcing complex business rules that cannot be established using integrity constraint such as UNIQUE, NOT NULL, and CHECK.
Preventing invalid transactions.
Hi Everyone, Today's topic is Cursors
When word "Cursor" occurs, It means there is a Pointer which point out something.
When an SQL statement is processed, Oracle creates a memory area known as context area.
A cursor is a pointer to this context area.
It contains all information needed for processing the statement.
Hi Everyone, Today's topic is Procedure & Functions
The PL/SQL stored procedure or simply a procedure is a PL/SQL block which performs one or more specific tasks. It is just like procedures in other programming languages.
A PL/SQL procedure is a reusable unit that encapsulates specific business logic of the application.
Creating Procedure:
Syntax:
