ORACLE PL/SQL Instance fine solutions in the third chapter

3.1 using DML in PL/SQL

In the PL/SQL block, the two variables are assigned the value of a. : = Initialize. B. The SELECT INTO syntax, the declaration portion of a PL/SQL block is declared, and later can be assigned using a SELECT statement.

3.1.1 Variable initialization using SELECT INTO syntax

Select A to v_a INSERT into xxx (table) (XA) VALUES (v_a)

3.1.2 using DML in a PL/SQL statement block

A. Using the Oracle sequence CURR

B. Get and increment sequence values currval The current value of the returned sequence Nextval increment the current sequence value and return the new value

C. Getting numbers from a sequence

3.1.3 using sequences in a PL/SQL statement block

3.2 Using SavePoint

The goal is to use Commint,roolback and savepoint with transactions in a PL/SQL statement block, meaning that the program can be decomposed into manageable units, Ifenjie transactions into smaller elements, to ensure that the application only holds the correct data.

Commit will perpetuate the time in the master rollback will delete the time in the transaction, and can also control the transaction through Savepoin

ORACLE PL/SQL Instance fine solutions in the third chapter