ORACLE PL/SQL 101 (Oracle Press) - Softcover

Allen, Christopher

Softcover

ISBN 10: 007212606X ISBN 13: 9780072126068

Publisher: McGraw-Hill Education, 2000

Synopsis

SQL is the industry standard for interacting with enterprise-level databases. SQL commands allow users to manipulate database records -- insert, modify, and delete, and so on. DBAs, developers and savvy financial analysts use SQL to access and analyse information on their corporate database. PL/SQL is the Oracle version of SQL and provides the ability to write powerful, flexible programs to quickly perform and automate a multitude of database tasks. This book provides a fresh and approachable introduction to Oracle PL/SQL.

About this title

About the Author

Christopher Allen (Santa Monica, CA) has been a database professional for almost 20 ears. He is an OCP DBA and an OCP Application Developer and has worked on numerous Oracle Financials implementations. In addition, he has taught several hundred computer classes to adults, resulting in extensive experience communicating technical information in ways that are easy to absorb and easy to remember. His published works include the Oracle Certified Professional Application Developer Exam Guide (co-author, Oracle Press), Hard Disk Smarts (John Wiley Publishing), and four books on Lotus (Que). He also served as technical editor for Microsoft's DOS 5 and DOS 6 manuals. He is currently employed at Metier, an Oracle partner company that provides consulting services in the Los Angeles area.

From the Back Cover

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

Edition details

• Publisher: McGraw-Hill Education
• Publication date: 2000
• Language: English
• ISBN 10: 007212606X
• ISBN 13: 9780072126068
• Binding: Paperback
• Number of pages: 420