Oracle Database 10g PL/SQL 101 (Oracle Press): Learn Oracle SQL and PL/SQL with This Step-by-Step Entry-Level Guide - Softcover

Buch 25 von 135: Oracle Press

Allen, Christopher

 
9780072255409: Oracle Database 10g PL/SQL 101 (Oracle Press): Learn Oracle SQL and PL/SQL with This Step-by-Step Entry-Level Guide
Softcover
ISBN 10: 0072255404 ISBN 13: 9780072255409
Verlag: McGraw-Hill Osborne Media, 2004

Inhaltsangabe

Obtain the solid foundation you need to become an effective database programmer with this nuts-and-bolts PS/SQL book from Oracle Press. Step-by-step coverage includes storing, retrieving, and manipulating data, and a broad range of SQL and PL/SQL functions and tools. Real-life examples and hands-on projects help you see how to apply what you have learned.

Die Inhaltsangabe kann sich auf eine andere Ausgabe dieses Titels beziehen.

Über die Autorin bzw. den Autor

Christopher Allen (Santa Monica, CA) has provided data expertise to organizations such as IBM, Microsoft, Amgen, the California Institute of Technology, the Department of Justice, Universal Studios, and Dell. He has designed and built hundreds of custom applications, and has taught over a thousand computer classes for professionals. He is an Oracle Certified Professional DBA and Application Developer.

Von der hinteren Coverseite

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 diesen Titel“ kann sich auf eine andere Ausgabe dieses Titels beziehen.

Verlag
McGraw-Hill Osborne Media
Erscheinungsdatum
2004
Sprache
Englisch
ISBN 10 
0072255404
ISBN 13 
9780072255409
Einband
Taschenbuch
Anzahl der Seiten
416
Kontakt zum Hersteller
Nicht verfügbar
Verantwortliche Person
Nicht verfügbar

Weitere beliebte Ausgaben desselben Titels

9780070593879: ORACLE DATABASE 10G PL/SQL 101

Vorgestellte Ausgabe

ISBN 10:  0070593876 ISBN 13:  9780070593879
Verlag: McGraw-Hill, 2004
Softcover