PL/SQL ENVIRONMENT SETUP

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 :

https://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html

For ORACLE Enterprise Edition Check this link: https://www.tutorialspoint.com/plsql/plsql_environment_setup.htm

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

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

https://www.apachefriends.org/index.html

You can follow this article for installation process:
https://www.wikihow.com/Install-XAMPP-on-Linux

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.
LINK: https://www.youtube.com/watch?v=R5CUn5wGQGg

Everything is now done.

How to create Database And Table in XAMPP?

For this question, check this link: https://www.youtube.com/watch?v=pmh6aasUulI

How to create database in Mysql using xampp phpMyadmin & console mode both, check this LINK: https://www.youtube.com/watch?v=UWZQJrAtEu4

For date input related queries, Check Link: https://www.youtube.com/watch?v=D8f9IiUXA4E

Text Editor:

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

For Installing Bekeeper Studio, Check this link https://www.beekeeperstudio.io/

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.

MORE PL/SQL QUERIES ARE COMING SOON. SO BOOKMARK THIS WEBSITE.

You might like

Saif

About the Author: Saif

Leave a Reply

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

Close Bitnami banner
Bitnami