What is PL SQL? Will anyone please tell?

Question

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

Tripat Bala Singh · Answer

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

Bhavesh Jadav · Answer

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

Shraddha Patel · Answer

- 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.

Vijay Khatri · Answer

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 PL/SQL block PL/SQL Engine Database Server I am mentioning some advantages of PL SQL as follows that suffices the importance and usage of it- You get better performance, as SQL is executed in bulk rather than a single statement It gives High Productivity It has Tight integration with SQL There is a scope of Full Portability It will provide you with Tight Security It supports Object-Oriented Programming concepts.

Raghavendar Swaminathan · Answer

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

What is PL SQL? Will anyone please tell?

Answers (5)