Introduction to Oracle's PL/SQL Learning notes (i)

1. What is PL/SQL?

PL/SQLIt is also a programming language called the Process SQL language (procedural language/sql). PL/SQLis aOracle DatabaseAn extension to the SQL statement. Added to the use of ordinary SQL statementsProgramming languagesthe characteristics, soPL/SQLThe data operation and query statements are organized in the process unit of PL/SQL code, and the complex functions or computations are realized through the operation of logic judgment and loop. PL/SQL is available only for Oracle databases.

2. The advantages of PL/SQL

1. Improve the performance of your application

Traditional Java programs that pass SQL to Oracle Server SQL statements are compiled on the Oracle server,

compile every time.

2. Modular Design Ideas

The process of paging, directly passing the table name, the first few pages, a few data per page .....

[process of order, process of transfer]

3. Reduce network traffic

Traditional SQL statements are delivered to the Oracle server using bandwidth, and if there is a lot of SQL, it takes a lot of traffic.

PL/SQL reduces the amount of network traffic by reducing the number of statements.

4. Improve security5. You can use simple PL/SQL to write complex statements
3. The shortcomings of PL/SQL1. Transplant is not good2. The skills required for Oracle are high

4. Development toolsA. Sqlplusb. PL/SQL Developer (Development of PL/SQL artifact)C. SQL Developer (Oracle's own development tools, multiplatform)

Introduction to Oracle's PL/SQL Learning notes (i)