Fr. 55.50

Oracle SQL Plus - The Definitive Guide. The Number 1 Book for SQL Plus Solutions & Syntax

English · Paperback / Softback

Shipping usually within 3 to 5 weeks

Description

Read more

Despite its wide availability and usage, few developers and DBAs have mastered the true power of Oracle SQL Plus. This bestselling book--now updated for Oracle 10g--is the only in-depth guide to this interactive query tool for writing SQL scripts. It's an essential resource for any Oracle user.The new second edition of Oracle SQL Plus: The Definitive Guide clearly describes how to perform, step-by-step, all of the tasks that Oracle developers and DBAs want to perform with SQL Plus--and maybe some you didn't realize you could perform.WithOracle SQL Plus: The Definitive Guide, you'll expertly: write and execute script files generate ad hoc reports extract data from the database query the data dictionary tables customize an SQL Plus environment and much moreIt also includes a handy quick reference to all of its syntax options and an often-requested chapter on SQL itself, along with a clear, concise, and complete introduction.This book is truly the definitive guide to SQL Plus. It's an indispensable resource for those who are new to SQL Plus, a task-oriented learning tool for those who are already using it, and an immediately useful quick reference for every user. If you want to leverage the full power and flexibility of this popular Oracle tool, you'll need this book.

List of contents













  • Preface




  • Chapter 1: Introduction to SQL*Plus




  • Chapter 2: Command-Line SQL*Plus




  • Chapter 3: Browser-Based SQL*Plus




  • Chapter 4: A Lightning SQL Tutorial




  • Chapter 5: Generating Reports with SQL*Plus




  • Chapter 6: Creating HTML Reports




  • Chapter 7: Advanced Reports




  • Chapter 8: Writing SQL*Plus Scripts




  • Chapter 9: Extracting and Loading Data




  • Chapter 10: Exploring Your Database




  • Chapter 11: Advanced Scripting




  • Chapter 12: Tuning and Timing




  • Chapter 13: The Product User Profile




  • Chapter 14: Customizing Your SQL*Plus Environment




  • Appendix A: SQL*Plus Command Reference




  • Appendix B: SQL*Plus Format Elements




  • Colophon




About the author

Jonathan amassed some 17 years of programming and database management experience. During the latter part of his career he specialized in relational database programming, and more recently in database management. Jonathan got his start with relational database systems in1990, first working with Ingres, and later with Digital's Rdb software. During that period he developed a fondness for SQL, and for the challenge of applying SQL creatively inways that leveraged it's set-oriented capabilities. In 1994 Jonathan made the leap to Oracle, and is now often found writing about it. Jonathan is certified as an Oracle DBA and is a member of MENSA and the Oracle Technology Network. He holds a Bachelor of Arts degree in Information and Computer Science, with a Business Administration minor, from Andrews University in Berrien Springs, Michigan.

Summary

Updated for Oracle 10g, this guide to SQL*Plus describes how to perform, step-by-step, all of the tasks that Oracle developers and DBAs want to perform with SQL*Plus--and maybe some you didn't realize you could perform. If you want to leverage of the full power and flexibility of this popular Oracle tool, this book is a useful resource.

Product details

Authors Jonathan Gennick, Gennick Jonathan
Publisher O'Reilly Media
 
Languages English
Product format Paperback / Softback
Released 01.01.2004
 
EAN 9780596007461
ISBN 978-0-596-00746-1
No. of pages 554
Weight 840 g
Illustrations w. figs.
Series Definitive Guide
Definitive Guide
Definitive Guides
Subjects Natural sciences, medicine, IT, technology > IT, data processing > IT
Natural sciences, medicine, IT, technology > IT, data processing > Programming languages

Definitive Guide, Oracle SQL*Plus, Database Software

Customer reviews

No reviews have been written for this item yet. Write the first review and be helpful to other users when they decide on a purchase.

Write a review

Thumbs up or thumbs down? Write your own review.

For messages to CeDe.ch please use the contact form.

The input fields marked * are obligatory

By submitting this form you agree to our data privacy statement.