Related Documents
Oracle Database Administration Fundamentals II
Oracle Database Security
Oracle Database Management
Oracle Database Examples Installation Guide
Solix Enterprise Data Management Suite Achieves Oracle Database Ready, Oracle WebLogic Ready and Oracle Linux Ready Status
Oracle Database Scalability in VMware ESX
Oracle Database 10g Release 2 Installation
Best Practices in Implementing Oracle Database Security Products
Zend Whitepaper PHP and Oracle
Practical SQL by SatyaJohnny
Oracle Database 11g SQL (Osborne ORACLE Press Series)
Write powerful SQL statements and PL/SQL programs
Learn to access Oracle databases through SQL statements and construct PL/SQL programs with guidance from Oracle expert, Jason Price. Published by Oracle Press, Oracle Database 11g SQL explains how to retrieve and modify database information, use SQL Plus and SQL Developer, work with database objects, write PL/SQL programs, and much more. Inside, you'll find in-depth coverage of the very latest SQL features and tools, performance optimization techniques, advanced queries, Java support, and XML. This book contains everything you need to master SQL.
- Explore SQL Plus and SQL Developer
- Use SQL SELECT, INSERT, UPDATE, and DELETE statements
- Write PL/SQL programs
- Create tables, sequences, indexes, views, and triggers
- Write advanced queries containing complex analytical functions
- Create database objects and collections to handle abstract data
- Use large objects to handle multimedia files containing music and movies
- Write Java programs to access an Oracle Database using JDBC
- Tune your SQL statements to make them execute faster
- Explore the XML capabilities of the Oracle Database
- Master the very latest Oracle Database 11g features, such as PIVOT and UNPIVOT, flashback archives, and much more
Customer Reviews:
Good for beginner and intermediate users
By Robert A. Mara "r" - June 28, 2009This book is good for beginner and intermediate users. When I bought the book last year, I was intermediate SQL and beginner Oracle. On my previous database projects, I used SQL Server and Sybase and used GUIs to create my tables and relationships. My current project requires PL/SQL scripts that can be run in batch. Since I had done a lot of DML (Data Manipulation Language, e.g., SELECT), little DDL (Data Definition Language, e.g., CREATE TABLE), and virtually no Oracle, I needed help! This book rescued me.
This is now my main reference for SQL, and especially Oracle-specific SQL. It has many examples of SQL for specific basic tasks. Not system administration tasks, mind you, but DML and DDL. These examples are the biggest strength. Oracle's syntax flowcharts and O'Reilly's "SQL In A Nutshell" are fine, but I need examples. "Show me".
One last note: the book is a SQL book, not a PL/SQL book. If you need to do PL/SQL you will need another PL/SQL-specific... read more
Great reference book
By Honest guy - January 16, 2009It's a great reference book. it has nice examples for a beginner. would highly recommend for beginner/intermediate users.
Great book on SQL and PL/SQL
By Oracle geek "Oracle geek" - October 8, 2008I'm an experienced Oracle developer and I use this book all the time. I have several books on SQL, and this book is by far the best. It has good examples. I highly recommend it.
Use coupon below to get discount at eCampus.com!
SHADES
$3 off textbook orders over $75
SUNBLOCK
$4 off textbook orders over $90
SUNSHINE
$5 off textbook orders over $100
Copy the coupon code before clicking the button!
| AVAILABILITY | |||
| Merchant | Format | Price | |
| Amazon US | Paperback | $20.85 - $49.99 | |
| eBooks.com | Digital (PDF) | $49.99 | |
| BookByte | Paperback | $37.49 | |
| eCampus | Paperback | ||
Hands-On Oracle Database 10g Express Edition for Windows (Osborne ORACLE Press Series)
$1.02 - $49.99The fastest way to get up and running on Oracle Database XETake full advantage of all the powerful features available in Oracle Database 10g Express Edition ...
Oracle WebCenter 11g Handbook: Build Rich, Customizable Enterprise 2.0 Applications (Osborne ORACLE…
$6.94 - $59.99Master Oracle WebCenter 11gTransform your organization into a personalized, user-focused workplace using the detailed information in this comprehensive Oracle Press guide. Oracle ...
Oracle JDeveloper 11g Handbook: A Guide to Fusion Web Development (Osborne ORACLE Press Series)
$14.81 - $64.99Written by the most knowledgeable Oracle JDeveloper author team in the worldThis Oracle Press guide shows how to build Web applications using the ...
Oracle SOA Suite 11g Handbook (Osborne ORACLE Press Series)
$21.02 - $60.00The only book on Oracle's Service-Oriented Architecture suite of applications. Written by an internationally recognized expert and Oracle ACE Director for Fusion Middleware, this Oracle Press ...
Oracle E-Business Suite Development & Extensibility Handbook (Osborne ORACLE Press Series)
$27.60 - $59.99Extend and Customize Oracle E-Business SuiteTransform your Oracle E-Business Suite infrastructure to suit enterprise requirements using the comprehensive development ...
Oracle Essbase & Oracle OLAP: The Guide to Oracle's Multidimensional Solution (Osborne ORACLE Press…
$6.31 - $59.99The only book to cover and compare Oracle's online analytic processing productsWith the acquisition of Hyperion Systems in 2007, Oracle finds ...
Oracle Enterprise Manager 10g Grid Control Handbook (Osborne ORACLE Press Series)
$7.41 - $64.99Master Oracle Enterprise Manager 10g Grid ControlCentralize and simplify enterprise infrastructure administration using the detailed information contained in this Oracle Press guide. ...
Oracle Procure-to-Pay Guide (Osborne ORACLE Press Series)
$8.00 - $39.99Master Oracle E-Business Suite's Oracle Procure-to-PayDrive better decision making and maximize asset usage with Oracle E-Business Suite's comprehensive end-to-end ...
Oracle General Ledger Guide: Implement a Highly Automated Financial Processing System (Osborne ORACLE…
$17.89 - $39.99Master Oracle E-Business Suite's Oracle General LedgerMaintain a centralized, highly automated processing platform across a fully integrated set of Oracle E-Business ...
Oracle Fusion Developer Guide: Building Rich Internet Applications with Oracle ADF Business Components…
$17.70 - $59.99Master Oracle Fusion MiddlewareSuccessfully design rich enterprise web applications using the detailed information in this Oracle Press volume. Oracle Fusion Developer Guide goes beyond the ...
Paid (e)Books
OCA Oracle Database SQL Expert Exam Guide: Exam 1Z0-047 (Osborne Oracle Press Series)
$24.00 - $59.99
Oracle Database Administration for Microsoft SQL Server DBAs (Osborne ORACLE Press Series)
$5.10 - $50.00
