Oracle PL/SQL編程

Oracle PL/SQL編程

《Oracle PL/SQL編程》是2015年東南大學出版社出版的圖書。

基本介紹

  • 中文名:Oracle PL/SQL編程
  • 作者:Steven Feuerstein、Bill Pribyl
  • 類別:計算機、網路
  • 出版社:東南大學出版社
  • 出版時間:2015年
  • 開本:16 開
  • 裝幀:平裝
  • ISBN:9787564153472
內容簡介,圖書目錄,作者簡介,

內容簡介

 本書是*第6版更新版,從PL/SQL編程、PL/SQL程式結構、PL/SQL程式數據、PL/SQL中的SQL、PL/SQL套用構建、高級PL/SQL主題這6個方面詳細系統地討論了PL/SQL以及如何有效地使用它。本書能夠幫助你充分利用PL/SQL來解決資料庫開發中遇到的各種問題,引導你掌握各種構建套用的技巧和技術,以便使你編寫出高效、可維護的代碼。

圖書目錄

Preface
Partl. Programming in PL/SQL
1. Introduction to PL/SQL
What Is PL/SQL?
The Origins of PL/SQL
The Early Years of PL/SQL
Improved Application Portability
Improved Execution Authority and Transaction Integrity
Humble Beginnings, Steady Improvement
So This Is PL/SQL
Integration with SQL
Control and Conditional Logic
When Things Go Wrong
About PL/SQL Versions
Oracle Database 12c New PL/SQL Features
Resources for PL/SQL Developers
The O'Reilly PL/SQL Series
PL/SQL 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 PL/SQL Code
Navigating the Database
Creating and Editing Source Code
SQL*Plus
Starting Up SQL*Plus
Running a SQL Statement
Running a PL/SQL 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 PL/SQL 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 PL/SQL
Calling PL/SQL from Other Languages
C: Using Oracle's Precompiler (Pro*C)
Java: Using JDBC
Perl: Using Perl DBI and DBD::Oracle
PHP: Using Oracle Extensions
PL/SQL Server Pages
And Where Else?
3. Language Fundamentals
PL/SQL Block Structure
Anonymous Blocks
Named Blocks
Nested Blocks
Scope
Qualify All References to Variables and Columns in SQL Statements
Visibility
The PL/SQL Character Set
Identifiers
Reserved Words
Whitespace and Keywords
Literals
NULLs
Embedding Single Quotes Inside a Literal String
Numeric Literals
Boolean Literals
The Semicolon Delimiter
……

作者簡介

 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》的作者之一。

相關詞條

熱門詞條

聯絡我們