新書推薦:

《
跃入夏天2:青春校园治愈成长小说 沉默寡言排球手x暴躁可爱小不点
》
售價:HK$
47.1

《
百妖谱3:裟椤双树代表作 奇幻百妖谱动漫原著系列小说 古风青春文学玄幻巨作
》
售價:HK$
49.5

《
西方哲学史:从前苏格拉底到后现代主义
》
售價:HK$
153.8

《
读者考试精选+青年文摘考试精选+登天的感觉:我让考生超常发挥 岳晓东著 如何让考生超常发挥高度自信青
》
售價:HK$
96.8

《
索恩丛书·伊凡雷帝:俄国的第一位沙皇
》
售價:HK$
141.9
![[共2册]利他性销售+利他式表达全2册正版书籍破解销售密码实现业绩狂飙洞察客户未言明核心需求痛点成交](//img.megbook.hk/upload/mall/productImages/26/10/9787547753248.jpg)
《
[共2册]利他性销售+利他式表达全2册正版书籍破解销售密码实现业绩狂飙洞察客户未言明核心需求痛点成交
》
售價:HK$
151.8

《
折姜(中)
》
售價:HK$
51.5

《
清华大学藏战国竹简校释(伍):《筮法》诸篇
》
售價:HK$
107.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
……
|
|