Oracle Database 10g PL/SQL 101 1ED

by Allen

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. Learn to use SQL and PL/SQL in your Oracle database. Get step-by-step details on performing database tasks quickly and easily. Oracle PL/SQL 101 explains how to use SQL to work with data in a database,and how to automate complicated tasks using PL/SQL. You'll learn by doing—each chapter contains hands-on exercises designed to teach the concepts presented. This easy-to-follow book starts with database basics and then teaches how to store,retrieve,and manipulate data,control SQL*Plus,create and use SQL functions,and write PL/SQL programs. Understand the key components of a database—tables,rows,records,columns,and fields Create database tables,indexes,and constraints Write SQL commands to insert,select,update,and delete data Perform advanced data manipulation Write complete PL/SQL functions and procedures Declare variables using anchored types Create PL/SQL packages Use triggers to enforce complex business rules and security measures

Paperback

First published December 1, 2000

Reviews

[Carol K · Rating 4 out of 5]

Very good story, complex and exciting plot. Lots of unexpected twists and turns, right to the end, but not too hard to follow. Again, I enjoyed the short chapters which keep drawing you on. Certainly worth reading.