Oracle PL/SQL Built-ins Pocket Reference

Oracle PL/SQL Built-ins Pocket Reference, 9781565924567 (1565924568), O'Reilly, 1998

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.

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.

Provides quick-reference information that will help you use Oracle's extensive set of PL/SQL built-in functions & packages, including those new to Oracle8. Paper.

Comments

Amazing Books

Principles of Sequencing and Scheduling

John Wiley & Sons, 2009

An up-to-date and comprehensive treatment of the fundamentals of scheduling theory, including recent advances and state-of-the-art topics

Principles of Sequencing and Scheduling strikes a unique balance between theory and practice, providing an accessible introduction to the concepts, methods, and results of scheduling theory and...

Discrete Geometry for Computer Imagery: 15th IAPR International Conference, DGCI 2009, Montréal, Canada, September 30 - October 2, 2009, Proceedings

Springer, 2009

Held for the ?rst time outside Europe, the 15th International Conference on DiscreteGeometryforComputer ImagerytookplaceinMontr' eal(Canada)from September30toOctober2,2009.Thisconferenceaddressedalargeinternational audience: 61 papers were submitted originating from 14 di?erent countries. Following a thorough reviewing process, remodeled...

Mobile Communications: An Introduction to New Media (Berg New Media Series)

Berg Publishers, 2009

The cellphone has achieved a global presence faster than any other form of information and communication technology. A global multi-billion dollar industry, this small, mundane device is now an intrinsic part of our everyday life.

This communications medium has had an immense social and cultural impact and...

Apache: the Definitive Guide (With CD-ROM)

O'Reilly, 1999

Apache: The Definitive Guide is principally about the Apache web server software.
We explain what a web server is and how it works, but our assumption is that
most of our readers have used the World Wide Web and understand in practical
terms how it works, and that they are now thinking about running their own servers
to offer...

PCs Just the Steps For Dummies (Computer/Tech)

For Dummies, 2009

Computers have come a long way in just 20 years or so. They’re now at the heart of the way many people communicate, shop, and learn. They provide useful tools for tracking information, organizing finances, and being creative.

Whether you’re a young person just getting your first computer, or a senior who is finally getting...

Adaptive Learning of Polynomial Networks: Genetic Programming, Backpropagation and Bayesian Methods

Springer, 2006

This book delivers theoretical and practical knowledge for developing algorithms that infer linear and non-linear multivariate models, providing a methodology for inductive learning of polynomial neural network models (PNN) from data. The text emphasizes an organized model identification process by which to discover models that generalize and...