您现在的位置：快乐比价网 > 图书 > 计算机与网络 > 数据库 > 商品详情

Oracle PL/SQL Language Pocket Reference

分享到：

最低价：￥90.00

定价：￥106.88

作者：Steven Feuerstein 著

出版社：

出版时间：2007年10月30日

I S B N：9780596514044

价格比较

商品详情

商品评论(0条)

Oracle PL/SQL Language Pocket Reference

送货上门

价格
90.00元

商品详情

编辑推荐

内容简介

作者简介

Steven Feuerstein is considered one of the world's leading experts on the Oracle PL/SQL language, having written ten books on PL/SQL, including "Oracle PL/SQL Programming" and "Oracle PL/SQL Best Practices" (both O'Reilly). He has been developing software since 1980, spent five years with Oracle (1987-1992) and serves as PL/SQL Evangelist for Quest Software. His Oracle PL/SQL Best Practices column is one of the most popular pages on the Oracle Technology Network and he writes regularly for Oracle Magazine.Bill Pribyl is the primary author of Learning Oracle PL/SQL and the coauthor of Oracle PL/SQL Programming and its companion pocket reference, all from O'Reilly Media. He is oddly proud of having used PL/SQL to write TCP/IP networking clients, tnsping callouts, near-realtime commodity price loaders, and transcendental functions. Bill, who holds a degree in physics from Rice University, is the former editor of the IOUG technical journal (Select) and former president of the South Central Oracle Users Group. At home with his family in Houston, Texas, one of Bill's current nonbillable titles include Webmaster for his neighborhood civic club.Chip Dawes has been building and maintaining systems on relational databases since 1988 and with Oracle since 1990. Currently a consultant with D&D Technologies, a Chicago consultancy, he works with, lectures on, and writes about Oracle database administration, client server application development, and Unix system administration.

作者简介

Introduction Acknowledgments Conventions PL/SQL Language Fundamentals PL/SQL Character Set Identifiers Boolean, Numeric, and String Literals Numeric Literals Datetime Interval Literals Delimiters Comments Pragmas Statements Block Structure Variables and Program Data Scalar Datatypes NLS Character Datatypes LOB Datatypes Implicit Datatype Conversions NULLs in PL/SQL Declaring Variables Anchored Declarations Programmer-Defined Subtypes Conditional and Sequential Control Conditional Control Statements Sequential Control Statements Loops Simple Loop Numeric FOR Loop Cursor FOR Loop WHILE Loop REPEAT UNTIL Loop Emulation EXIT Statement Loop Labels Database Interaction Transaction Management Autonomous Transactions Cursors in PL/SQL Explicit Cursors Implicit Cursors Dynamic Cursors Cursor Variables Cursor Expressions Exception Handling Declaring Exceptions Raising Exceptions Scope Propagation Records in PL/SQL Declaring Records Referencing Fields of Records Assigning Records DML and Records Nested Records Named Program Units Procedures Functions Parameters Triggers Creating Triggers Trigger Predicates DML Events DDL Events Database Events Packages Package Structure Referencing Package Elements Package Data SERIALLY_REUSABLE Pragma Package Initialization Calling PL/SQL Functions in SQL Calling a Function Requirements and Restrictions Calling Packaged Functions in SQL Column/Function Name Precedence Oracle's Object-Oriented Features Object Types Type Inheritance Methods Methods in Subtypes Manipulating Objects in PL/SQL and SQL Upcasting and Downcasting Changing Object Types Collections Declaring a Collection Initializing a Collection Adding and Removing Elements Nested Table Functions Collection Methods Collections and Privileges Nested Collections Bulk Binds External Procedures Creating an External Procedure Parameters Java Language Integration Example Publishing Java to PL/SQL Data Dictionary Regular Expressions (Oracle Database 10g) Metacharacters REGEXP_LIKE REGEXP_INSTR REGEXP_SUBSTR REGEXP_REPLACE Match Modifiers Reserved Words Index