Oracle 11g PL/SQL(基础二)

Understanding Exception With PL/SQL

An exception can be raised:

       1.显式

        2.隐式

An exception can be handled:

    通过handler捕获

    通过调用环境处理

第一个不能跳回去

第二个可以跳

Trapping Non-Predefined Oracle Sever Errors

SQLCODE: Returns the numeric value for the error code

SQLERRM: Returns the message associated with the error number

AUTONOMOUS_TRANSACTION 表示独立一个事物， 不影响外边的update

RAISE_APPLICATION_ERROR procedure

可以把异常放在子模块，然后 就模拟 实现 异常抛出了  可以接执行父块的内容

PL/SQL Run-time Architecture

PL/SQL , SQL的执行引擎是分离的

Differences Between Anonymous Blocks and Subprograms

Creating Procedures with the SQL CREATE OR REPLACE Statement

Naming Conventions of PL/SQL Structures Examples

Create PROCEDURE proc_name(param_name [mode] datatype)

Viewing OUT Parameters: Using SQL*Plus Host Variables

Passing Actual Parameters: Examples

Using the DEFAULT Option for the Parameters

Forward Declaration

set autocommit on ;

Creating Functions

Restrictions when Calling Functions from SQL Expressions