| |
Oracle Database 12c SQL explains how to write powerful SQL statements and PL/SQL programs using Oracle’s latest core Database 12c. This Oracle Press guide shows readers how to retrieve and modify database information, use SQL Plus and SQL Developer, work with database objects, write PL/SQL programs and much more. In-depth coverage of the very latest SQL features and tools, performance optimization techniques, advanced queries, Java support and XML is included.
Carefully revised to let readers explore SQL Plus, SQL Developer and more
Reveals best practices for writing PL/SQL scripts
Code and examples available online
Teaches new and experienced developers the best ways to write Java programs to access an Oracle database using JDBC
Table of Contents:
Introduction
Retrieving Information from Database Tables
Using SQL/Plus
Using Simple Functions
Storing and Processing Dates and Times
Subqueries
Advanced Queries
Analyzing Data
Changing Table Contents
Users, Privileges, and Roles
Creating Tables, Sequences, Indexes and Views
Introducing PL/SQL Programming
Database Objects
Collections
Large Objects
SQL Tuning
XML and the Oracle Database
A Oracle Data Types
IndexISBN - 9789351342861
|
| |
|