Index_C

C

C language

OCI and, 24

Oracle and, 328

cardinality

b-tree indexes and, 245

bitmap indexes and, 246–247

defined, 245

Cartesian products, 114–115

case sensitivity, and passwords, 224

Change Password, 184

CHECK constraints, 144–146

closed backups, 281

COALESCE function, 129–130

Codd, Dr. E. F., 3, 328

code samples, OCI, 24

cold backups, 281

columns

formatting for reports, 188–189

multiple-column subqueries, 125–126

relational databases and, 4

SELECT statement and, 25–27, 26

updating, 30–31, 30–31

validating data in. See constraints

comments, defined, 78

COMMIT statements, 152–153, 153

comparison conditions, and WHERE clause, 72–74

comparison operators, 73, 120

components, 158–166

background processes, 165–166

logical storage structures, 158–160, 158

memory structures, 162–165, 163

physical storage structures, 160–162, 161

composite indexes, defined, 208

composite partitioning, 252

connection identifiers, 16, 16

constraints, 141, 142–151

basics of, 142

CHECK, 144–146

FOREIGN KEY, 149–151

naming, 144

NOT NULL, 142–143

PRIMARY KEY, 147–149

UNIQUE, 146–147

control files, 161, 162

conversion functions, built-in, 60–62

correlated subqueries, 123–124, 123

cost-based optimizer, 259

COUNT group function, 85–86

CREATE DIRECTORY command, 206

CREATE INDEX statement, 209, 247–248

CREATE MATERIALIZED VIEW command, 255

CREATE ROLE statement, 232

CREATE SEQUENCE statement, 217

CREATE statement, 35–37, 36

CREATE TABLE statement, 202, 203, 208, 234–236, 253

CREATE VIEW statement, 210, 211

CTAS (Create Table As Select), 203–205

CUBE operator, 135, 136–137