Difference between SQL and PL SQL

+1 vote
Hi!!

Can someone tell me the difference between  SQL and PL/SQL?
Oct 15, 2018 in Database by Sahiti
• 6,380 points
510 views

3 answers to this question.

0 votes

SQL is a query language that allows you to issue a single query or execute a single insert/update/delete whereas PL/SQL is Oracle’s “Procedural Language” SQL, which allows you to write a full program (loops, variables, etc.) to accomplish multiple operations such as selects/inserts/updates/deletes.

answered Oct 15, 2018 by DataKing99
• 8,240 points
+1 vote
In Oracle database administration, there are two languages namely SQL and PL SQL. these two languages perform database related queries.

SQL is a structured query language that performs single operations.

Whereas PL SQL is the advanced version of SQL language. Here we can perform several crude operations at a time. So hence it requires some programming.

This is the main difference SQL and PL SQL in Oracle DBA
answered Sep 25, 2019 by gautham
0 votes

We can differentiate these on basis of following key points:

Full Form

SQL stands for Structured Query Language whereas PL/SQL stands for Programmable Structured Query Language.

Basic Usage

In SQL, we can execute single command or query at a time. The query can be and DDL (Data Definition Language) or DML (Data manipulation language). DDL is used to add, remove or modify tables(db objects). DML is used to Insert, update or delete data from tables.

On the other hand, PL/SQL is bloc of commands or code which helps us to accomplish multiple task at a time. It can consist of several SQL queries, loops, functions. So many tasks are performed at a time here.

I found useful resource at- Difference Between sql and plsql: Insight with Example Query

answered Nov 28, 2020 by Raushan Kumar

Related Questions In Database

0 votes
1 answer

Difference between clustered and non clustered index in SQL

The differences between the clustered and non ...READ MORE

answered Sep 28, 2018 in Database by Sahiti
• 6,380 points
547 views
+1 vote
1 answer

Difference between cross join and natural join

The cross join produces the cross product ...READ MORE

answered Oct 12, 2018 in Database by DataKing99
• 8,240 points
9,168 views
0 votes
1 answer

Can you please explain the difference between inner join and outer join in database?

Hi Suraj, You have a doubt regarding inner join ...READ MORE

answered May 28, 2019 in Database by sampriti
• 1,100 points
306 views
0 votes
1 answer

Can you explain what is the difference between UNION and Join?

Hi Sahana,  I got your doubt, Checkout these ...READ MORE

answered May 30, 2019 in Database by sampriti
• 1,100 points
488 views
0 votes
2 answers

Difference between primary key a composite key

candidate  key: It is the collection of ...READ MORE

answered Oct 14, 2020 in Database by anonymous
14,766 views
0 votes
1 answer

Difference between Inner Join & Outer Join

The difference is as follows: INNER JOIN: Returns all those ...READ MORE

answered Sep 7, 2018 in Database by DataKing99
• 8,240 points
422 views
0 votes
1 answer

How to connect Java program to the MySQL database?

You can connect your Java code with ...READ MORE

answered May 11, 2018 in Java by Parth
• 4,630 points
616 views
0 votes
1 answer

Is SELECT * harmful in Database?

There are really three major reasons: Inefficiency in ...READ MORE

answered Sep 7, 2018 in Database by DataKing99
• 8,240 points
211 views
0 votes
1 answer

Difference between single and double quotes in SQL

Single quotes are used to indicate the ...READ MORE

answered Sep 11, 2018 in Database by CodingByHeart77
• 3,720 points
6,583 views
0 votes
1 answer

Can different databases use different name quotes?

This use of quotes is called delimited ...READ MORE

answered Sep 11, 2018 in Database by CodingByHeart77
• 3,720 points
135 views