Oracle PL/SQL Built-ins Pocket Reference

Description

This pocket reference provides quick-reference information that will help you use Oracle Corporation's extensive set of built-in functions and packages, including those new to Oracle8. Oracle's PL/SQL language is a programming language providing procedural extensions to the SQL relational database language and to an ever-growing number of Oracle development tools. Among the most useful constructs in the PL/SQL language are the built-in functions and packages. Built-in functions are constructs that operate on certain types of data (e.g., numeric, character) to return a result. By using functions, you can minimize the coding you need to do in your programs. Functions are described in detail in Steven Feuerstein's Oracle PL/SQL Programming; this comprehensive guide to building applications with PL/SQL has become the bible for PL/SQL developers who have raved about its completeness, readability, and practicality. Built-in functions fall into several major categories: Character functions: Operate on character data. Examples include CONCAT (concatenates two strings into one), LENGTH (returns the length of a string), and REPLACE (replaces a character sequence in a string with a different set of characters). Date functions: Operate on dates and supplement the DATE datatype. Examples include SYSDATE (returns the current date and time in the Oracle Server) and LAST_DAY (returns the last day in the month of the specified date). Numeric functions: Operate on numeric data. Examples include CEIL (returns the smallest integer greater than or equal to the specified number) and POWER (returns a number raised to a particular power). LOB functions: Operate on large object data. Examples include EMPTY_BLOB (returns an empty locator of the binary large object type) and EMPTY_CLOB (returns an empty locator of the character large object type). Conversion functions: Perform explicit conversions of different types of data. Examples include TO_CHAR (converts a number or date to a string) and TO_NUMBER (converts a string to a number). Miscellaneous functions. Examples include GREATEST (returns the greatest of the specified list of values) and UID (returns the user ID of the current Oracle session). Built-in packages (collections of PL/SQL objects, such as functions, procedures, and data structures) greatly expand the scope of the PL/SQL language. These packages are described in detail in Feuerstein's and Beresniewicz's book, Oracle Built-in Packages. Built-in packages are built by Oracle Corporation and stored directly in the Oracle database. The functionality of the built-ins is available from any programming environment that can call PL/SQL stored procedures, including Visual Basic, Oracle Developer/2000, Oracle Application Server (for Web-based development), and, of course, the Oracle database itself. Built-in packages extend the capabilities and power of PL/SQL in many significant ways. For example: DBMS_SQL executes dynamically constructed SQL statements and PL/SQL blocks of code. DBMS_PIPE communicates between different Oracle sessions through a pipe in the RDBMS shared memory. DBMS_JOB submits and manages regularly scheduled jobs for execution inside the database. DBMS_LOB accesses and manipulates Oracle8's large objects (LOBs) from within PL/SQL programs. The book shows how to call all of the commonly used built-in functions and packages. For packages, it also shows the RESTRICT REFERENCES pragmas (needed if you call packages from a SQL statement), as well as the exceptions, constants, and data structures defined in the packages.

Get the book

Amazon.com

Search the book

eBay.com

Search the book

Similar books

• 

  Oracle数据库的实施和管理

  By 科尔比

  本书中文简体字版由机械工业出版社出版。

• 

  Oracle jing sui

  By Rick Greenwald

  本书共分15章, 主要内容包括:认识Oracle数据库, Oracle数据库体系结构, 安装和运行Oracle数据库, Oracle数据库数据结构, 管理Oracle数据库, Oracle数据库性能, Oracle和事务处理等.

• 

  Oracle 8: A Beginner's Guide

  By 阿比, 科里, Michael Abbey

  Oracle Press授权出版

• 

  Oracle8i备份与恢复手册

  By 阿德柯利, 王毳

  著者译名:瓦浦瑞。

• 

  ORACLE 8i: a beginner's guide

  By Michael Abbey, 艾步蘭森, 埃比

  ORACLE 8i: a beginner's guide

• 

  Oracle Database 11g Release 2 performance tuning tips & techniques

  By Richard J. Niemiec, 杨中, 朱波

  本书详细介绍了最新的监控,故障排除和优化的方法,取自真实世界的案例研究和最佳实践遍及全书,从中您可以学会如何找出和解决瓶颈问题,如何配置存储设备 ...

• 

  Oracle SQL: 101 Frequently Asked Questions

  By Gary M. Lewis, Alex Sirota

  Oracle SQL: 101 Frequently Asked Questions

• 

  Oracle Database 10g PL/SQL入门教程

  By Allen, Christopher·艾伦

  本书主要内容:数据库基础(数据库入库,存储和检索数据:基础知识,高级数据操作,操作SQL*Plus);高级SQL(SQL函数,索引和约束的运用,其他有用的Oracle技巧);使用PL/SQL创建程序(PL/SQL概述 ...

• 

  SQL voor het hoger onderwijs

  By Bijoy Bordoloi

  In een database kunnen twee soorten gegevens worden opgeslagen : o Gegevens van gebruikers . ... De tabellen worden formeel aangeduid als 2 Hoofdstuk 1 - Inleiding Gegevens en informatie Relationele database.

• 

  Oracle 10g数据库入门与实践

  By 萧文龙

  首先编写 ASP ( Active Server Page )程序,通过 ADO ( ActiveX Data Object )访问 ODBC ( Open Database Connectivity ,开放式数据库连接) ,再通过 ODBC 存取 Oracle 数据库。在 Oracle 10g Web 数据库的开发环境中,需要完成下列各项工作,才能从 Intermet ...