Oracle Database 10g PL/SQL 101 (Oracle Press)

Allen, Christopher

ISBN 10: 0072255404 / ISBN 13: 9780072255409

Verlag: McGraw-Hill Osborne Media, 2004

Beschreibung

Most items will be dispatched the same or the next working day. A copy that has been read but remains in clean condition. All of the pages are intact and the cover is intact and the spine may show signs of wear. The book may have minor markings which are not specifically mentioned.

Bestandsnummer des Verkäufers wbs9774546061

Bibliografische Details

• Titel: Oracle Database 10g PL/SQL 101 (Oracle Press)
• Verlag: McGraw-Hill Osborne Media
• Erscheinungsjahr: 2004
• Sprache: Englisch
• ISBN-10: 0072255404
• ISBN-13: 9780072255409
• Einband: Softcover
• Zustand: Good

Über diesen Titel

Inhaltsangabe

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 Expert

Perform 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 fields
• Store text, numbers, dates, pictures, and soundfiles in tables and columns
• Define, manipulate, retrieve, and delete data, using SQL commands
• Select, sort, and filter records with SQL functions and procedures
• Write SQL commands to declare variables using anchored types
• Use SAVEPOINT and ROLLBACK commands to ensure multilevel undo
• Perform time-based and hierarchical data queries
• Edit and reuse commands in script files, using the SQL*Plus program
• Use PL/SQL views, sequences, procedures, functions, and packages
• Use triggers to automate auditing, security, and maintenance tasks

Über die Autorin bzw. den Autor

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.