What is PL / SQL?

Time:2020-6-27

What is PL / SQL?

1、 What is PL / SQL?

PL / SQL (procedure language / SQL) is an extension of Oracle in the standard SQL language. QL / SQL can not only embed SQL language, but also define variables and constants, allow private conditional statements and circular statements, and allow exceptions to handle various errors, which makes its function more powerful.

PL / SQL development tools mainly include:

  • SQL * plus development tool. SQL * Plus is a command-line tool provided by Oracle company. We can write SQL and PL / SQL programs directly in it.
  • Oracle SQL developer is a free integrated development environment, which simplifies the development and management of Oracle database in traditional deployment and cloud deployment.
  • PL / SQL developer is an integrated development environment (IDE) for developing PL / SQL blocks. It is a stand-alone product, not an accessory of Oracle.

2、 The difference between PL / SQL and SQL

  • SQL is a structured query language, which is close to natural language. With SQL, you only need to say what to do, not how to do it. It is composed of data definition language, data manipulation language and data control language. It is not process oriented, that is, the former statement is independent of the latter. SQL is the standard language.
  • PL / SQL, Oracle’s expansion of SQL standard, has added process oriented functions, so it can be used to write stored procedures, storage functions, triggers and so on. PL / SQL is structured SQL, that is, SQL with if… Else… For… And other control processes added to standard SQL.

3、 Develop the first PL / SQL program

  • Developing the first PL / SQL program in sqlplus

What is PL / SQL?

  • Developing the first PL / SQL program in sqlplus

What is PL / SQL?

What is PL / SQL?

Recommended Today

What are the new methods of visual + map technology?

Last week, Ren Xiaofeng, chief scientist of Alibaba Gaode map, made a technical exchange with you on the development of computer vision related technology and the application in the field of map travel at the online live broadcast activity of “cloud dialogue” between senior students of Alibaba. The interaction between live broadcast is hot. Especially […]