Oracle Database 10g PL/SQL 101

Oracle Database 10g PL/SQL 101

Learn Oracle SQL and PL/SQL With This Step-by-step, Entry-level Guide

Book - 2004
Rate this:

Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product.

Get The Ins-and-Outs of SQL and PL/SQL From an Oracle Expert

Perform database functions quickly and easily using the comprehensive information in this step-by-step guide. Oracle professional Christopher Allen begins with database basics and progresses to plain-language explanations and real-world examples of SQL statements and PL/SQL programs. You'll learn how to manage, query, and manipulate data, use SQL*Plus, create SQL functions, and write practical PL/SQL applications. Review questions, chapter summaries, and hands-on projects will have you understanding and exploiting the powerful features of Oracle Database 10 g in no time.

Create tables, rows, records, columns, and fields Store text, numbers, dates, pictures, and soundfiles in tables and columns Define, manipulate, retrieve, and delete data, using SQL commands Select, sort, and filter records with SQL functions and procedures Write SQL commands to declare variables using anchored types Use SAVEPOINT and ROLLBACK commands to ensure multilevel undo Perform time-based and hierarchical data queries Edit and reuse commands in script files, using the SQL*Plus program Use PL/SQL views, sequences, procedures, functions, and packages Use triggers to automate auditing, security, and maintenance tasks
Publisher: New York : McGraw-Hill/Osborne, 2004
ISBN: 9780072255409
Branch Call Number: QA76.9.D3 A664 2004x
Characteristics: xv, 395 p. : ill. ; 24 cm


From the critics

Community Activity


Add a Comment

There are no comments for this title yet.


Add Age Suitability

There are no ages for this title yet.


Add a Summary

There are no summaries for this title yet.


Add Notices

There are no notices for this title yet.


Add a Quote

There are no quotes for this title yet.

Explore Further

Browse by Call Number


Subject Headings


Find it at BPL

To Top