Oracle Database 11g R2: SQL Fundamentals II > Optional Section 17: SQL*Plus Session Control > Industry References

Table of Contents

Download Safari Books Online apps: Apple iOS | Android

Entire Site

Free Trial

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.

This Book

Oracle Database 11g R2: SQL Fundamentals II

Search

Table of Contents

Title Page

Contents

Course Introduction

Section 1: Understanding Data Models

Section 2: SQL99 Join Techniques

Section 3: Enhancing Groups With ROLLUP & CUBE

Section 4: Using The CASE Expression

Section 5: SQL Functions: Character

Section 6: SQL Functions: Numeric

Section 7: SQL Functions: Date

Section 8: Database Objects: Relational Views

Section 9: Database Objects: Data Dictionary Storage

Section 10: Database Objects: Indexes

Section 11: Database Objects: Other Objects

Section 12: Database Objects: Security

Section 13: Data Integrity Using Constraints

Section 14: Managing Constraint Definitions

Optional Section 15: Advanced SQL*Plus Reports

Optional Section 16: Building SQL*Plus Scripts

Optional Section 17: SQL*Plus Session Control

Section Overview

Controlling System Variables

Optional Workshop Section SQL*Plus Session Control

Exercises

Solutions

Industry References

Industry References

To learn more about the theory behind the SQL language and relational database theory and concepts, see the book “Fundamentals of Database Systems”, authored by Elmasri & Navathe. This reference also provides the theoretical basis for the sample COMPANY data model.

You are currently reading a PREVIEW of this book.

Get instant access to over
$1 million worth of books and videos.

Start a Free Trial