Oracle Pl/SQL 101

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. Youll 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. bull; bull;Understand the key components of a database--tables, rows, records, columns, and fields bull;Create database tables, indexes, and constraints bull;Write SQL commands to insert, select, update, and delete data bull;Perform advanced data manipulation bull;Write complete PL/SQL functions and procedures bull;Declare variables using anchored types bull;Create PL/SQL packages bull;Use triggers to enforce complex business rules and security measuresAllen, Christopher is the author of 'Oracle Pl/SQL 101' with ISBN 9780072126068 and ISBN 007212606X.