Picture 1 of 1
Picture 1 of 1
Oracle SQL*Plus: The Definitive Guide (Definitive Guides) - Paperback - GOOD
US $4.98
Condition:
Shipping:
Located in: Montgomery, Illinois, United States
Delivery:
Estimated between Mon, May 20 and Fri, May 24 to 43230
Returns:
Payments:
Special financing available. See terms and apply now- for PayPal Credit, opens in a new window or tab
Earn up to 5x points when you use your eBay Mastercard®. Learn moreabout earning points with eBay Mastercard
Shop with confidence
Seller assumes all responsibility for this listing.
eBay item number:276089361932
Item specifics
- Condition
- Brand
- Unbranded
- Book Title
- Oracle SQL*Plus: The Definitive Guide (Definitive Guides)
- MPN
- Does not apply
- ISBN
- 9780596007461
- Publication Name
- Oracle Sql*Plus: the Definitive Guide : the Definitive Guide
- Item Length
- 9.2in
- Publisher
- O'reilly, Incorporated
- Publication Year
- 2004
- Series
- Definitive Guides
- Type
- Textbook
- Format
- Trade Paperback
- Language
- English
- Item Height
- 1.2in
- Item Width
- 7in
- Item Weight
- 34.1 Oz
- Number of Pages
- 582 Pages
About this product
Product Information
Despite its wide availability and usage, few developers and DBAs have mastered the true power of Oracle SQLPlus. 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 SQLPlus--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 query the data dictionary tables customize an SQLPlus 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 SQLPlus. 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.
Product Identifiers
Publisher
O'reilly, Incorporated
ISBN-10
0596007469
ISBN-13
9780596007461
eBay Product ID (ePID)
43443313
Product Key Features
Publication Name
Oracle Sql*Plus: the Definitive Guide : the Definitive Guide
Format
Trade Paperback
Language
English
Publication Year
2004
Series
Definitive Guides
Type
Textbook
Number of Pages
582 Pages
Dimensions
Item Length
9.2in
Item Height
1.2in
Item Width
7in
Item Weight
34.1 Oz
Additional Product Features
Lc Classification Number
Qa76.73.S
Edition Number
2
Table of Content
Preface; Why I Wrote This Book; Objectives of This Book; What's New in the Second Edition?; Which Platform and Version?; Structure of This Book; Obtaining the Scripts and Sample Data; What About Those Names?; Conventions Used in This Book; Using Code Examples; Comments and Questions; Acknowledgments from the First Edition; Second Edition Acknowledgments;Chapter 1: Introduction to SQL*Plus; 1.1 What Is SQL*Plus?; 1.2 History of SQL*Plus; 1.3 Why Master SQL*Plus?; 1.4 Creating and Loading the Sample Tables;Chapter 2: Command-Line SQL*Plus; 2.1 Starting Command-Line SQL*Plus; 2.2 Starting Windows SQL*Plus; 2.3 Some Basic SQL*Plus Commands; 2.4 Running SQL Queries; 2.5 Working with PL/SQL; 2.6 The SQL Buffer; 2.7 Line Editing; 2.8 Executing the Statement in the Buffer; 2.9 Saving and Retrieving the Buffer; 2.10 The EDIT Command; 2.11 Executing a Script; 2.12 The Working Directory;Chapter 3: Browser-Based SQL*Plus; 3.1 Starting iSQL*Plus; 3.2 Executing SQL*Plus Commands; 3.3 Running SQL Queries; 3.4 Working with PL/SQL; 3.5 Executing Scripts; 3.6 iSQL*Plus Command History;Chapter 4: A Lightning SQL Tutorial; 4.1 Data Manipulation Statements; 4.2 Transactions; 4.3 The Concept of Null; 4.4 Table Joins; 4.5 Sorting Query Results; 4.6 Grouping and Summarizing; 4.7 Subqueries; 4.8 Unions; 4.9 To Learn More;Chapter 5: Generating Reports with SQL*Plus; 5.1 Following a Methodology; 5.2 Saving Your Work; 5.3 Designing a Simple Report; 5.4 Master/Detail Reports;Chapter 6: Creating HTML Reports; 6.1 Getting the Data into an HTML Table; 6.2 Generating the Entire Page; 6.3 Another Approach to Headers; 6.4 Master/Detail Reports in HTML;Chapter 7: Advanced Reports; 7.1 Totals and Subtotals; 7.2 Getting the Current Date into a Header; 7.3 Report Headers and Footers; 7.4 Formatting Object Columns; 7.5 Summary Reports; 7.6 Taking Advantage of Unions;Chapter 8: Writing SQL*Plus Scripts; 8.1 Why Write Scripts?; 8.2 Using Substitution Variables; 8.3 Prompting for Values; 8.4 Cleaning Up the Display; 8.5 Executing a Script; 8.6 Controlling Variable Substitution; 8.7 Commenting Your Scripts; 8.8 Resetting Your SQL*Plus Environment; 8.9 Scripting Issues with iSQL*Plus;Chapter 9: Extracting and Loading Data; 9.1 Types of Output Files; 9.2 Limitations of SQL*Plus; 9.3 Extracting the Data; 9.4 An Excel-Specific HTML Hack; 9.5 Reloading the Data;Chapter 10: Exploring Your Database; 10.1 The DESCRIBE Command; 10.2 Oracle's Data Dictionary Views; 10.3 Tables; 10.4 Table Constraints; 10.5 Indexes; 10.6 Triggers; 10.7 Synonyms; 10.8 Table Security; 10.9 Scripting the Data Dictionary; 10.10 Using SQL to Write SQL; 10.11 The Master Key;Chapter 11: Advanced Scripting; 11.1 Bind Variables; 11.2 Branching in SQL*Plus; 11.3 Looping in SQL*Plus; 11.4 Validating and Parsing User Input; 11.5 Error Handling; 11.6 Returning Values to Unix;Chapter 12: Tuning and Timing; 12.1 Using SQL*Plus Timers; 12.2 Using EXPLAIN PLAN; 12.3 Using AUTOTRACE; 12.4 Improving on EXPLAIN PLAN Results; 12.5 Where to Find More Tuning Information;Chapter 13: The Product User Profile; 13.1 What Is the Product User Profile?; 13.2 Using the Product User Profile;Chapter 14: Customizing Your SQL*Plus Environment; 14.1 SQL*Plus Settings You Can Control; 14.2 The Site and User Profiles; 14.3 Environment Variables That Affect SQL*Plus; 14.4 Windows GUI SQL*Plus; 14.5 iSQL*Plus User Preferences;Appendix A: SQL*Plus Command Reference; A.1 The Command to Invoke SQL*Plus; A.2 Commands You Can Issue Within SQL*Plus;Appendix B: SQL*Plus Format Elements; B.1 Formatting Numbers; B.2 Formatting Character Strings; B.3 Formatting Dates;Colophon;
Copyright Date
2004
Target Audience
Scholarly & Professional
Topic
Desktop Applications / Databases, Programming Languages / Sql, General, Data Processing, Databases / General
Lccn
2005-281188
Dewey Decimal
005.13/3
Dewey Edition
22
Illustrated
Yes
Genre
Computers
Item description from the seller
Seller assumes all responsibility for this listing.
eBay item number:276089361932
Shipping and handling
Item location:
Montgomery, Illinois, United States
Ships to:
Canada, Mexico, United States
Excludes:
Africa, Asia, Barbados, Bermuda, Central America and Caribbean, Europe, French Guiana, French Polynesia, Greenland, Guadeloupe, Libya, Martinique, Middle East, New Caledonia, Oceania, Reunion, Russian Federation, Saint Pierre and Miquelon, South America, Southeast Asia, Ukraine, Venezuela
| Shipping and handling | To | Service | Delivery*See Delivery notes |
|---|---|---|---|
| Free shipping | United States | Economy Shipping (USPS Media MailTM) | Estimated between Mon, May 20 and Fri, May 24 to 43230 |
| US $4.95 | United States | Standard Shipping (DGM SmartMail Expedited) | Estimated between Wed, May 22 and Tue, May 28 to 43230 |
| US $10.95 | United States | Expedited Shipping (FedEx 2Day®) | Estimated between Thu, May 16 and Fri, May 17 to 43230 |
| Handling time |
|---|
| Will usually ship within 1 business day of receiving cleared payment. |
| Taxes |
|---|
| Taxes may be applicable at checkout. Learn moreLearn more about paying tax on eBay purchases. |
Return policy
| After receiving the item, contact seller within | Refund will be given as | Return shipping |
|---|---|---|
| 30 days | Money Back | Seller pays for return shipping |
Refer to eBay Return policyopens in a new tab or window for more details. You are covered by the eBay Money Back Guaranteeopens in a new tab or window if you receive an item that is not as described in the listing.
Payment details
Payment methods
Popular categories from this store
Seller feedback (5,882,265)
z***z (602)- Feedback left by buyer.
Past 6 months
Verified purchase
🏆 SUPER STAR 🤩 AMAZING PHOTOS 🎯 ACCURATE DESCRIPTION ✏️ GENUINE PRODUCTS 💎 HIGH QUALITY 🍯 SUPER PRICES 💰 EASY TO WORK WITH 🍰 ECONOMY HANDLING ⏱️ FAST SHIPPING 🚀 BUBBLE PACKAGE 📦 ARRIVED WITHIN DAYS 🌎 EXCEPTIONAL COMMUNICATION 🎙️ OUTSTANDING CUSTOMER SERVICE 🛎️ GREAT SENSE OF HUMOR 🍿 TOTAL ASSET TO THE EBAY-ECO SYSTEM 🥇 SAVED SELLER 🎱 PROMT REPLY FOR RETURNS 🎯 WOULD BUY FROM AGAIN 🧲 UNDER PROMISES OVER DELIVERS ⛳️ MADE ME VERY HAPPY 🌈 LEFT POSITIVE FEEDBACK 🌼 THANK YOU! 😇 A+++
n***e (402)- Feedback left by buyer.
Past 6 months
Verified purchase
This item didn’t come in exactly as pictured, but the seller responded immediately and was very gracious in offering me a partial refund even bough I wasn’t expecting one for what I paid for the item. I have bought from this seller before, and they are reputable and stand behind the products they sell. My other transactions with them have been perfect. Great communication. Packaging and price were good. Fairly fast shipping, too. Thanks.
e***r (2641)- Feedback left by buyer.
Past 6 months
Verified purchase
This item came in exactly as pictured, and the seller posted immediately and was very gracious. I didn't ask for a partial refund. Why would I? I bought what I was expecting and received what I paid for the item. Not sure if I have bought from this seller before, but they are reputable and stand behind the products they sell. My future transactions with them will no doubt be perfect. Great communication. Packaging and price were good. Fairly fast shipping, too. Thanks.
Product ratings and reviews
More to explore :
- Study Guide Study Paperbacks Prep,
- Paperback Study Guides & Test Prep,
- Nonfiction Travel Guide Paperbacks Books,
- Insight Guides Nonfiction Paperbacks Books,
- Paperback Study Guides & Test Prep Croatian,
- Paperback Study Guides & Test Prep in Spanish,
- Paperback Study Guides & Test Prep in Japanese,
- Christianity Paperback Study Guides & Test Prep,
- Paperback Study Guides & Test Prep in Korean,
- Sociology Paperback Study Guides & Test Prep