What is PL SQL? Will anyone please tell?

hari narayanan

8y947SQL

I need to understand PL SQL as I am a Beginner.

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Vijay Khatri6y ago
PL SQL is an extension of SQL (Structured Query Language) that is used in Oracle by developers. It is used in combining the manipulated data with SQL with the ongoing power of procedural language that helps in the creation of super SQL queries.
The PL SQL consists of mainly three factors/ components
1. PL/SQL block
2. PL/SQL Engine
3. Database Server
I am mentioning some advantages of PL SQL as follows that suffices the importance and usage of it-
1. You get better performance, as SQL is executed in bulk rather than a single statement
2. It gives High Productivity
3. It has Tight integration with SQL
4. There is a scope of Full Portability
5. It will provide you with Tight Security
6. It supports Object-Oriented Programming concepts.
0
Shraddha Patel6y ago
- PL/SQL is a combination of SQL along with the procedural features of programming languages. It was developed by Oracle Corporation in the early 90's to enhance the capabilities of SQL. PL/SQL is one of three key programming languages embedded in the Oracle Database, along with SQL itself and Java. This tutorial will give you great understanding on PL/SQL to proceed with Oracle database and other advanced RDBMS concepts.

- This tutorial is designed for Software Professionals, who are willing to learn PL/SQL Programming Language in simple and easy steps. This tutorial will give you great understanding on PL/SQL Programming concepts, and after completing this tutorial, you will be at an intermediate level of expertise from where you can take yourself to a higher level of expertise.
+1
Tripat Bala Singh8y ago
PL/SQL is a block structured language. The programs of PL/SQL are logical blocks that can contain any number of nested sub-blocks. Pl/SQL stands for "Procedural Language extension of SQL" that is used in Oracle. PL/SQL is integrated with Oracle database

Hello hari go with following link it shuld help you...

https://www.javatpoint.com/what-is-pl-sql
+2
Raghavendar Swaminathan8y ago
Hi Hari,

PFB Links.

Oracle PL/SQL :
https://www.guru99.com/pl-sql-tutorials.html
PL/SQL
http://plsql-tutorial.com/
https://www.tutorialspoint.com/plsql/index.htm
https://www.javatpoint.com/pl-sql-tutorial
Thanks
Raghav
0
Bhavesh Jadav8y ago
Hello Hari,
- I give you some reference links to understand PL SQL
- https://www.developer.com/tech/article.php/777761/day-1-learning-the-basics-of-plsql.htm
- https://www.udemy.com/plsql-by-example/
- https://www.youtube.com/watch?v=l3cG1pCglUE
It should help you.

Thanks
+1