Oracle PL/SQL 101

From the Publisher: 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