$37.75

New Trade Paper

Ships in 1 to 3 days

available for shipping or prepaid pickup only

Available for In-store Pickup
in 7 to 12 days

Qty	Store	Section
1	Remote Warehouse	Database- Design

Receive an email when this ISBN is available used.

Oracle Database 10g PL/SQL 101

by Christopher Allen

Comment on this title and you could win free books! Synopses & Reviews Table of Contents Comment on this title and you could win free books! ISBN13: 9780072255409 ISBN10: 0072255404 Condition: All Product Details Only 1 left in stock at $37.75!

 

Synopses & Reviews

Publisher Comments:

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. Youll 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

Book News Annotation:

Written for the beginner who has access to SQL*Plus, this guide describes the structure of a database, introduces SQL commands for entering data, and explains Oracle indexes, constraints, and relationships between tables. The final section covers the programming language for SQL (PL/SQL) that allows more sophisticated information processing, such as call functions and procedures, cursors, and triggers.
Annotation ©2005 Book News, Inc., Portland, OR (booknews.com)

Book News Annotation:

Written for the beginner who has access to SQL*Plus, this guide describes the structure of a database, introduces SQL commands for entering data, and explains Oracle indexes, constraints, and relationships between tables. The final section covers the programming language for SQL (PL/SQL) that allows more sophisticated information processing, such as call functions and procedures, cursors, and triggers. Annotation ©2005 Book News, Inc., Portland, OR (booknews.com)

Synopsis:

Obtain the solid foundation you need to become an effective database programmer with this nuts-and-bolts PS/SQL book from Oracle Press. Step-by-step coverage includes storing, retrieving, and manipulating data, and a broad range of SQL and PL/SQL functions and tools. Real-life examples and hands-on projects help you see how to apply what you have learned.

Synopsis:

The only official Oracle entry-level book on PL/SQL, this guide is easy to understand with solid technical depth. The tutorial approach includes such elements as glossaries, step-by-step examples and quizzes. It covers everything contained in an introductory course to Oracle's SQL and PL/SQL and more. 50 illustrations.

back to top

About the Author

Christopher Allen (Santa Monica, CA) has been a database professional for almost 20 ears. He is an OCP DBA and an OCP Application Developer and has worked on numerous Oracle Financials implementations. In addition, he has taught several hundred computer classes to adults, resulting in extensive experience communicating technical information in ways that are easy to absorb and easy to remember. His published works include the Oracle Certified Professional Application Developer Exam Guide (co-author, Oracle Press), Hard Disk Smarts (John Wiley Publishing), and four books on Lotus (Que). He also served as technical editor for Microsoft's DOS 5 and DOS 6 manuals. He is currently employed at Metier, an Oracle partner company that provides consulting services in the Los Angeles area.

back to top

Table of Contents

PART I Database Basics

1 Introduction to Databases

2 Storing and Retrieving Data: The Basics

3 Advanced Data Manipulation

4 Controlling SQL*Plus

PART II Advanced SQL

5 SQL Functions

6 Using Indexes and Constraints

7 Other Useful Oracle Techniques

PART III Create Programs Using PL/SQL

8 Introduction to PL/SQL

9 More PL/SQL ToolsGlossary of Common Oracle Terms

back to top

What Our Readers Are Saying

Be the first to add a comment for a chance to win!

back to top

Product Details

ISBN:

9780072255409

Author:

Allen, Christopher

Publisher:

McGraw-Hill/Osborne Media

Subject:

Programming Languages - SQL

Subject:

Database Management - General

Subject:

Database Management - Oracle

Subject:

PL/SQL (Computer program language)

Subject:

Database design

Copyright:

2004

Edition Number:

1

Series:

Osborne ORACLE Press Series

Publication Date:

August 2004

Binding:

TRADE PAPER

Grade Level:

Professional and scholarly

Language:

English

Illustrations:

Y

Pages:

395

Dimensions:

9.12x7.38x.89 in. 1.49 lbs.

back to top

Other books you might like

1. 
   Oracle Database 10G SQL (04 Edition) Price Used Trade Paper $26.00
   
2. 
   Beginning VB 2005 Thearon Willis Used Trade Paper $19.50
   
3. 
   Jewelry Making & Beading for Dummies... Heather Dismore Used Trade Paper $13.95
   
4. 
   Harry Potter and the Sorcerer's Stone J.K. Rowling

   

   Used Hardcover $3.50
   
5. 
   Harry Potter and the Goblet of Fire... J. K. Rowling

   

   Used Trade Paper $4.50
   
6. 
   Beginning PHP 5 and MySQL: From... J W Gilmore

   

   Used Trade Paper $18.95
   

Related Subjects

Computers and Internet » Computer Languages » SQL
Computers and Internet » Database » Design
Computers and Internet » Database » SQL
Computers and Internet » Software Engineering » Software Management

Oracle Database 10g PL/SQL 101 New Trade Paper Christopher Allen

0 stars - 0 reviews

$37.75 In Stock

Product details 395 pages McGraw-Hill/Osborne Media - 2004-08-00 English 9780072255409 Reviews:

"Synopsis" by McGraw, Obtain the solid foundation you need to become an effective database programmer with this nuts-and-bolts PS/SQL book from Oracle Press. Step-by-step coverage includes storing, retrieving, and manipulating data, and a broad range of SQL and PL/SQL functions and tools. Real-life examples and hands-on projects help you see how to apply what you have learned.

"Synopsis" by Libri, The only official Oracle entry-level book on PL/SQL, this guide is easy to understand with solid technical depth. The tutorial approach includes such elements as glossaries, step-by-step examples and quizzes. It covers everything contained in an introductory course to Oracle's SQL and PL/SQL and more. 50 illustrations.