Back to home page
|Listed in category:
|
Add to Watchlist
EXTRA 10% OFF 4+ ITEMSSee all eligible items and terms

Picture 1 of 1

Oracle SQL*Plus: The Definitive Guide by Gennick, Jonathan - Picture 1 of 1
Have one to sell?
Sell now

Oracle SQL*Plus: The Definitive Guide by Gennick, Jonathan

by Gennick, Jonathan | PB | VeryGood
ThriftBooks
  • (3578029)
US $4.99
Condition:
Very Good
“Former library book; May have limited writing in cover pages. Pages are unmarked. ~ ”... Read moreabout condition
Breathe easy. Free shipping and returns.
Shipping:
Free Economy Shipping. See detailsfor shipping
Estimated between Thu, May 16 and Mon, May 20 to 43230
Estimated delivery dates - opens in a new window or tab include seller's handling time, origin ZIP Code, destination ZIP Code and time of acceptance and will depend on shipping service selected and receipt of cleared paymentcleared payment - opens in a new window or tab. Delivery times may vary, especially during peak periods.
Located in: Aurora, Illinois, United States
Returns:
30 days returns. Seller pays for return shipping. See details- for more information about returns
Payments:
      
Earn up to 5x points when you use your eBay Mastercard®. Learn moreabout earning points with eBay Mastercard

Shop with confidence

Top Rated Plus
Trusted seller, fast shipping, and easy returns. Learn more- Top Rated Plus - opens in a new window or tab
eBay Money Back Guarantee
Get the item you ordered or your money back. Learn moreeBay Money Back Guarantee - opens new window or tab
Report this item - opens in new window or tab
Seller assumes all responsibility for this listing.
eBay item number:196021017345
Last updated on Mar 24, 2024 20:46:13 PDTView all revisionsView all revisions

Item specifics

Condition
Very Good
A book that does not look new and has been read but is in excellent condition. No obvious damage to the cover, with the dust jacket (if applicable) included for hard covers. No missing or damaged pages, no creases or tears, and no underlining/highlighting of text or writing in the margins. May be very minimal identifying marks on the inside cover. Very minimal wear and tear. See the seller’s listing for full details and description of any imperfections. See all condition definitionsopens in a new window or tab
Seller Notes
“Former library book; May have limited writing in cover pages. Pages are unmarked. ~ ...
Binding
Paperback
Weight
1 lbs
Product Group
Book
IsTextBook
No
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
Author
Jonathan Gennick
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

Author
Jonathan Gennick
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

ThriftBooks

ThriftBooks

99% positive feedback
17.6M items sold
Visit storeContact
Joined Mar 2015
Usually responds within 24 hours

Detailed seller ratings

Average for the last 12 months

Accurate description
4.9
Reasonable shipping cost
5.0
Shipping speed
5.0
Communication
4.9

Popular categories from this store

See allcategories
CollectiblesStampsBooks & MagazinesArtEntertainment MemorabiliaEverything ElseMusical Instruments & GearCoins & Paper MoneyAntiques

Seller feedback (5,180,754)

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+++
The Presentation Secrets of Steve Jobs: How to Be Insanely Great in Front of... (#374136717583)
u***2 (263)- Feedback left by buyer.
Past month
Verified purchase
Outstanding seller. Fair prices that are more than reasonable in this economy. The product is in better condition than described, a true value for my money. Packaged and shipped well shows seller has concern for the products sold to arrive in excellent condition. The seller communicated timely with progress. Highly recommend this seller & will do business again. Thank you!!⭐️⭐️⭐️⭐️⭐️
Fresh from Central Market Cookbook: Favorite Recipes from the Standholders of... (#144082382954)
a***r (325)- Feedback left by buyer.
Past month
Verified purchase
thrift.books is an awesome place to purchase books! excellent communication! often the books arrive in better condition than described. ships very fast & the books arrive quickly! carefully packaged! +AAAAAAAAAA ebay sellers. i highly recommend thrift.books for people wanting to purchase books! reaasonable prices and shipping costs!
Chicken Soup for the Horse Lover's Soul: Inspirational Tales of Passion,... (#143395827460)
See all feedback

Product ratings and reviews

Learn more
Write a review
No ratings or reviews yet
Be the first to write the review.

More to explore :