Oracle PL/SQL 101

Overview

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

Read More