contents

nội dung tài liệu về cơ sở dữ liệu | Contents Volume 1 Preface. xi Profile. xii Related Publications . xviii Typographic Conventions. xix I Introduction. 1-1 Course Objectives . I-3 Course Outline . I-5 The Relational Database Concept . I-9 System Development Cycle. 1-17 What Is Oracle . 1-19 The Oracle Product Set. 1-21 SQL SQL Plus and PL SQL. I-23 Summit Sporting Goods Demonstration Tables. I-29 Summary. I-33 1. Selecting Rows. 1-1 Objectives . 1-3 The Basic Query Block . 1-5 Arithmetic Expressions . 1-13 Column Aliases . 1-21 The Concatenation Operator. 1-23 Literal Character String . 1-25 Managing Null Values. 1-27 Preventing the Selection of Duplicate Rows . 1-31 SQL Plus Commands. 1-35 Logging in to SQL Plus . 1-37 Displaying Table Structure . 1-39 SQL Plus Editing Commands. 1-41 SQL Plus File Commands and Online Help. 1-43 Creating a Report. 1-45 Summary. 1-51 Practice Overview . 1-53 Practice 1. 1-55 2. Limiting Selected Rows . 2-1 Objectives . 2-3 Ordering Rows with the ORDER BY Clause . 2-5 Limiting Selected Rows with the WHERE Clause. 2-11 Comparison Operators. 2-13 iii Negating Expressions. 2-17 SQL Operators . 2-19 Querying Data with Multiple Conditions. 2-27 Rules of Precedence. 2-29 Summary. 2-33 Practice Overview . 2-35 Practice 2. 2-37 3. Single Row Functions. 3-1 Objectives . 3-3 Overview . 3-5 Single Row Functions . 3-7 Character Functions . 3-9 Number Functions. 3-17 Oracle Date Format. 3-23 Using Arithmetic Operators with Dates . 3-25 Date Functions. 3-27 Conversion Functions. 3-33 TO_CHAR Function with Date Formats . 3-35 TO_CHAR Function with Number Formats . 3-45 TO_NUMBER and TO_DATE Functions. 3-49 Nesting Single Row Functions. 3-51 Nesting Functions . 3-53 Summary. 3-55 Practice Overview . 3-57 Practice 3. 3-59 4. Displaying Data from Multiple Tables. 4-1 Objectives . 4-3 Overview . 4-5 What Is a Cartesian Product . 4-7 Simple Join Query. 4-9 Using Table Aliases . 4-17 Non-Equijoin. 4-19 Returning Records with No Direct Match. 4-21 Joining a Table to Itself. 4-25 Summary. .