Warriors 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


    Q&A | May 20, 2015

    Michael Perry: IMG Powell's Q&A: Michael Perry



    Describe your latest book. On Christmas Eve itself, the bachelor Harley Jackson stepped into his barn and beheld there illuminated in the straw a... Continue »
    1. $18.19 Sale Hardcover add to wish list

      The Jesus Cow

      Michael Perry 9780062289919

    spacer
Qualifying orders ship free.
$45.00
New Trade Paper
Ships in 1 to 3 days
Add to Wishlist
available for shipping or prepaid pickup only
Available for In-store Pickup
in 7 to 12 days
Qty Store Section
25 Remote Warehouse Database- Design

Oracle Database 10g PL/SQL 101

by

Oracle Database 10g PL/SQL 101 Cover

 

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.

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.

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

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

Other books you might like

  1. Oracle Database 10g SQL (Oracle Press) Used Trade Paper $6.95
  2. Beginning VB 2005 Used Trade Paper $19.50
  3. Jewelry Making & Beading for Dummies... Used Trade Paper $11.50
  4. Harry Potter and the Sorcerer's Stone
    Used Trade Paper $5.00

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
0 stars - 0 reviews
$45.00 In Stock
Product details 395 pages McGraw-Hill/Osborne Media - English 9780072255409 Reviews:
"Synopsis" by , 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 , 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.

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.