Summer Reading B2G1 Free
 
 

Special Offers see all

Enter to WIN a $100 Credit

Subscribe to PowellsBooks.news
for a chance to win.
Privacy Policy

Visit our stores


    Recently Viewed clear list


    Original Essays | July 15, 2015

    Frank Wilczek: IMG You Are... Who?



    Writing a book is an unnatural act of communication. Speaking to a person, or even to an audience, is an interaction. Very different styles are... Continue »
    1. $20.97 Sale Hardcover add to wish list

    spacer
Qualifying orders ship free.
$0.50
Used Trade Paper
Ships in 1 to 3 days
Add to Wishlist
Qty Store Section
1 Local Warehouse Database- Applications

Oracle PL/SQL Built-Ins Pocket Reference

by

Oracle PL/SQL Built-Ins Pocket Reference Cover

ISBN13: 9781565924567
ISBN10: 1565924568
Condition: Standard
All Product Details

Only 1 left in stock at $0.50!

 

Synopses & Reviews

Publisher Comments:

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.

Synopsis:

This companion quick reference to Steven Feuerstein's "Oracle PL/SQL Programming" and "Oracle Built-in Packages" should help users with Oracle's extensive set of built-in functions and packages, including those new to Oracle8.

Synopsis:

This companion quick reference to Steven Feuerstein's bestselling "Oracle PL/SQL Programming and "Oracle Built-in Packages will helpyou use Oracle's extensive set of built-in functions and packages, including those new to Oracle8.Built-in functions offer the most essential and commonly used operations for PL/SQL development; SUBSTR, TO_DATE, and ADD_MONTHSare just a few of the dozens of functions covered here. Built-in packagesgreatly expand the capabilities of the PL/SQL language. DBMS_SQL, forexample, executes dynamically constructed queries, DDL statements, andeven PL/SQL blocks. In addition to DBMS_SQL, this book covers DBMS_PIPE, DBMS_LOB, UTL_FILE, and many more.This easy-to-access reference shows how to call each of the built-infunctions and packaged programs and how to identify those programsthat can be executed from within an SQL statement. The authors alsosupplement the calling syntax with the exceptions, constants, anddata structures defined in the packages.

Synopsis:

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.

About the Author

Chip Dawes is an OCP and has worked with Oracle databases since 1990. He is a consultant with D&D Technologies and frequently presents at various Oracle User Group conferences. Biju Thomas, OCP, has over 7 years of Oracle database management and application development experience. He currently works as a Database Administrator Consultant for Burlington Resources in Fort Worth, TX. Both authors contributed to OCP: Oracle8i DBA SQL Study Guide.
Steven Feuerstein is considered one of the world's leading experts on the Oracle PL/SQL language. He is the author or coauthor of Oracle PL/SQL Programming, Oracle PL/SQL Best Practices, Oracle PL/SQL Programming: Guide to Oracle8i Features, Oracle PL/SQL Developer's Workbook, Oracle Built-in Packages, Advanced Oracle PL/SQL Programming with Packages, and several pocket reference books (all from O'Reilly and Associates). Steven is a Senior Technology Advisor with Quest Software, has been developing software since 1980, and worked for Oracle Corporation from 1987 to 1992.

Table of Contents

CopyrightChapter 1: Oracle PL/SQL Built-ins Pocket Reference

What Our Readers Are Saying

Add a comment for a chance to win!
Average customer rating based on 1 comment:

nidhinkrishnan, June 26, 2007 (view all comments by nidhinkrishnan)
This Book is excellentm, will help to execute the understanding in live projects
Was this comment helpful? | Yes | No
(2 of 4 readers found this comment helpful)

Product Details

ISBN:
9781565924567
Editor:
Russell, Debby
Author:
Beresniewicz, John
Author:
Feuerstein, Steven
Author:
Dawes, Chip
Publisher:
O'Reilly Media
Subject:
Programming Languages - General
Subject:
Programming - General
Subject:
Operating Systems - General
Subject:
Computers
Subject:
Database Management - General
Subject:
Relational databases
Subject:
Computer software
Subject:
Sql (computer program language)
Subject:
Database Management - Oracle
Subject:
Oracle (computer system)
Subject:
Pl-1 (computer program language)
Subject:
Computer Books And Software
Subject:
Microcomputer Programming
Subject:
Computer Books: Database
Subject:
DBMS_OUTPUT;DBMS_SQL;Oracle;PL/SLQ
Subject:
General Computers
Copyright:
Edition Number:
1
Edition Description:
Print PDF
Series:
O'Reilly Oracle
Publication Date:
19981030
Binding:
Paperback
Language:
English
Pages:
78
Dimensions:
7.02x4.28x.23 in. .16 lbs.

Other books you might like

  1. Applying RCS and SCCS (Nutshell... Used Trade Paper $12.50
  2. Oracle8i Web Development Used Trade Paper $0.50
  3. Oracle Scripts with CDROM Used Trade Paper $1.98
  4. Lego Mindstorms Robots Used Trade Paper $7.50
  5. Oracle8i: Networking 101 Used Trade Paper $1.25

Related Subjects

Computers and Internet » Database » Applications

Oracle PL/SQL Built-Ins Pocket Reference Used Trade Paper
0 stars - 0 reviews
$0.50 In Stock
Product details 78 pages O'Reilly & Associates - English 9781565924567 Reviews:
"Synopsis" by , This companion quick reference to Steven Feuerstein's "Oracle PL/SQL Programming" and "Oracle Built-in Packages" should help users with Oracle's extensive set of built-in functions and packages, including those new to Oracle8.
"Synopsis" by , This companion quick reference to Steven Feuerstein's bestselling "Oracle PL/SQL Programming and "Oracle Built-in Packages will helpyou use Oracle's extensive set of built-in functions and packages, including those new to Oracle8.Built-in functions offer the most essential and commonly used operations for PL/SQL development; SUBSTR, TO_DATE, and ADD_MONTHSare just a few of the dozens of functions covered here. Built-in packagesgreatly expand the capabilities of the PL/SQL language. DBMS_SQL, forexample, executes dynamically constructed queries, DDL statements, andeven PL/SQL blocks. In addition to DBMS_SQL, this book covers DBMS_PIPE, DBMS_LOB, UTL_FILE, and many more.This easy-to-access reference shows how to call each of the built-infunctions and packaged programs and how to identify those programsthat can be executed from within an SQL statement. The authors alsosupplement the calling syntax with the exceptions, constants, anddata structures defined in the packages.
"Synopsis" by ,

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.

spacer
spacer
  • back to top

FOLLOW US ON...

     
Powell's City of Books is an independent bookstore in Portland, Oregon, that fills a whole city block with more than a million new, used, and out of print books. Shop those shelves — plus literally millions more books, DVDs, and gifts — here at Powells.com.