Magnificent Marvel Supersale
 
 

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 | March 24, 2015

    Judith Claire Mitchell: IMG The Book That Refused to Write Itself



    I first heard of Fritz Haber in 1998, when I caught a snippet of a TV documentary about 20th-century scientists. The camera zoomed in on an image of... Continue »

    spacer

This item may be
out of stock.

Click on the button below to search for this title in other formats.


Check for Availability
Add to Wishlist

Oracle Database 10g PL/SQL 101

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

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:

This in-depth guide explains how to use SQL to work with data in a database, and how to automate complicated tasks using PL/SQL.

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:
9780072126068
Author:
Allen, Christopher
Publisher:
McGraw-Hill Osborne Media McGraw-Hill Osborne Media
Location:
Berkeley, Calif.
Subject:
Programming Languages - SQL
Subject:
Database Management - General
Subject:
Technical Skills
Subject:
Database Management - Oracle
Subject:
PL/SQL (Computer program language)
Subject:
Oracle
Subject:
SQL
Subject:
PL/SQL
Subject:
Certification - General
Subject:
Certification Guides - General
Subject:
PL/SQL,SQL,database,Oracle,automate complicated tasks,advanced data manipulation,SQL functions,basics,constraints,indexes,Controlling SQL Plus,performing database tasks
Copyright:
Edition Number:
1
Series:
Osborne ORACLE Press Series
Series Volume:
104-56
Publication Date:
20001201
Binding:
Paperback
Grade Level:
Professional and scholarly
Language:
English
Illustrations:
Yes
Pages:
416
Dimensions:
9.26x7.20x1.18 in. 1.95 lbs.

Related Subjects

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

Oracle Database 10g PL/SQL 101
0 stars - 0 reviews
$ In Stock
Product details 416 pages McGraw-Hill Osborne Media McGraw-Hill Osborne Media - English 9780072126068 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 , This in-depth guide explains how to use SQL to work with data in a database, and how to automate complicated tasks using PL/SQL.
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.