Oracle Database 11g PL/SQL Programming Workbook

Index

A

absolute (canonical) directories, 31

ACID test, 70–71

atomicity, 71

consistency, 71–73

durability, 72

isolation, 72

actual parameters

cursors, 57

local variables, 29

mixed notation, 138

named notation, 137

pass-by-reference functions, 132–133, 162

pass-by-reference procedures, 173

pass-by-value functions, 131

scalar varrays, 186

structures, 50

Ada language, 6

add_contact procedure, 168–170, 172

Advanced Friendly Interface (AFI), 7

Advanced Friendly Interface Editor buffer, 7, 26

afiedt.buffile, 7, 26

aggregate tables, 8

from collections, 185, 200

pipelined functions for, 138, 142

types, 181–182

ALL_IDENTIFIERS view, 387

ALTER statement, 10, 348

ALTER TABLE statement, 108

American National Standards Institute (ANSI), 82–83

ampersands (&) ...