Oracle SQL*Plus: The Definitive Guide by Jonathan Gennick (English) Paperback Bo

Description: FREE SHIPPING UK WIDE Oracle SQL*Plus by Jonathan Gennick Updated for Oracle 10g, this in-depth guide to SQL*Plus clearly describes how to perform, step-by-step, all of the tasks that Oracle developers and DBAs want to perform with SQL*Plus. If you want to leverage of the full power and flexibility of this popular Oracle tool, this title should be a useful resource. FORMAT Paperback LANGUAGE English CONDITION Brand New Publisher Description This book is truly the definitive guide to SQL*Plus. Its 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, youll need this book. Author Biography Jonathan Gennick is an OReilly & Associates editor specializing in database and programming titles. Prior to joining OReilly, 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 in 1990, first working with Ingres, and later with Digitals Rdb software. During that period he developed a fondness for SQL, and for the challenge of applying SQL creatively in ways that leveraged its set-oriented capabilities. In 1994 Jonathan made the leap to Oracle, and is now often found writing about it. Recent projects include Oracle SQL*Loader (OReilly & Associates, 2001); Oracle SQL*Plus Pocket Reference (OReilly & Associates, 2000); Oracle SQL*Plus: The Definitive Guide (OReilly & Associates, 1999); More recently, Jonathan has made forays into other database products, coauthoring Transact-SQL Cookbook (OReilly & Associates, 2002) and editing Practical PostgreSQL (OReilly & Associates, 2002). 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. Jonathan currently resides in Munising, Michigan with his wife Donna and their two children: Jenny and Jeff. Table of Contents Preface 1. Introduction to SQL*Plus What Is SQL*Plus? History of SQL*Plus Why Master SQL*Plus? Creating and Loading the Sample Tables 2. Command-Line SQL*Plus Starting Command-Line SQL*Plus; Starting Windows SQL*Plus Some Basic SQL*Plus Commands Running SQL Queries Working With PL/SQL The SQL Buffer Line Editing Executing the Statement in the Buffer Saving and Retrieving the Buffer The EDIT Command Executing a Script; The Working Directory 3. Browser-Based SQL*Plus Starting iSQL*Plus Executing SQL*Plus Commands Running SQL Queries; Working with PL/SQL Executing Scripts iSQL*Plus Command History 4. A Lightning SQL Tutorial Data Manipulation Statements Transactions The Concept of Null Table Joins; Sorting Query Results Grouping and Summarizing Subqueries; Unions To Learn More 5. Generating Reports with SQL*Plus; Following a Methodology Saving Your Work Designing a Simple Report Master/Detail Reports 6. Creating HTML Reports; Getting the Data into an HTML Table Generating the Entire Page; Another Approach to Headers Master/Detail Reports in HTML; 7. Advanced Reports Totals and Subtotals Getting the Current Date into a Header Report Headers and Footers Formatting Object Columns Summary Reports Taking Advantage of Unions; 8. Writing SQL*Plus Scripts Why Write Scripts? Using Substitution Variables Prompting for Values Cleaning Up the Display Executing a Script Controlling Variable Substitution; Commenting Your Scripts Resetting Your SQL*Plus Environment; Scripting Issues with iSQL*Plus 9. Extracting and Loading Data; Types of Output Files Limitations of SQL*Plus Extracting the Data An Excel-Specific HTML Hack Reloading the Data 10. Exploring Your Database The DESCRIBE Command Oracles Data Dictionary Views Tables Table Constraints Indexes; Triggers Synonyms Table Security Scripting the Data Dictionary; Using SQL to Write SQL The Master Key 11. Advanced Scripting; Bind Variables Branching in SQL*Plus Looping in SQL*Plus; Validating and Parsing User Input Error Handling Returning Values to Unix 12. Tuning and Timing Using SQL*Plus Timers; Using EXPLAIN PLANstatements Using AUTOTRACE Improving on EXPLAIN PLAN Results Where to Find More Tuning Information; 13. The Product User Profile What Is the Product User Profile?; Using the Product User Profile 14. Customizing Your SQL*Plus Environment SQL*Plus Settings You Can Control The Site and User Profiles Environment Variables That Affect SQL*Plus Windows GUI SQL*Plus iSQL*Plus User Preferences A. SQL*Plus Command Reference B. SQL*Plus Format Elements Index Long Description 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. Its 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 didnt realize you could perform. With "Oracle SQL*Plus: The Definitive Guide, youll 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 more It 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. Its 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, youll need this book. Details ISBN0596007469 Author Jonathan Gennick Publisher OReilly Media Language English Edition 2nd ISBN-10 0596007469 ISBN-13 9780596007461 Media Book Format Paperback Year 2004 Country of Publication United States Place of Publication Sebastopol Short Title ORACLE SQL-PLUS 2ND/E 2/E Series Definitive Guide Residence Lansing, MI, US DOI 10.1604/9780596007461 Subtitle The Definitive Guide UK Release Date 2004-12-07 AU Release Date 2004-12-07 NZ Release Date 2004-12-07 Imprint OReilly Media Edited by Fu-Chan Wei Birth 1945 Affiliation Consultant Urological Surgeon, Royal Bournemouth Hospital, and Visiting Professor, Bournemouth University, Bournemouth, UK Position Contributor Qualifications MD Pages 560 Edition Description 2nd ed. DEWEY 005.7565 Illustrations Illustrations Audience Professional & Vocational Publication Date 2004-12-21 US Release Date 2004-12-21 We've got this At The Nile, if you're looking for it, we've got it. With fast shipping, low prices, friendly service and well over a million items - you're bound to find what you want, at a price you'll love! 30 DAY RETURN POLICY No questions asked, 30 day returns! FREE DELIVERY No matter where you are in the UK, delivery is free. SECURE PAYMENT Peace of mind by paying through PayPal and eBay Buyer Protection TheNile_Item_ID:161840875;

Price: 38.99 GBP

Location: London

End Time: 2024-11-03T15:51:10.000Z

Shipping Cost: 5.49 GBP