新書推薦:

《
汗青堂丛书163——狄仁杰与武则天:武周革命与平民官僚的崛起
》
售價:HK$
96.8

《
历史、神话与艺术:东西方文化的解读和比较
》
售價:HK$
74.8

《
在别处安家:关于逃离、生存与梦想破碎之地
》
售價:HK$
74.8

《
棉花王国 密西西比河流域的奴隶制与资本主义 (一部改写美国奴隶制认知的史学佳作)
》
售價:HK$
129.8

《
历史哲学 一部关于世界文明 理性与历史的终极思考
》
售價:HK$
108.9

《
诡舍6完结篇蔽日开天
》
售價:HK$
54.8

《
大学问·秦汉经济政策与经济思想史稿(jue版好书复活,读懂秦汉,就是读懂中国两千年的经济底色。)
》
售價:HK$
97.9

《
狄仁杰与武则天 武周革命与平民官僚的崛起 钤印版 汗青堂丛书163
》
售價:HK$
96.8
|
| 內容簡介: |
|
本书是最新第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
……
|
|