Oracle9i笔记1

Typographic Conventions 程序格式约定

Following are two lists of typographical conventions that used specifically within text or within code.

__________________________________________________________________________

After completing this course, you should be able to do the following: 1. Describe the purpose of PL/SQL.

2. Describe the use of PL/SQL for the developer as well as the DBA. 3. Explain the benefits of PL/SQL.

4. Create, execute, and maintain procedures, functions, packages, and database triggers. 5. Manage PL/SQL subprograms and triggers 6. Describe Oracle supplied packages. 7. Manipulate large objects(LOBs). Lesson Aim

In this course, you are introduced to the features and benefits of PL/SQL. You learn how to access the database using PL/SQL.

You can develop modularized applications with database procedures using database objects, such as the following:

你可以用像下面这些组件一样的数据库过程，开发模块化的应用程序。 Procedures and functions Packages

Database triggers

Modular applications improve: 使应用程序得到如下改善： Functionality 功能 Security 安全性

Overall performance 总体性能提升

1. Describe the purpose of PL/SQL. PL/SQL的目标。

1).PL/SQL is the procedural extension to SQL with design features of programming languages. PL/SQL 是SQL在設計程序上的延伸。

2).Data manipulation and query statements of SQL are included within procedural units of code. 操作數據和查詢語句都是用程序上的代碼來實現。

PL/SQL Environment

PL/SQL code can also be stored in the Oracle Server as subprograms that can be referenced by any number of applications connected to the database.

PL/SQL代碼也可以保存在Oracle 服務器上作為子程序，可以被所有的應用程序調用來操作使用數據庫。

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