6 Likes Comment

PL/SQL is not a standalone programming language; it is a tool within the Oracle programming environment. PL/SQL is an interactive tool that allows you to type SQL and PL/SQL statements at the command prompt. These commands are then sent to the database for processing. Once the statements are processed, the results are sent back and displayed on screen.

You can install Oracle database software to run PL-SQL commands. You can download from the following link :

For ORACLE Enterprise Edition Check this link:

Or, Go to Google, Type “live sql”, then enter oracle Live Sql.

Or, You can download XAMPP, or WAMPP server from the following link:

You can follow this article for installation process:

After Downloading it, simply run it through Web Browser (localhost/myphpadmin).
Or, You can download “BeekeeperStudio”.

After installation of Xampp in linux destribution,
You can check this video, if any kind of error occurs.

Everything is now done.

How to create Database And Table in XAMPP?

For this question, check this link:

How to create database in Mysql using xampp phpMyadmin & console mode both, check this LINK:

For date input related queries, Check Link:

Text Editor:

To save and run code you can use notepad, sublime text, or “BeekeeperStudio”(XAMPP).

For Installing Bekeeper Studio, Check this link

PL/SQL allows sending an entire block of statements to the database at one time. This reduces network traffic and provides high performance for the applications.

PL/SQL gives high productivity to programmers as it can query, transform, and update data in a database.

PL/SQL saves time on design and debugging by strong features, such as exception handling, encapsulation, data hiding, and object-oriented data types.

Applications written in PL/SQL are fully portable.

PL/SQL provides high security level.

PL/SQL provides access to predefined SQL packages.

PL/SQL provides support for Object-Oriented Programming.

PL/SQL provides support for developing Web Applications and Server Pages.


You might like


About the Author: Saif

Leave a Reply

Your email address will not be published. Required fields are marked *

Close Bitnami banner