Oracle Database 10g SQL

1st Edition
0071706704 · 9780071706704
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 10g, and free code will be available for download.
US$49.50
Request Review Copy
Download file to PC or Mac desktops or laptops

Step 1. Download Adobe Digital Editions Both PC and Mac users will need to download Adobe Digital Editions to access their eBook. You can download Adobe Digital Editions at Adobe's website here.


Step 2. Register an Adobe ID if you do not already have one. (This step is optional, but allows you to open the file on multiple devices) Visit account.Adobe.com to register your Adobe account.


Step 3: Authorize Adobe Digital Editions using your Adobe ID. In Adobe Digital Editions, go to the Help menu. Choose “Authorize Computer.”


Step 4: Open your file with Adobe Digital Editions. Once you’ve linked your Adobe Digital Editions with your Adobe ID, you should be able to access your eBook on any device which supports Adobe Digital Editions and is authorized with your ID. If your eBook does not open in Adobe Digital Editions upon download, please contact customer service

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

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 10g, and free code will be available for download.