PL/SQL ENVIRONMENT SETUP

 

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.

Comments

Post a Comment

Popular posts from this blog

Oracle Live SQL

Image
  In this article, you are going to learn how to use Oracle Live SQL and how to work with Oracle Database without installing the database. Get instant access to the Oracle Database and learn from a collection of community scripts and tutorials. Write your own SQL scripts and easily share them with others. All you need to get started is your Oracle.com account. Following steps helps you to build your knowledge in SQL. Step 1: Start with a basic structure as given in the following below diagram. Fig: Table Step 2: Learn some basic terminologies i.e. Field, Row, And Column (s). So, it helps you to better understanding. Step 3: Break it into some simple steps, i.e. Create a Table, Make some conditions on attributes (integrity constraints), Inserting values, and Make sure all values are inputted in their proper place. Step 4: There are some queries and you should answer those. Step 5: Commit; After Creating and inserting values because sometimes data is not save
Read more

PL/SQL XAMPP EXAMPLE SET 2

  In this , we are going to learn how to use SQL in XAMPP. Here mainly cover CREATE, FOREIGN KEY ADD, ALTER, INSERT, SELECT, AGE RETRIEVE, TIMESTAMPDIFF, DISTINCT, LIKE, CURDATE, COUNT, SUM, MAX, AND, OR, IN, NOT IN, TRUNC, RENAME OPERATION ,UNION, BETWEEN, NESTED QUERIES. All types are discussed in the given below links, you might like, Preparation Related Notes: https://www.shoutcoders.com/sql-preparation-time-note-4/ , https://www.shoutcoders.com/sql-preparation-time-note-3/ , https://www.shoutcoders.com/sql-preparation-time-note-2/ , https://www.shoutcoders.com/sql-preparation-time-note-1/ PL/SQL XAMPP EXAMPLE SET 2: Create the following table (i) Studies ( P_name, S_place, Course, Cost_no ) create table studies ( P_name varchar(20) primary key, Study_place varchar(20), Course varchar(20), Cost_no int(20)); OUTPUT: Table Created (ii) Programmer ( P_name, DOB, DOJ, Gender, Prof1, Prof2, Sal ). Make P_name as foreign key from Studies relation. create
Read more

PL/SQL XAMPP EXAMPLE SET 1

Image
  In this PL/SQL XAMPP EXAMPLE SET 1, You can to learn how to use SQL commands in XAMPP. Here cover DML, Data Insertion, Data Updation, Data Deletion, Data Selection, CREATE, DESCRIBE SCHEMA, INSERT, ADD COLUMN, REMOVE COLUMN, UPDATE, ALTER, PRIMARY KEY, MODIFY, DROP COLUMN, DATATYPE CHANGE, RENAME FIELD, DISTINCT, DELETE RECORD, CLEAR ALL DATA, REMOVE TABLE. There are some preparation notes, links are given below, you might like, Preparation Notes: https://www.shoutcoders.com/sql-preparation-time-note-4/ , https://www.shoutcoders.com/sql-preparation-time-note-3/ , https://www.shoutcoders.com/sql-preparation-time-note-2/ , https://www.shoutcoders.com/sql-preparation-time-note-1/ Oracle Database PL/SQL XAMPP EXAMPLE SET 1 : 1. Create the following table Student {roll, name, address, ph_no, DOB, MA, HS, DOA, Stream, C_num} create table student (Roll int(4), Name varchar(10), Address varchar(20), Ph_num int(10), DOB date, MA int(4), HS int(4), DOA date, Stream var
Read more