Sumário Itens Encontrados: 50CHAPTER 1 Relational Database Systems and Oracle1.1 Information Needs and Information Systems1.2 Database Design1.3 Database Management Systems1.4 Relational Database Management Systems1.5 Relational Data Structures1.6 Relational Operators1.7 How Relational Is My DBMS?1.8 The Oracle Software Environment1.9 Case TablesCHAPTER 2 Introduction to SQL,iSQL*Plus,and SQL*Plus2.1 Overview of SQL2.2 Basic SQL Concepts and Terminology2.3 Introduction to iSQL*Plus2.4 Introduction to SQL*PlusCHAPTER 3 Data Definition,Part I3.1 Schemas and Users3.2 Table Creation3.3 Datatypes3.4 Commands for Creating the Case Tables3.5 The Data DictionaryCHAPTER 4 Retrieval: The Basics4.1 Overview of the SELECT Command4.2 The SELECT Clause4.3 The WHERE Clause4.4 The ORDER BY Clause4.5 AND,OR,and NOT4.6 BETWEEN,IN,and LIKE4.7 CASE Expressions4.8 Subqueries4.9 Null Values4.10 Truth Tables4.11 ExercisesCHAPTER 5 Retrieval: Functions5.1 Overview of Functions5.2 Arithmetic Functions5.3 Text Functions5.4 Regular Expressions5.5 Date Functions5.6 General Functions5.7 Conversion Functions5.8 Stored Functions5.9 ExercisesCHAPTER 6 Data Manipulation6.1 The INSERT Command6.2 The UPDATE Command6.3 The DELETE Command6.4 The MERGE Command6.5 Transaction Processing6.6 Locking and Read Consistency