PL/SQL nedir? Açılımı ve açılımı nedir? Archidoku Açıklaması
Fiona Brown
⚡ Akıllı Özet
PL/SQL Oracle’s procedural extension to SQL that combines the data manipulation power of SQL with loops, conditions, and object-oriented features. It runs through a three-part architecture of PL/SQL block, PL/SQL engine, and database server for high-performance processing.
PL/SQL nedir?
Oracle PL / SQL is an extension of the SQL language that combines the data manipulation power of SQL with the processing power of a procedural language to create powerful SQL queries. PL/SQL ensures seamless processing of SQL statements by enhancing the security, portability, and robustness of the database.
PL/SQL means instructing the compiler “what to do” through SQL and “how to do” through its procedural way. Similar to other database languages, it gives more control to programmers through the use of loops, conditions, and object-oriented concepts. The PL/SQL full form is “Procedural Language extensions to SQL”.
PL/SQL Tam Form
PL/SQL, “Yapılandırılmış Sorgu Dilinin Prosedürel Dil uzantıları” anlamına gelir. PL/SQL Oracle Şirketin prosedür uzatması SQL ve Oracle ilişkisel veritabanı. Yüksek performanslı, son derece entegre bir veritabanı dilidir.
What is a PL/SQL Developer?
PL / SQL Geliştirici is an Integrated Development Environment used to develop software in the Oracle database environment and perform various database tasks with ease. The PL/SQL Developer IDE provides a GUI and plugins that help end users save time on their database tasks.
ArchiPL/SQL'in yapısı
The example below is a pictorial representation of the PL/SQL architecture.
The PL/SQL architecture mainly consists of the following three components:
- PL/SQL Bloğu
- PL/SQL Motoru
- Veritabanı sunucusu
PL/SQL Bloğu
- This is the component that has the actual PL/SQL code.
- It consists of different sections that divide the code logically: a declarative section for declarations, an execution section for processing statements, and an exception-handling section for handling errors.
- It also contains the SQL instructions used to interact with the database server.
- All PL/SQL units are treated as PL/SQL blokları, and this is the starting stage of the architecture, which serves as the primary input.
The different types of PL/SQL units are:
- Anonim Blok
- İşlev
- Kütüphane
- Prosedür
- Paket Gövdesi
- Paket özellikleri
- Tetik
- Menşei
- Tip Gövde
PL/SQL Motoru
- The PL/SQL engine is the component where the actual processing of the code takes place.
- It separates the PL/SQL units and the SQL part in the input.
- The separated PL/SQL units are handled by the PL/SQL engine itself.
- The SQL part is sent to the database server, where the actual interaction with the database takes place.
- It can be installed in both the database server and the application server.
Veritabanı sunucusu
- This is the most important component of the PL/SQL unit, which stores the data.
- The PL/SQL engine uses the SQL from the PL/SQL units to interact with the database server.
- It consists of an SQL executor that parses the input SQL statements and executes them.
Features and Advantages of PL/SQL
- Better performance, as SQL is executed in bulk rather than one statement at a time.
- Yüksek verimlilik.
- Tight integration with SQL.
- Full portability.
- Tight security.
- Supports object-oriented programming concepts.
- Scalability and manageability.
- Supports web application development.
- Supports server page development.
PL/SQL'in dezavantajları
- Stored procedures in PL/SQL use high memory.
- It lacks functionality for debugging stored procedures.
- Any change in the underlying database requires a change in the presentation layer as well.
- It does not completely separate the roles of back-end and front-end developers.
- It is difficult to separate HTML development from PL/SQL development.
Difference Between SQL and PL/SQL
İşte aralarındaki bazı önemli farklar: SQL ve PL/SQL:
| SQL | PL / SQL |
|---|---|
| SQL is a single query used to perform DML and DDL operations. | PL/SQL is a block of code used to write entire program blocks, procedures, functions, and so on. |
| It is declarative, defining what needs to be done rather than how. | It is procedural, defining how things need to be done. |
| Executes as a single statement. | Executes as a whole block. |
| Esas olarak verileri işlemek için kullanılır. | Esas olarak bir uygulama oluşturmak için kullanılır. |
| Interacts directly with the database server. | The block itself has no direct interaction; its SQL part does. |
| Cannot contain PL/SQL code. | It is an extension of SQL, so it can contain SQL inside it. |
Having seen how PL/SQL fits together, the next step is to learn its building block, covered under PL/SQL blokları.
