Skip to content

Oracle SQL*Plus: the Definitive Guide The Definitive Guide

Best in textbook rentals since 2012!

ISBN-10: 0596007469

ISBN-13: 9780596007461

Edition: 2nd 2004

Authors: Jonathan Gennick

List price: $39.95
Blue ribbon 30 day, 100% satisfaction guarantee!
what's this?
Rush Rewards U
Members Receive:
Carrot Coin icon
XP icon
You have reached 400 XP and carrot coins. That is the daily max!

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. With "Oracle SQL*Plus: The Definitive Guide, you'll expertly: write and execute script files generate ad hoc reports extract data from the database …    
Customers also bought

Book details

List price: $39.95
Edition: 2nd
Copyright year: 2004
Publisher: O'Reilly Media, Incorporated
Publication date: 12/7/2004
Binding: Paperback
Pages: 582
Size: 7.05" wide x 9.17" long x 1.24" tall
Weight: 1.826
Language: English

Jonathan Gennick is an O'Reilly & Associates editor specializing in database and programming titles. Prior to joining O'Reilly, 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 Digital's Rdb software. During that period he developed a fondness for SQL, and for the challenge of applying SQL creatively in ways that leveraged it's set-oriented capabilities. In 1994 Jonathan made the leap to Oracle, and is now often found writing…    

Preface
Introduction to SQL
Plus What Is SQL
Plus? History of SQL
Plus Why Master SQL
Plus? Creating and Loading the Sample Tables
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
Browser-Based SQL
Plus Starting iSQL
Plus Executing SQL
Plus Commands Running SQL Queries Working with PL/SQL Executing Scripts iSQL
Plus Command History
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
Generating Reports with SQL
Plus Following a Methodology Saving Your Work Designing a Simple Report Master/Detail Reports
Creating HTML Reports Getting the Data into an HTML Table Generating the Entire Page Another Approach to Headers Master/Detail Reports in HTML
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
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
Extracting and Loading Data Types of Output Files Limitations of SQL
Plus Extracting the Data An Excel-Specific HTML Hack Reloading the Data
Exploring Your Database The DESCRIBE Command Oracle's Data Dictionary Views Tables Table Constraints Indexes Triggers Synonyms Table Security Scripting the Data Dictionary Using SQL to Write SQL The Master Key
Advanced Scripting Bind Variables Branching in SQL
Plus Looping in SQL
Plus Validating and Parsing User Input Error Handling Returning Values to Unix
Tuning and Timing Using SQL
Plus Timers Using EXPLAIN PLANstatements Using AUTOTRACE Improving on EXPLAIN PLAN Results Where to Find More Tuning Information
The Product User Profile What Is the Product User Profile? Using the Product User Profile
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