Index_O

O

object-relational databases, 9–10

objects. See database objects

OCI (Oracle Call Interface), 24

ODBC. See Open Database Connectivity (ODBC)

OEM. See Oracle Enterprise Manager (OEM)

one-to-many relationships, 7–8

one-to-one relationships, 8

open backups, 281–282

Open Database Connectivity (ODBC)

basics of, 22–24, 23

ODBC drivers, defined, 23

operators. See also specific operators

comparison operators, listed, 73

operator precedence, 50–51

set operators, 126–134

INTERSECT, 130–132

MINUS, 132–134

UNION and UNION ALL, 126–130

optimizers, Oracle, 258–261

OR operator

IN operator and, 79

precedence, 51

WHERE clause and, 75

Oracle Call Interface (OCI), 24

Oracle database account identifiers, 224

Oracle database functions

built-in single-row functions, 52–65

conversion functions, 60–62

date functions, 58–60

general functions, 62–65

numeric functions, 55–58

string functions, 52–55

queries, 46–51

concatenating strings and, 49–50

DUAL tables and, 46–48, 47

NULL values and, 48

numeric literals and, 50

operator precedence and, 50–51

string literals and, 49–50

user-defined functions, 65–67

Oracle database installation and creation, 157–177

components, 158–166

background processes, 165–166

logical storage structures, 158–160, 158

Oracle memory structures, 162–165, 163

physical storage structures, 160–162, 161

database creation, 171–176

DBCA, 171–176, 171–176

disk and memory requirements, 171

database, defined, 158

software installation, 166–170

OEM, 169–170, 170

OUI, 166–169, 167–169

Oracle databases. See also databases

history of, 328

Oracle blocks, 160

vs. other database platforms, 328–329

Oracle Enterprise Manager (OEM)

defined, 21, 166

Event Manager, 293–296, 293–295

installing Oracle, 169–170, 170

SQL*Plus Worksheet and, 21, 21

Oracle Home, 166

Oracle optimizer, 258–261

Oracle Universal Installer (OUI), 166–169, 167–169

Oracle’s Tuning Methodology, 242–243

ORDER BY clause, 83–84

OUI. See Oracle Universal Installer (OUI)

outer join operator +, 107

outer joins, 105–111

defined, 105

full outer joins, 107–108, 110–111

left outer joins, 109

pre-Oracle9i, 105–108

right outer joins, 110