Overview

PL\SQL or procedural SQL language is a language developed by Oracle corporation to implement little programmability in Oracle :) With PL\SQL you can create:

Packages

Procedures

Functions

Triggers

Which can help you with the administration of the database or help you achieve a specific function. For example, send a mail from the DB when a certain action is performed.

Source

This program, I wrote long time ago and the package how 2 modes:

Unlock

Lock

So Let's check what they do one by one:

Unlock

Unlock user (which isn't being in use)

Send the password to one mail

Send notification to a lot of mails that the user was unlocked

Lock

Lock user (if it isn't used)

Send notification to a lot of mails that the user was locked

Program which sends mail when you want to unlock other user

The usage of that package is very simple:

Usage

Usage of the Package