Index

%

%FOUND cursor attribute, 120

%TYPE and %ROWTYPE attributes, 116–118

A

About Database page (Oracle Application Express), 368–369, 397, 399

Ad hoc query tools, See also SQL*Plus

Ada programming language, 97

ADLC (application development lifecycle)

analysis stage, 212–213

deployment stage, 214

design stage, 213

implementation stage, 213–214

maintenance stage, 215

test stage, 214

After-row triggers, 141

Alias for a column, 56, 88

Alias for a table, in FROM clause, 78

ALL_SEQUENCES view, 201

Allocation of space, explained, 336

ALTER DATABASE statement

ADD LOGFILE MEMBER clause, 416–417

ARCHIVELOG clause, 410

DATAFILE clause, 348

OPEN clause, 410, 449

ALTER INDEX statement, 365

ALTER PROFILE statement, 324–326, 328

ALTER SYSTEM CONTROL_FILES ...

Get Hands-On Oracle Database 10g Express Edition for Windows now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.