Mastering Oracle SQL

( 2 )

Overview

If you write programs to run against an Oracle database, you spend a lot of time and mental energy writing queries to return the data your programs need. Knowledge of SQL, and particularly of Oracle's implementation of SQL, is the key to writing good queries in a timely manner. In this book, the authors share their knowledge of Oracle SQL, and show you many creative techniques that you can use to advantage in ...

See more details below
Available through our Marketplace sellers.
See All Options
Other sellers (Paperback)
  • All (15) from $1.99   
  • New (4) from $28.99   
  • Used (11) from $1.99   
Close
Sort by
Page 1 of 1
Showing All
Note: Marketplace items are not eligible for any BN.com coupons and promotions
$28.99
surplus computer books
Seller since 2008

Feedback rating:

(156)

Condition:

New — never opened or used in original packaging.

Like New — packaging may have been opened. A "Like New" item is suitable to give as a gift.

Very Good — may have minor signs of wear on packaging but item works perfectly and has no damage.

Good — item is in good condition but packaging may have signs of shelf wear/aging or torn packaging. All specific defects should be noted in the Comments section associated with each item.

Acceptable — item is in working order but may show signs of wear such as scratches or torn packaging. All specific defects should be noted in the Comments section associated with each item.

Used — An item that has been opened and may show signs of wear. All specific defects should be noted in the Comments section associated with each item.

Refurbished — A used item that has been renewed or updated and verified to be in proper working condition. Not necessarily completed by the original manufacturer.

New
0596001290 BRAND NEW NEVER USED IN STOCK 125,000+ HAPPY CUSTOMERS SHIP EVERY DAY WITH FREE TRACKING NUMBER

Ships from: fallbrook, CA

Usually ships in 1-2 business days

  • •Standard, 48 States
  • •Standard (AK, HI)
$29.11
u-pick
Seller since 2011

Feedback rating:

(367)

Condition: New
2002 Paperback New

Ships from: san francisco, CA

Usually ships in 1-2 business days

  • •Canadian
  • •International
  • •Standard, 48 States
  • •Standard (AK, HI)
  • •Express, 48 States
  • •Express (AK, HI)
$84.12
Extremely_Reliable
Seller since 2007

Feedback rating:

(8152)

Condition: New
Buy with confidence. Excellent Customer Service & Return policy.

Ships from: Richmond, TX

Usually ships in 1-2 business days

  • •Canadian
  • •International
  • •Standard, 48 States
  • •Standard (AK, HI)
$105.00
bluehouse
Seller since 2013

Feedback rating:

(46)

Condition: New
Brand new.

Ships from: acton, MA

Usually ships in 1-2 business days

  • •Standard, 48 States
Page 1 of 1
Showing All
Close
Sort by
Mastering Oracle SQL

Available on NOOK devices and apps  
  • Nook Devices
  • NOOK HD/HD+ Tablet
  • NOOK
  • NOOK Color
  • NOOK Tablet
  • Tablet/Phone
  • NOOK for Windows 8 Tablet
  • NOOK for iOS
  • NOOK for Android
  • NOOK Kids for iPad
  • PC/Mac
  • NOOK for Windows 8
  • NOOK Study
  • NOOK for Web

Want a NOOK? Explore Now

NOOK Book (eBook)
$17.59
BN.com price
(Save 45%)$31.99 List Price

More About This Book

Overview

If you write programs to run against an Oracle database, you spend a lot of time and mental energy writing queries to return the data your programs need. Knowledge of SQL, and particularly of Oracle's implementation of SQL, is the key to writing good queries in a timely manner. In this book, the authors share their knowledge of Oracle SQL, and show you many creative techniques that you can use to advantage in your own applications.

This book shows you how to:

  • Leverage Oracle's vast library of built-in SQL functions
  • Query time-based data, and write joins involving date and time ranges
  • Use Oracle SQL's hierarchical query features to deal with data best represented in a tree format
  • Use DECODE and CASE to implement conditional logic in your queries
  • Use Oracle's new, analytic SQL features to write ranking queries, lag and lead queries, windowing queries, and more
  • Join data from two or more tables using the newly supported SQL92 join syntax

In addition, you'll see how SQL can best be integrated with PL/SQL. You'll also learn various best practices to help you write SQL queries that perform efficiently.

Precious few books on the market today go beyond discussing syntax and the barest rudiments of using Oracle SQL. This book changes that, showing you how to creatively leverage the full power of SQL to write queries in an Oracle environment.

Read More Show Less

Product Details

  • ISBN-13: 9780596001292
  • Publisher: O'Reilly Media, Incorporated
  • Publication date: 4/1/2002
  • Edition description: Older Edition
  • Edition number: 1
  • Pages: 336
  • Product dimensions: 6.86 (w) x 9.46 (h) x 0.85 (d)

Meet the Author

Sanjay Mishra is a certified Oracle database administrator with more than ten years of IT experience. He has been involved in the design, architecture, and implementation of many mission-critical and decision support databases. He has worked extensively in the areas of database architecture, database management, backup / recovery, performance tuning, Oracle Parallel Server, and parallel execution. He has a Bachelor of Science degree in Electrical Engineering, and a Master of Engineering degree in Systems Science and Automation. He is the coauthor of Oracle Parallel Processing and Oracle SQL Loader: The Definitive Guide (both published by O'Reilly & Associates). Presently, he works as a database architect at Dallas Based i2 Technologies, and can be reached at sanjay_mishra@i2.com.

Alan Beaulieu has been designing, building, and implementing custom database applications for over 13 years. He currently runs his own consulting company that specializes in designing Oracle databases and supporting services in the fields of Financial Services and Telecommunications. In building large databases for both OLTP and OLAP environments, Alan utilizes such Oracle features as Parallel Query, Partitioning, and Parallel Server. Alan has a Bachelor of Science degree in Operations Research from the Cornell University School of Engineering. He lives in Massachusetts with his wife and two daughters and can be reached at albeau_mosql@yahoo.com.

Read More Show Less

Table of Contents


DedicationPrefaceChapter 1: Introduction to SQLChapter 2: The WHERE ClauseChapter 3: JoinsChapter 4: Group OperationsChapter 5: SubqueriesChapter 6: Handling Temporal DataChapter 7: Set OperationsChapter 8: Hierarchical QueriesChapter 9: DECODE and CASEChapter 10: Partitions, Objects, and CollectionsChapter 11: PL/SQLChapter 12: Advanced Group OperationsChapter 13: Advanced Analytic SQLChapter 14: SQL Best PracticesColophon
Read More Show Less

Customer Reviews

Average Rating 4.5
( 2 )
Rating Distribution

5 Star

(1)

4 Star

(1)

3 Star

(0)

2 Star

(0)

1 Star

(0)

Your Rating:

Review Guidelines
Add Recommendations
Your Name: Create a Pen Name or

Barnes & Noble.com Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & Noble.com that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & Noble.com does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at BN.com or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation

Reminder:

  • - By submitting a review, you grant to Barnes & Noble.com and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Noble.com Terms of Use.
  • - Barnes & Noble.com reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & Noble.com also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on BN.com. It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

 
Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously
Sort by: Showing all of 2 Customer Reviews

  • Anonymous

    Posted July 22, 2004

    Helps you with 10g

    [A REVIEW OF THE SECOND EDITION] Those of you dealing with the latest Oracle 10g, and perhaps frustrated with the quality of the Oracle documentation, might want to consult this second edition. Its greatest difference compared to the first edition is simply that it deals with 10g, whereas the latter talks about 9g. Mishra and Beaulieu explain, with extensive detail and examples, the new features. Like support for unix-like regular expressions within SQL statements. Given that many Oracle users probably hail from a unix/C background, they will welcome this. Also, for mapping between XML and SQL data types, 10g now integrates XML. This will reduce the impedance mismatch between the object oriented and relational outlooks that bedevil many programmers who have to deal with both. The only problem I found with this book is its lack of mention of competing databases. Because the authors explicitly assume that you have already committed to using Oracle as your database. Fair enough. But perhaps occasional comments in the text, about how a given command or feature is not possible in another database would be useful and appreciated by Oracle users. Heck, to be fair, on this point, the book is at no relative disadvantage. For example, I have texts on dB2 and MySQL that likewise say zilch about their competitors.

    Was this review helpful? Yes  NoThank you for your feedback.   Report this reviewThank you, this review has been flagged.

  • Anonymous

    Posted February 16, 2010

    No text was provided for this review.

Sort by: Showing all of 2 Customer Reviews
If you find inappropriate content, please report it to Barnes & Noble
Why is this product inappropriate?
Comments (optional)