Is PL SQL required?

Question

that everything can be done in PL SQL can also be done by embedding sql statements in a langauage application, PhP reports. Why do people still use PL SQL, are there any important benefits.

I want to avoid learning a new language and see if PHP is enough.

Answer 1

PL / SQL is useful when you have the ability to process large chunks of data on the database side without loading all this data into your application.

Let's say you run complex reports across millions of rows of data. You can simply implement the logic in pl / sql and not load all this data into your application, and then write the results back to the database - saving bandwidth, memory and time.

It is a question of the right tool for the right job.
The developer must decide when is best to use PL / SQL.

Answer 2

In addition to performing bulk operations on the database side, certain IT installations have stringent security measures.

Instead of applications having direct access to tables, they control access through PL / SQL stored procedures. This way, they know exactly how the data is accessed, not the applications supported by the developers, which may be subject to security attacks.

Answer 3

I believe the benefits will include:

Tight database integration - Performance.

Security

Reduced network traffic

Precompiled (and originally compiled) code

Ability to create table triggers

Integration with SQL (less data type conversion, etc.)

In the end, although each approach and language will have advantages and disadvantages. Do not learn PL / SQL simply because you already know that PHP will be a loss to yourself personally and possibly from a career point of view. If you learn PL / SQL, how do you understand where it has advantages over PHP and where PHP has advantages over PL / SQL, but you will be in a better position to make a decision.

Good luck.