Oracle Database 10g PL/SQL 101

by Christopher Allen

Part of the Oracle Press series

Item not Available

Description

Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product. Get The Ins-and-Outs of SQL and PL/SQL From an Oracle ExpertPerform database functions quickly and easily using the comprehensive information in this step-by-step guide. Oracle professional Christopher Allen begins with database basics and progresses to plain-language explanations and real-world examples of SQL statements and PL/SQL programs.

You’ll learn how to manage, query, and manipulate data, use SQL*Plus, create SQL functions, and write practical PL/SQL applications.

Review questions, chapter summaries, and hands-on projects will have you understanding and exploiting the powerful features of Oracle Database 10g in no time. Create tables, rows, records, columns, and fieldsStore text, numbers, dates, pictures, and soundfiles in tables and columnsDefine, manipulate, retrieve, and delete data, using SQL commandsSelect, sort, and filter records with SQL functions and proceduresWrite SQL commands to declare variables using anchored typesUse SAVEPOINT and ROLLBACK commands to ensure multilevel undoPerform time-based and hierarchical data queriesEdit and reuse commands in script files, using the SQL*Plus programUse PL/SQL views, sequences, procedures, functions, and packagesUse triggers to automate auditing, security, and maintenance tasks