Oracle Database 10g SQL (Osborne ORACLE Press Series)

3.95 avg rating
( 41 ratings by GoodReads )
 
9780072229813: Oracle Database 10g SQL (Osborne ORACLE Press Series)

This volume will take you from novice to master, covering not only how to use SQL but also the Oracle extensions to SQL. The examples feature the sample schemas available with Oracle Database 10 g, and free code will be available for download.

"synopsis" may belong to another edition of this title.

From the Back Cover:

Write Powerful SQL Statements and PL/SQL Programs

In this comprehensive book, you’ll learn to write Structured Query Language (SQL) statements to access an Oracle database and use PL/SQL (Procedural Language/SQL) to write programs containing SQL statements. Developed in compliance with the new SQL2003 specification, this definitive resource explains how to use the latest Oracle Database 10g features, and much more. Written by Oracle guru Jason Price, Oracle Database 10g SQL covers everything you need to know to master SQL.

  • Execute queries, inserts, updates, and deletes against a database
  • Write PL/SQL stored programs, packages, and triggers
  • Create database tables, sequences, indexes, views, and users
  • Use SQL*Plus to execute SQL statements, scripts, and reports
  • Perform complex calculations using analytic functions
  • Learn the basics of running SQL using Java through JDBC
  • Use large objects to store up to 128 terabytes of character and binary data
  • Define database object types and create object tables to handle advanced data
  • Use all the latest Oracle Database 10g features such as the BINARY_FLOAT and BINARY_DOUBLE types, the MODEL clause, and more
  • Implement high-performance tuning techniques to make your SQL statements really fly

Covers Oracle Database Releases 8i, 9i, and 10g

About the Author:

Jason Price (Castro Valley, CA) has over 10 years experience in the software industry, 5 of which were spent at Oracle. Jason is an Oracle Certified Professional DBA and Application Developer and has written several books: Java Programming with Oracle SQLJ, O’Reilly (2001) Oracle9i JDBC Programming, Oracle Press (2002) Mastering Visual C# .NET, Sybex (2002) Mastering Visual C# .NET Database Programming, Sybex (2003.

"About this title" may belong to another edition of this title.

Top Search Results from the AbeBooks Marketplace

International Edition
International Edition

1.

Price, Jason; McGraw-Hill
ISBN 10: 0072229810 ISBN 13: 9780072229813
New Quantity Available: 5
International Edition
Seller
firstbookstore
(New Delhi, India)
Rating
[?]

Book Description Book Condition: Brand New. Brand New Paperback International Edition, Perfect Condition. Printed in English. Excellent Quality, Service and customer satisfaction guaranteed!. Bookseller Inventory # AIND-41691

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 23.73
Convert Currency

Add to Basket

Shipping: FREE
From India to U.S.A.
Destination, Rates & Speeds

2.

Price, Jason; McGraw-Hill
Published by McGraw-Hill Osborne Media (2004)
ISBN 10: 0072229810 ISBN 13: 9780072229813
New Paperback Quantity Available: 1
Seller
Irish Booksellers
(Rumford, ME, U.S.A.)
Rating
[?]

Book Description McGraw-Hill Osborne Media, 2004. Paperback. Book Condition: New. book. Bookseller Inventory # 0072229810

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 24.62
Convert Currency

Add to Basket

Shipping: FREE
Within U.S.A.
Destination, Rates & Speeds
International Edition
International Edition

3.

Price, Jason; McGraw-Hill
ISBN 10: 0072229810 ISBN 13: 9780072229813
New Softcover Quantity Available: 5
International Edition
Seller
Romtrade Corp.
(STERLING HEIGHTS, MI, U.S.A.)
Rating
[?]

Book Description Book Condition: New. Brand New Paperback International Edition.We Ship to PO BOX Address also. EXPEDITED shipping option also available for faster delivery. Bookseller Inventory # AUSBNEW-41691

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 26.10
Convert Currency

Add to Basket

Shipping: FREE
Within U.S.A.
Destination, Rates & Speeds

4.

Price, Jason; McGraw-Hill
Published by McGraw-Hill Osborne Media (2004)
ISBN 10: 0072229810 ISBN 13: 9780072229813
New Softcover Quantity Available: 1
Seller
Book Deals
(Lewiston, NY, U.S.A.)
Rating
[?]

Book Description McGraw-Hill Osborne Media, 2004. Book Condition: New. Brand New, Unread Copy in Perfect Condition. A+ Customer Service! Summary: Ch. 1: Introduction Ch. 2: Retrieving Information from Tables Ch. 3: Using Simple Functions Ch. 4: Storing and Processing Dates and Times Ch. 5: Using SQL *Plus Ch. 6: Subqueries Ch. 7: Advanced Select Functions Ch. 8: Changing Table Contents Ch. 9: Database Security Ch. 10: Creating Database Tables, Indexes, Views, and Sequences Ch 11: Introducing PL/SQL Programming Ch. 12: Database Objects Ch. 13: Collections Ch. 14: Large Objects Ch 15: Native XML Support Ch. 16: Tuning Appendix A Oracle Data Types. Bookseller Inventory # ABE_book_new_0072229810

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 30.45
Convert Currency

Add to Basket

Shipping: FREE
Within U.S.A.
Destination, Rates & Speeds

5.

Price, Jason; McGraw-Hill
Published by McGraw-Hill Osborne Media (2004)
ISBN 10: 0072229810 ISBN 13: 9780072229813
New Paperback First Edition Quantity Available: 1
Seller
Ergodebooks
(RICHMOND, TX, U.S.A.)
Rating
[?]

Book Description McGraw-Hill Osborne Media, 2004. Paperback. Book Condition: New. 1st. Bookseller Inventory # DADAX0072229810

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 26.48
Convert Currency

Add to Basket

Shipping: US$ 3.99
Within U.S.A.
Destination, Rates & Speeds

6.

Price, Jason; McGraw-Hill
Published by McGraw-Hill Education (2004)
ISBN 10: 0072229810 ISBN 13: 9780072229813
New Quantity Available: > 20
Print on Demand
Seller
PBShop
(Wood Dale, IL, U.S.A.)
Rating
[?]

Book Description McGraw-Hill Education, 2004. PAP. Book Condition: New. New Book. Shipped from US within 10 to 14 business days. THIS BOOK IS PRINTED ON DEMAND. Established seller since 2000. Bookseller Inventory # I2-9780072229813

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 32.50
Convert Currency

Add to Basket

Shipping: US$ 3.99
Within U.S.A.
Destination, Rates & Speeds

7.

Price, Jason; McGraw-Hill
ISBN 10: 0072229810 ISBN 13: 9780072229813
New Paperback Quantity Available: > 20
Print on Demand
Seller
BargainBookStores
(Grand Rapids, MI, U.S.A.)
Rating
[?]

Book Description Paperback. Book Condition: New. This item is printed on demand. Item doesn't include CD/DVD. Bookseller Inventory # 7518028

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 34.85
Convert Currency

Add to Basket

Shipping: US$ 3.99
Within U.S.A.
Destination, Rates & Speeds

8.

Price, Jason; McGraw-Hill
Published by McGraw-Hill Education (2004)
ISBN 10: 0072229810 ISBN 13: 9780072229813
New Quantity Available: > 20
Print on Demand
Seller
Books2Anywhere
(Fairford, GLOS, United Kingdom)
Rating
[?]

Book Description McGraw-Hill Education, 2004. PAP. Book Condition: New. New Book. Delivered from our UK warehouse in 3 to 5 business days. THIS BOOK IS PRINTED ON DEMAND. Established seller since 2000. Bookseller Inventory # I2-9780072229813

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 34.69
Convert Currency

Add to Basket

Shipping: US$ 11.15
From United Kingdom to U.S.A.
Destination, Rates & Speeds

9.

Price, Jason; McGraw-Hill
Published by McGraw-Hill Education (2004)
ISBN 10: 0072229810 ISBN 13: 9780072229813
New Paperback Quantity Available: 10
Seller
Ergodebooks
(RICHMOND, TX, U.S.A.)
Rating
[?]

Book Description McGraw-Hill Education, 2004. Paperback. Book Condition: New. Bookseller Inventory # INGM9780072229813

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 42.75
Convert Currency

Add to Basket

Shipping: US$ 3.99
Within U.S.A.
Destination, Rates & Speeds

10.

Price, Jason; McGraw-Hill
Published by McGraw-Hill Education - Europe, United States (2004)
ISBN 10: 0072229810 ISBN 13: 9780072229813
New Paperback Quantity Available: 10
Print on Demand
Seller
The Book Depository US
(London, United Kingdom)
Rating
[?]

Book Description McGraw-Hill Education - Europe, United States, 2004. Paperback. Book Condition: New. 231 x 188 mm. Language: English . Brand New Book ***** Print on Demand *****. This volume will take you from novice to master, covering not only how to use SQL but also the Oracle extensions to SQL. The examples feature the sample schemes available with Oracle Database 10g, and free code will be available for download. Bookseller Inventory # APC9780072229813

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 46.88
Convert Currency

Add to Basket

Shipping: FREE
From United Kingdom to U.S.A.
Destination, Rates & Speeds

There are more copies of this book

View all search results for this book