Star Wars Sale
 
 

Special Offers see all

Enter to WIN!

Weekly drawing for $100 credit. Subscribe to PowellsBooks.news for a chance to win.
Privacy Policy

More at Powell's


Recently Viewed clear list


Original Essays | June 20, 2014

Lauren Owen: IMG The Other Vampire



It's a wild and thundery night. Inside a ramshackle old manor house, a beautiful young girl lies asleep in bed. At the window, a figure watches... Continue »
  1. $18.90 Sale Hardcover add to wish list

    The Quick

    Lauren Owen 9780812993271

spacer
Qualifying orders ship free.
$23.00
Used Trade Paper
Ships in 1 to 3 days
Add to Wishlist
Qty Store Section
1 Beaverton Database- Applications

Oracle PLSQL 101

by

Oracle PLSQL 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.

Other books you might like

  1. Oracle Certified Professional... Used Hardcover $48.00
  2. Oracle PL/SQL Built-Ins Pocket Reference
    Used Trade Paper $1.00
  3. Oracle PL/SQL Programming... New Trade Paper $54.95
  4. Body Language Secrets: A Guide... Used Trade Paper $5.95
  5. Oracle PL/SQL Interactive Workbook Used Trade Paper $3.25
  6. Oracle Dba 101 Used Trade Paper $5.95

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 PLSQL 101 Used Trade Paper
0 stars - 0 reviews
$23.00 In Stock
Product details 416 pages MCGRAW HILL COMPANIES - 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.