background image
<< Copyright | Contents 2 >>
<< Copyright | Contents 2 >>

Contents

iii
Contents
Preface
................................................................................................................................................................. ix
Audience....................................................................................................................................................... ix
Documentation Accessibility ..................................................................................................................... ix
Related Documents ..................................................................................................................................... x
Conventions ................................................................................................................................................. x
1 Overview of Oracle Database and Development
Roadmap
.................................................................................................................................................... 1-1
Overview of Oracle Database Schemas
............................................................................................... 1-2
Introducing Schema Objects ............................................................................................................. 1-2
Introducing the HR Schema ............................................................................................................. 1-3
Overview of Application Development with Oracle Database
...................................................... 1-3
Introducing SQL and PL/SQL Development Languages............................................................ 1-3
Introducing SQL Developer ............................................................................................................. 1-4
Introducing SQL*Plus ....................................................................................................................... 1-5
Connecting to the Database .............................................................................................................. 1-7
Unlocking a User Account......................................................................................................... 1-7
Connecting to Oracle Database from SQL*Plus ..................................................................... 1-7
Connecting to Oracle Database from SQL Developer ........................................................... 1-7
Overview of Other Development Environments
............................................................................ 1-10
2 Querying and Manipulating Data
Exploring Database Objects
................................................................................................................... 2-1
Looking at Schema Object Types ..................................................................................................... 2-1
Exploring Tables and Viewing Data ............................................................................................... 2-3
Retrieving Data with Queries
................................................................................................................ 2-6
Selecting Data from a Table .............................................................................................................. 2-7
Using Column Aliases ....................................................................................................................... 2-8
Restricting Data to Match Specific Conditions .............................................................................. 2-8
Searching for Patterns in Data....................................................................................................... 2-11
Sorting Data ..................................................................................................................................... 2-13
Using Built-In and Aggregate Functions ..................................................................................... 2-14
Using Arithmetic Operators ................................................................................................... 2-14
Using Numeric Functions....................................................................................................... 2-14
Using Character Functions ..................................................................................................... 2-15