新書推薦:

《
病菌、观念与社会:病菌如何影响现代生活
》
售價:HK$
85.8

《
经过检视的人生 从苏格拉底到尼采
》
售價:HK$
66.0

《
阿尔喀比亚德斯 I(柏拉图全集)
》
售價:HK$
107.8

《
百家争鸣与中华文明的哲学突破
》
售價:HK$
115.5

《
孟子学术流传与秦汉价值重构
》
售價:HK$
110.0

《
中国早期城市与文明起源 一部中国早期城市发展简史,解读城市与文明交织共生的规律
》
售價:HK$
96.8

《
只要我还在创作 角谷美智子访谈录
》
售價:HK$
74.8

《
国医大师邓铁涛 治未病从孩子抓起 中医治未病 二十四节气顺时调养 常见病预防 中医健康体检 广东科技
》
售價:HK$
54.9
|
| 內容簡介: |
|
本书是最新第6版更新版,从PLSQL编程、PLSQL程序结构、PLSQL程序数据、PLSQL中的SQL、PLSQL应用构建、高级PLSQL主题这6个方面详细系统地讨论了PLSQL以及如何有效地使用它。本书能够帮助你充分利用PLSQL来解决数据库开发中遇到的各种问题,引导你掌握各种构建应用的技巧和技术,以便使你编写出高效、可维护的代码。
|
| 關於作者: |
Steven Feuerstein被认为是世界上Oracle PL/SQL语言方面的权威专家之一。Steven从1990年就开始编写PL/SQL语言相关书籍并为开发人员进行培训。他在这个方向出版了十本书,包括《Oracle PL/SQL Best Practices》。
BillPribyl是一名作家、讲师和软件咨询师。他是《LearningOracle PL/SQL》的作者,也是《Oracle PL/SQL Programming和《Oracle PL/SQL Language Pocket Reference》的作者之一。
|
| 目錄:
|
Preface
Partl. Programming in PLSQL
1. Introduction to PLSQL
What Is PLSQL?
The Origins of PLSQL
The Early Years of PLSQL
Improved Application Portability
Improved Execution Authority and Transaction Integrity
Humble Beginnings, Steady Improvement
So This Is PLSQL
Integration with SQL
Control and Conditional Logic
When Things Go Wrong
About PLSQL Versions
Oracle Database 12c New PLSQL Features
Resources for PLSQL Developers
The O''Reilly PLSQL Series
PLSQL on the Internet
Some Words of Advice
Don''t Be in Such a Hurry!
Don''t Be Afraid to Ask for Help
Take a Creative, Even Radical Approach
2. Creating and Running PLSQL Code
Navigating the Database
Creating and Editing Source Code
SQL*Plus
Starting Up SQL*Plus
Running a SQL Statement
Running a PLSQL Program
Running a Script
What Is the "Current Directory"?
Other SQL*Plus Tasks
Error Handling in SQL*Plus
Why You Will Love and Hate SQL*Plus
Performing Essential PLSQL Tasks
Creating a Stored Program
Executing a Stored Program
Showing Stored Programs
Managing Grants and Synonyms for Stored Programs
Dropping a Stored Program
Hiding the Source Code of a Stored Program
Editing Environments for PLSQL
Calling PLSQL from Other Languages
C: Using Oracle''s Precompiler Pro*C
Java: Using JDBC
Perl: Using Perl DBI and DBD::Oracle
PHP: Using Oracle Extensions
PLSQL Server Pages
And Where Else?
3. Language Fundamentals
PLSQL Block Structure
Anonymous Blocks
Named Blocks
Nested Blocks
Scope
Qualify All References to Variables and Columns in SQL Statements
Visibility
The PLSQL Character Set
Identifiers
Reserved Words
Whitespace and Keywords
Literals
NULLs
Embedding Single Quotes Inside a Literal String
Numeric Literals
Boolean Literals
The Semicolon Delimiter
……
|
|