Introduction to PL/SQL
- PL/SQL Overview
- Benefits of PL/SQL Subprograms
- Overview of the Types of PL/SQL blocks
- Creating and Executing a Simple Anonymous Block
- Generating Output from a PL/SQL Block
Declaring PL/SQL Identifiers
- Different Types of Identifiers in a PL/SQL subprogram
- Using the Declarative Section to Define Identifiers
- Storing Data in Variables
- Scalar Data Types
- %TYPE Attribute
- Bind Variables
- Using Sequences in PL/SQL Expressions
Writing Executable Statements
- Describing Basic PL/SQL Block Syntax Guidelines
- Commenting Code
- SQL Functions in PL/SQL
- Data Type Conversion
- Nested Blocks
- Operators in PL/SQL
Interacting with the Oracle Server
- Including SELECT Statements in PL/SQL to Retrieve data
- Retrieving Data in PL/SQL with the SELECT Statement
- The SQL Cursor concept
- Avoiding Errors by Using Naming Conventions When Using Retrieval and DML Statements
- Manipulating Data in the Server Using PL/SQL
- Understanding the SQL Cursor concept
- Using SQL Cursor Attributes to Obtain Feedback on DML
- Saving and Discarding Transactions
Writing Control Structures
- Conditional processing Using IF Statements
- Conditional processing Using CASE Statements
- Simple Loop Statement
- While Loop Statement
- For Loop Statement
- The Continue Statement
Working with Composite Data Types
- Using PL/SQL Records to Hold Multiple Values of Different Types
- Using the %ROWTYPE Attribute
- Inserting and Updating with PL/SQL Records
- INDEX BY Tables to Hold Multiple Values of the Same Data Type
- INDEX BY Table Methods
- INDEX BY Table of Records
Using Explicit Cursors
- Understanding Explicit Cursors
- Declaring the Cursor
- Opening the Cursor
- Fetching data from the Cursor
- Closing the Cursor
- Cursor FOR loop
- The %NOTFOUND and %ROWCOUNT Attributes
- FOR UPDATE Clause and WHERE CURRENT Clause
Handling Exceptions
- Understanding Exceptions
- Handling Exceptions with PL/SQL
- Trapping Predefined Oracle Server Errors
- Trapping Non-Predefined Oracle Server Errors
- Trapping User-Defined Exceptions
- Propagate Exceptions
- RAISE_APPLICATION_ERROR Procedure
Creating Stored Procedures
- Creating a Modularize and Layered Subprogram Design
- Modularizing Development With PL/SQL Blocks
- Understanding the PL/SQL Execution Environment
- The Benefits of Using PL/SQL Subprograms
- The Differences Between Anonymous Blocks and Subprograms
- Creating, Calling, and Removing Stored Procedures Using the CREATE Command and SQL Developer
- Using Procedures Parameters and Parameters Modes
- Viewing Procedures Information Using the Data Dictionary Views and SQL Developer
Creating Stored Functions and Debugging Subprograms
- Creating, Calling, and Removing a Stored Function Using the CREATE Command and SQL Developer
- Identifying the Advantages of Using Stored Functions in SQL Statements
- Identify the steps to create a stored function
- Using User-Defined Functions in SQL Statements
- Restrictions When Calling Functions from SQL statements
- Controlling Side Effects When Calling Functions from SQL Expressions
- Viewing Functions Information
- Debugging Functions and Procedures
Creating Packages
- Listing the Advantages of Packages
- Describing Packages
- The Components of a Package
- Developing a Package
- The Visibility of a Package’s Components
- Creating the Package Specification and Body Using the SQL CREATE Statement and SQL Developer
- Invoking the Package Constructs
- Viewing the PL/SQL Source Code Using the Data Dictionary
Working With Packages
- Overloading Subprograms in PL/SQL
- Using the STANDARD Package
- Using Forward Declarations to Solve Illegal Procedure Reference
- Using Package Functions in SQL and Restrictions
- Persistent State of Packages
- Persistent State of a Package Cursor
- Controlling Side Effects of PL/SQL Subprograms
- Using PL/SQL Tables of Records in Packages
Using Oracle-Supplied Packages in Application Development
- Using Oracle-Supplied Packages
- Examples of Some of the Oracle-Supplied Packages
- How Does the DBMS_OUTPUT Package Work?
- Using the UTL_FILE Package to Interact With Operating System Files
- Using the UTL_MAIL Package
- Using the UTL_MAIL Subprograms
Using Dynamic SQL
- The Execution Flow of SQL
- What is Dynamic SQL?
- Declaring Cursor Variables
- Dynamically Executing a PL/SQL Block
- Using Native Dynamic SQL to Compile PL/SQL Code
- Using DBMS_SQL Package
- Using DBMS_SQL with a Parameterized DML Statement
- Dynamic SQL Functional Completeness
Design Considerations for PL/SQL Code
- Standardizing Constants and Exceptions
- Using Local Subprograms
- Using Autonomous Transactions
- Using the NOCOPY Compiler Hint
- Using the PARALLEL_ENABLE Hint
- Using the Cross-Session PL/SQL Function Result Cache
- Using the DETERMINISTIC Clause with Functions
- Using Bulk Binding to Improve Performance
Creating Triggers
- Working With Triggers
- Identifying the Trigger Event Types and Body
- Business Application Scenarios for Implementing Triggers
- Creating DML Triggers Using the CREATE TRIGGER Statement and SQL Developer
- Identifying the Trigger Event Types, Body, and Firing (Timing)
- Statement Level Triggers Versus Row Level Triggers
- Creating Instead of and Disabled Triggers
- Managing, Testing, and Removing Triggers
Creating Compound, DDL, and Event Database Triggers
- Working With Compound Triggers
- Identifying the Timing-Point Sections of a Table Compound Trigger
- Compound Trigger Structure for Tables and Views
- Using a Compound Trigger to Resolve the Mutating Table Error
- Comparing Database Triggers to Stored Procedures
- Creating Triggers on DDL Statements
- Creating Database-Event and System-Events Triggers
- System Privileges Required to Manage Triggers
Using the PL/SQL Compiler
- Using the PL/SQL Compiler
- Using the Initialization Parameters for PL/SQL Compilation
- Using the New PL/SQL Compile Time Warnings
- Overview of PL/SQL Compile Time Warnings for Subprograms
- The Benefits of Compiler Warnings
- The PL/SQL Compile Time Warning Messages Categories
- Setting the Warning Messages Levels: Using SQL Developer, PLSQL_WARNINGS Initialization Parameter, and the DBMS_WARNING Package Subprograms
- Viewing the Compiler Warnings: Using SQL Developer, SQL*Plus, or the Data Dictionary Views
Managing PL/SQL Code
- What Is Conditional Compilation and How Does it Work?
- Using Selection Directives
- Using Predefined and User-Defined Inquiry Directives
- The PLSQL_CCFLAGS Parameter and the Inquiry Directive
- Using Conditional Compilation Error Directives to Raise User-Defined Errors
- Using the DBMS_DB_VERSION Package
- Using DBMS_PREPROCESSOR Procedures to Print or Retrieve Source Text
- Obfuscating and Wrapping PL/SQL Code
Managing Dependencies
- Overview of Schema Object Dependencies
- Querying Direct Object Dependencies Using the USER_DEPENDENCIES View
- Querying an Object’s Status
- Invalidation of Dependent Objects
- Displaying Direct and Indirect Dependencies
- Fine-Grained Dependency Management in Oracle Database 11g
- Understanding Remote Dependencies
- Recompiling a PL/SQL Program Unit
分享到:
相关推荐
plsql和instantclient-basic-nt-11.2.0.4.0plsql连接远程oracle文件,很好用,简单
PLSQL基础.pdf SQL21自学通.pdf SQL命令.txt SQL循序渐进.chm
PLSQL介绍.ppt PLSQL介绍.ppt PLSQL介绍.ppt PLSQL介绍.ppt
PLSQL Developer 8.0.3.1510
PLSQL.rar PLSQL.rar PLSQL.rar PLSQL.rar PLSQL.rar
plsql.rar plsql.rar plsql.rar plsql.rar plsql.rar
plsql9.0.2.1621/plsqldev906 通用注册机。提供大家方便
2. 启动PLSQL,点击cancel,在Tools - Preference菜单内配置oracle home路径。注册码可以在百度找一个。 3. Windows增加以下系统环境变量,否则PLSQL显示中文乱码 变量名:NLS_LANG 变量值:SIMPLIFIED CHINESE_...
plsql_developer7.0中文手册.pdf plsql_developer7.0中文手册.pdf plsql_developer7.0中文手册.pdf plsql_developer7.0中文手册.pdf plsql_developer7.0中文手册.pdf
1、点击 "启动PLSQL.exe" 即可免装oracle使用PLSQL 或者 使用qidong.bat启动 ; 2、instantclient_10_2为oracle 10 绿色精简版; 3、设置TNS,用记事本打开配置:instantclient_10_2\tnsnames.ora qidong.bat内容:...
plsql安装程序plsql.rar......................................
解压后,安装到 PL SqlDeveloper安装的目录下即可~然后重新启动PlSql ,如果此时不是中文,就到Tools - Preferences -Appearance 窗口,在 language 下选择Chinese.lang 然后应用修改,并确定就好了
[PLSQL.Developer8.0.4.1514.中文版含注册机中文手册].chinese.exe 详情 3.7MB PLSQL Developer8.0注册机 [PLSQL.Developer8.0.4.1514.中文版含注册机中文手册].keygen.exe 详情 288.5KB 中文用户手册 plsql...
PLSQL Developer 7.0.3 Setup.exe PLSQL Developer 7.0.3 Setup.exe PLSQL Developer 7.0.3 Setup.exe
Change to English MENU Bar: 工具 -> 首选项 -> 用户界面 -> 外观 -> 语言 -> Select "none" from the drop-down menu 。 重新启动(restart) Pl/sqldeveloper应用程序。 注册文件aalf.dat: 装完后 把aalf.dat ...
PL/SQL Developer是一个集成开发环境,专门面向Oracle数据库存储程序单元的开发。如今,有越来越多的商业逻辑和应用逻辑转向了Oracle Server,...2.PLSQL Developer chinese 3.PLSQL Developer keygen 生成注册码注册
4.此时PLSQL Developer工具已经完全安装好。 5.想用PLSQL首先要创建数据库实例,这里的实例名称就是你在登录PLSQL时候需要输入的数据库名称,另外还需要设置用户名跟密码,也是plsql登录时候需要输入的账号跟密码,...
PLSQL Developer.rar PLSQL Developer.rar
PLSQL+Developer+9.0.6.1665(汉化注册版)
plsql 12安装包,用户连接oracle 数据库进行sql操作,并附有汉化包,以及plsql的破解工具;