pl/sql dbms_DBMS中的PL / SQL简介

我会带着你远行 2023-03-05 12:39 23阅读 0赞

pl/sql dbms

SQL queries act as statements that are run over the database. But the technical world needs various functionalities altogether in order to work with a large amounts of data. **PL / SQL** is also one of them.

SQL查询充当在数据库上运行的语句。 但是，技术世界总共需要各种功能才能处理大量数据。 **PL / SQL**也是其中之一。

**PL / SQL** means procedural language/structured query language. This is an extension of SQL. As the name suggests, it writes an SQL program in a procedural format. It is the highly structured language. SQL helps us run one action at a time in the database simultaneously. But what if one wants to do different actions together? Then we will need a certain type of pattern.

**PL / SQL**表示过程语言/结构化查询语言。 这是SQL的扩展。 顾名思义，它以过程格式编写SQL程序。 它是高度结构化的语言。 SQL帮助我们同时在数据库中一次运行一个动作。 但是，如果一个人想一起做不同的事情怎么办？ 然后，我们将需要某种类型的模式。

**PL / SQL** is programming in Pattern. It is an essential member of the Oracle Programming tool set and is used to encode programming by the server, SQL programming. **PL / SQL** is also a non-sensitive registry language such as SQL.

**PL / SQL**正在使用Pattern进行编程。 它是Oracle编程工具集的重要组成部分，用于对服务器的编程(SQL编程)进行编码。 **PL / SQL**还是一种非敏感的注册表语言，例如SQL。

It extends SQL by adding constructs found in another procedural language, such as variables, a structure of control as if otherwise, cycles, a procedure, a function, and more advanced programming functions such as cursors, triggers, exception handling. **PL / SQL** programming is performed in the block structure.

它通过添加在另一种过程语言中找到的构造来扩展SQL，例如变量，控制结构(如果没有的话)，循环，过程，函数以及更高级的编程功能(例如游标，触发器，异常处理)。 **PL / SQL**编程是在块结构中执行的。

### PL / SQL的功能 **(**Features of PL/SQL**)** ###

![format_png][]

### PL / SQL的优点 **(**Advantages of PL/SQL**)** ###

1.  It provides Constricted combination with SQL.
    
    它提供了与SQL的受限组合。
2.  It provides Improved performance.
    
    它提供了改进的性能。
3.  It provides Advanced Productivity.
    
    它提供了先进的生产力。
4.  It provides Complete Compactness.
    
    它提供了完整的紧凑性。
5.  It provides Constricted Security.
    
    它提供了受约束的安全性。
6.  It provides Access to Pre-defined Packages.
    
    它提供对预定义软件包的访问。
7.  It Supports for Object-Oriented Programming.
    
    它支持面向对象的编程。
8.  It Supports for Rising Web Applications and Pages.
    
    它支持上升的Web应用程序和页面。

### PL / SQL的缺点 **(**Disadvantages of PL/SQL**)** ###

PL / SQL loses its importance with the fact that, SQL is enough to run the program, with as many steps possible and work precisely.

PL / SQL失去了其重要性，因为SQL足以运行程序，并具有尽可能多的步骤并能精确地工作。

> 翻译自: [https://www.includehelp.com/pl-sql/introduction-to-pl-sql-in-dbms.aspx][https_www.includehelp.com_pl-sql_introduction-to-pl-sql-in-dbms.aspx]

pl/sql dbms

[format_png]: /images/20230208/9757980cb49f425dad0befc618730dac.png
[https_www.includehelp.com_pl-sql_introduction-to-pl-sql-in-dbms.aspx]: https://www.includehelp.com/pl-sql/introduction-to-pl-sql-in-dbms.aspx