Chapter 2 procedural performance tuning of PL/SQL applications
I. Reasons for PL/SQL Performance problems
When the execution efficiency of PL/SQL-based applications is low, it is usually caused by poor SQL statements and programming methods,
Oracle PL/SQL language (procedural language/sql) is a combination of structuredQuery and Oracle's own process control as one of the powerful language, PL/SQL not only support more data types, with self-Variable declarations, assignment statements,
Introduction to PL/SQL program design and plsql Program DesignZookeeper
① PL/SQL program design overview
PL/SQL is an advanced database programming language used to access ORACLE databases in various environments. Because the language is integrated
Introduction to ①pl/sql Program designPL/SQL is an advanced database programming language that is specifically designed to access Oracle databases in a variety of environments. Because the language is integrated into the database server,So PL/SQL
I am learning Oracle is to do notes and experimental code records, the content is very full, but also quite detailed, send a blog post to the needs of friends, a total of 1w learning notes. is done before, has been at the bottom of the pressure,
3.2. Compound Variables
Composite variables are used to store multiple values. When you define a composite variable, you must use the PL/SQL Composite data type.PL/SQL includes PL/SQL records, PL/SQL tables, nested tables, and varray.
2. PL/SQL
1. knowledge point: you can read the following screen recording:
PL/SQL program structure declare description (variable description, cursor declaration, exception description) begin statement sequence (DML statement 〕... Exception Processing
1. Knowledge Points: Can be read against the following record screenPL/SQL Program structure declare description section (variable description, cursor declaration, exception Description)begin statement sequence (DML statement) ... exception
1. Overview PL/SQL (Procedural Language/Structured Query Language) is a Procedural expansion of Oracle's standard database Language SQL. It associates the database technology with the Procedural programming Language, it is an application development
I am learning Oracle is to do notes and experimental code records, the content is very full, but also quite detailed, send a blog post to the needs of friends, a total of 1w learning notes. is done before, has been at the bottom of the pressure,
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.