- ホーム
- > 洋書
- > 英文書
- > Computer / Databases
Full Description
Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product.
Write Powerful SQL Statements and PL/SQL Programs
Learn how to access Oracle databases through SQL statements and construct PL/SQL programs. Oracle Database 12c SQL offers complete coverage of the latest database features and techniques. Find out how to write SQL statements to retrieve and modify database information, use SQL*Plus and SQL Developer, work with database objects, write PL/SQL programs, use performance optimization techniques, incorporate XML, and more. This Oracle Press guide contains everything you need to know to master SQL.
Use SQL statements to access an Oracle database
Work with SQL*Plus and SQL Developer
Write PL/SQL programs
Create tables, sequences, indexes, views, and triggers
Design advanced queries containing complex calculations
Create database objects to handle abstract data
Use date, time stamp, and time interval data types
Establish user roles and privileges
Handle multimedia files using large objects
Tune SQL statements to make them execute faster
Generate, process, and store XML data
Master the very latest Oracle Database 12c features
Code examples in the book are available for download.
Contents
1. Introduction
2. Retrieving Information from Database Tables
3. Using SQL*Plus
4. Using Simple Functions
5. Storing and Processing Dates and Times
6. Subqueries
7. Advanced Queries
8. Analyzing Data
9. Changing Table Contents
10. Users, Privileges, and Roles
11. Creating Tables, Sequences, Indexes, and Views
12. Introducing PL/SQL Programming
13. Database Objects
14. Collections
15. Large Objects
16. SQL Tuning
17. XML and the Oracle Database
A. Oracle Data Types
Index
