What is PL/SQL and Why to Use?

Oracle Master Training • 80,000+ Students Worldwide
A free video tutorial from Oracle Master Training • 80,000+ Students Worldwide
Oracle Architect & Best Selling Instructor
4.5 instructor rating • 7 courses • 91,293 students

Lecture description

This lesson explains you about what is PL/SQL and Why you should choose PL/SQL as a Programming Language.

Learn more from the full course

The Complete PL/SQL Bootcamp : "Beginner to Advanced PL/SQL"

A Full-Real Guide to Make You a Job-Ready PL/SQL Developer &Also covers "Oracle 1Z0-144 and 1Z0-149" PL SQL Exam Topics!

23:51:04 of on-demand video • Updated February 2021

  • Pass the Oracle 1Z0-149 : Program with PL/SQL Certification Exam - on your first try!
  • Pass the Oracle 1Z0-148 : Advanced PL/SQL Certification Exam - on your first try!
  • Anything You Need for Coding PL/SQL From Beginner Level to Advanced Level
  • Every Subject is Explained from the Easiest to the Most Advanced.
  • Real-World Examples for Every Section
  • Some Advanced SQL Techniques
  • Use SQL Developer Efficiently for PL/SQL
  • Learn PL/SQL Architecture Very Well
  • Improve Performance of SQL& PL/SQL Codes
  • Create Your Dynamic SQL & PL/SQL Queries
  • Learn PL/SQL Object Oriented Programming
  • Learn PL/SQL Tuning for Performance
  • Learn & Master PL/SQL by Coding with Hundreds of Practical Examples!
  • Become a Job-Ready Oracle PL/SQL Developer Certified Professional!
English [Intro] Hi. Before you start your PL/SQL lessons, first, You need to know what is PL/SQL? But first of all, let me talk about the name. Some people say it with PL sequel and some call it with pl esql. It depends on how you call it easier. I will call SQL and PL/SQL for these two names in my courses. OK. As we know from SQL, we go and get some data from the database. In SQL, we have some capabilities like choosing which type of data to get, how many records to get or get with different names maybe even some calculations. Of course we can do many things more, like DML, DDL Operations, Privileges, Constraints etc. But, is this enough for us? Absolutely not! With SQL We only can get data from the database or change it. After we got our data, can we do anything else? No.. We can just show it. But most of the times, we need to do some extra operations on this data. For example, we need to change it. We need to trace it. We need to add it into a file, mail it, and many things like that. Right at that time, PL/SQL comes for our help. Let’s open up the PL/SQL then.. As we can understand from the name, PLSQL is a procedural programming language which extends SQL capabilities. That means, PL/SQL is SQL + procedural programming. With PL/SQL you can have variables, control structures. which means if structure, loops, triggers, I/O operations, and many things that you can think from a programming language. which means if structure, loops, triggers, I/O operations, and many things that you can think from a programming language. But one thing is, PL/SQL is not an object oriented programming. It is a procedural programming type You can use it like an object oriented programming, but at the end, it is not. You can check the differences from the net if you wish. But you can do anything you need with PL/SQL, and you will learn how to use them in this course, deeply, with all the details. How will you have PL/SQL? PL/SQL is created in early 90’s by oracle, and it has been developing by Oracle since then. The good part is, when you installed Oracle database, that means you have a working PL/SQL engine, too. That means, if you are using Oracle SQL in your computer, you can now go on writing your PL/SQL codes You can use PL/SQL in many operating systems. We can think of it as platform independence. Actually since PL/SQL works on your database, you do not care on which platform it works in. You can connect to a linux based database with Windows, or vice versa. It is the same as SQL. Wherever you can use SQL, you can use PL/SQL, too.. So, the main question is, why PL/SQL? Why not the others? For example, why should I use PL/SQL instead of JAVA, .NET etc for example? I am sorry to say that, but you need to know that, PL/SQL is not a display language. That means, you can not create visual things with PL/SQL. It is developed for business operations or handling some complicated logic with strong logic control statements. It is developed for business operations or handling some complicated logic with strong logic control statements. Besides, you can do some after sql statements like logs, controls like constraints, some security things, and re-usability with the stored procedures. Why not the others? Actually, on the visual parts, you need to use other programming languages. Oracle also has some tools or languages for creating visual screens or reports etc. You know the others, already. Can you do these logics with JAVA for example, or .net? Yes, most probably you can do the same things with another language. So why you should choose PL/SQL then? Since PL/SQL works in database, It will be much faster than the other languages in its area. Besides, the other languages are not created for just data. But PL/SQL is created for only data manipulation, and for only Oracle database, and by Oracle itself. This makes PL/SQL really strong than others on its own area. And there are some built-in functions that you can not find in other programming languages. These functions are really, really helpful on your business. Also, since it works in the same database engine, there is so less network loss then the others. This also increases performance. Besides, there are its own methods to increase performance like bulk insert etc. To sum up, like all the programming languages, PL/SQL has also pros and cons for all programming languages to the others. If you need to manipulate some data, use PL/SQL as much as you can. If you are using Oracle SQL in any programming language, any tool or simply any environment, knowledge of PL/SQL will give you a huge advantage against those who doesn’t know it. PL/SQL will provide you the power to make your applications more efficient, more robust and more secure.. PL/SQL will provide you the power to make your applications more efficient, more robust and more secure.. So, I think this is enough to say why to choose PL/SQL programming language. Actually, most of you will need to use because your company wants you to know that. But for the people who says why to choose, I can say that, If you are using Oracle SQL already, and if you know PL/SQL too, you will be better than your friends in your job, and you will be paid more. So this is the end of this lesson. See you in the next lessons.