Oracle9i笔记1(10)

Referencing Non-PL/SQL Variables 引用非 PL/SQL 變量

DBMS_OUTPUT.PUT_LINE

DBMX_OUTPUT is an Oracle-supplied package, and PUT_LINE is a procedure within that package.

Practice 1.b. 2.abc. 3

Charpter 2

Writing Executable Statements

After completing this lesson, you should be able to do the following: Describe the significance of the executable section Use identifiers correctly

Write statements in the executable section Describe the rules of nested blocks Execute and text a PL/SQL block Use coding conventions

Identifiers are used to name PL/SQL program items and units, which include constants, variables, exceptions, cursors, cursor variables, subprograms and packages.

SQL Functions in PL/SQL: Examples

Most of the SQL function can be used in PL/SQL. These built-in functions help you to manipulate data; they fall into the following categories: Number Character

Conversion 換算 Date

Miscellaneous 雜項，其它

select chr(66) from dual B

PL/SQL has its own error handling functions which are: SQLCODE SQLERRM

搜索“diyifanwen.net”或“第一范文网”即可找到本站免费阅读全部范文。收藏本站方便下次阅读，第一范文网，提供最新人文社科Oracle9i笔记1(10)全文阅读和word下载服务。