My Wish Lists Login / Join

Oracle Database 10g PL/SQL 101

By: Christopher Allen

Write A Review

Paperback | 31 August 2004 | Edition Number 1

At a Glance

Paperback
416 Pages

Dimensions(cm)
22.86 x 18.54 x 2.18

Paperback

RRP $77.95

$76.99

or 4 interest-free payments of $19.25 with

Ships in 5 to 10 business days

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 10g 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

Shipping

	Standard Shipping	Express Shipping
Metro postcodes:	$9.99	$14.95
Regional postcodes:	$9.99	$14.95
Rural postcodes:	$9.99	$14.95

Orders over $79.00 qualify for free shipping.

How to return your order

At Booktopia, we offer hassle-free returns in accordance with our returns policy. If you wish to return an item, please get in touch with Booktopia Customer Care.

Additional postage charges may be applicable.