SEARCH
Disclaimer: Authors have full rights over their works. Reproduction of any part of the content is prohibited without prior authorization.
BOOK MASTERING ORACLE SQL AND SQL PLUS
SUMMARY
-
Items Found: 50
- CHAPTER 1 Relational Database Systems and Oracle
- 1.1 Information Needs and Information Systems
- 1.2 Database Design
- 1.3 Database Management Systems
- 1.4 Relational Database Management Systems
- 1.5 Relational Data Structures
- 1.6 Relational Operators
- 1.7 How Relational Is My DBMS?
- 1.8 The Oracle Software Environment
- 1.9 Case Tables
- CHAPTER 2 Introduction to SQL,iSQL*Plus,and SQL*Plus
- 2.1 Overview of SQL
- 2.2 Basic SQL Concepts and Terminology
- 2.3 Introduction to iSQL*Plus
- 2.4 Introduction to SQL*Plus
- CHAPTER 3 Data Definition,Part I
- 3.1 Schemas and Users
- 3.2 Table Creation
- 3.3 Datatypes
- 3.4 Commands for Creating the Case Tables
- 3.5 The Data Dictionary
- CHAPTER 4 Retrieval: The Basics
- 4.1 Overview of the SELECT Command
- 4.2 The SELECT Clause
- 4.3 The WHERE Clause
- 4.4 The ORDER BY Clause
- 4.5 AND,OR,and NOT
- 4.6 BETWEEN,IN,and LIKE
- 4.7 CASE Expressions
- 4.8 Subqueries
- 4.9 Null Values
- 4.10 Truth Tables
- 4.11 Exercises
- CHAPTER 5 Retrieval: Functions
- 5.1 Overview of Functions
- 5.2 Arithmetic Functions
- 5.3 Text Functions
- 5.4 Regular Expressions
- 5.5 Date Functions
- 5.6 General Functions
- 5.7 Conversion Functions
- 5.8 Stored Functions
- 5.9 Exercises
- CHAPTER 6 Data Manipulation
- 6.1 The INSERT Command
- 6.2 The UPDATE Command
- 6.3 The DELETE Command
- 6.4 The MERGE Command
- 6.5 Transaction Processing
- 6.6 Locking and Read Consistency
