新書推薦:

《
耶鲁大学公开课 心理学导论
》
售價:HK$
72.6

《
三江源·可可西里野生动物图鉴(兽类卷)
》
售價:HK$
140.8

《
存在与真理
》
售價:HK$
85.8

《
免疫的奥秘:病毒、健康与人类命运
》
售價:HK$
86.9

《
变形金刚:绝境逢生(普通版)(全新漫画合订本第三册,简中版全球同步上市!完整收录能量块宇宙2024年
》
售價:HK$
74.8

《
成事铁律
》
售價:HK$
61.6

《
大政府的国际起源:美国产业政策与制度变迁
》
售價:HK$
96.8

《
何以浓香——当代中国泸型酒酿制技艺传播史料辑录
》
售價:HK$
181.5
|
| 內容簡介: |
|
本书是最新第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
……
|
|