Oracle PL/SQL编程-(上下册)-(影印版)_PDF下载[54MB-百度云]弗伊尔斯坦

本书特色

[

本书是*新第6版更新版，从pl/sql编程、pl/sql程序结构、pl/sql程序数据、pl/sql中的sql、pl/sql应用构建、高级pl/sql主题这6个方面详细系统地讨论了pl/sql以及如何有效地使用它。本书能够帮助你充分利用pl/sql来解决数据库开发中遇到的各种问题，引导你掌握各种构建应用的技巧和技术，以便使你编写出高效、可维护的代码。

]

作者简介

[

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

]

prefacepartl. programming in pl/sql1. introduction to pl/sqlwhat is pl/sql?the origins of pl/sqlthe early years of pl/sqlimproved application portabilityimproved execution authority and transaction integrityhumble beginnings, steady improvementso this is pl/sqlintegration with sqlcontrol and conditional logicwhen things go wrongabout pl/sql versionsoracle database 12c new pl/sql featuresresources for pl/sql developersthe o’reilly pl/sql seriespl/sql on the internetsome words of advicedon’t be in such a hurry!don’t be afraid to ask for helptake a creative, even radical approach2. creating and running pl/sql codenavigating the databasecreating and editing source codesql*plusstarting up sql*plusrunning a sql statementrunning a pl/sql programrunning a scriptwhat is the “current directory”?other sql*plus taskserror handling in sql*pluswhy you will love and hate sql*plusperforming essential pl/sql taskscreating a stored programexecuting a stored programshowing stored programsmanaging grants and synonyms for stored programsdropping a stored programhiding the source code of a stored programediting environments for pl/sqlcalling pl/sql from other languagesc: using oracle’s precompiler (pro*c)java: using jdbcperl: using perl dbi and dbd::oraclephp: using oracle extensionspl/sql server pagesand where else?3. language fundamentalspl/sql block structureanonymous blocksnamed blocksnested blocksscopequalify all references to variables and columns in sql statementsvisibilitythe pl/sql character setidentifiersreserved wordswhitespace and keywordsliteralsnullsembedding single quotes inside a literal stringnumeric literalsboolean literalsthe semicolon delimiter……