Difference between SQL and PL SQL

+2 votes
Hi!!

Can someone tell me the difference between  SQL and PL/SQL?
Oct 15, 2018 in Database by Sahiti
• 6,370 points
1,531 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,250 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

If you need to know more about SQL, it is recommended to go for the SQL Course today.

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.

 

answered Nov 28, 2020 by Raushan Kumar

Related Questions In Database

0 votes
1 answer

What is the difference between SQL, PL-SQL and T-SQL?

SQL SQL is the standard language for relational ...READ MORE

answered Feb 16, 2022 in Database by Vaani
• 7,070 points
890 views
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,370 points
1,826 views
0 votes
1 answer

What is the difference between HAVING and WHERE in SQL?

HAVING: It is used to check after the aggregation ...READ MORE

answered Feb 17, 2022 in Database by Vaani
• 7,070 points
776 views
0 votes
0 answers

What's the difference between a temp table and table variable in SQL Server?

We can build temp tables in SQL ...READ MORE

Feb 25, 2022 in Database by Vaani
• 7,070 points
625 views
0 votes
0 answers

What is the difference between drop table and delete table in SQL Server?

What is the distinction between the following ...READ MORE

Aug 9, 2022 in Database by Kithuzzz
• 38,000 points
817 views
0 votes
0 answers

What's the difference between TRUNCATE and DELETE in SQL

What distinguishes SQL's TRUNCATE and DELETE operations? Please ...READ MORE

Aug 11, 2022 in Database by Kithuzzz
• 38,000 points
502 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,640 points
1,913 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,250 points
867 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,750 points
29,598 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,750 points
650 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP