Oracle PL/SQL in 10 Minutes, Sams Teach Yourself

Index

Symbols

|| operator, 93–94

% (percent sign), 70

; (semicolon), 35

_ (underscore), 72–73

* (wildcard), 37

A

ABS() function, 107

access control, 239–240

access rights, setting, 242–243

passwords, 244

user accounts, 241

users, 240–241

access rights, setting, 242–243

Add_Month(), 103

advantages

of IN operator, 67

of SQL, 11

AFTER trigger, 225, 228

aggregate functions, 109–110

ALL argument, 117

AVG(), 110–111

combining, 118–119

COUNT(), 112–113

defined, 109

DISTINCT argument, 117

distinct values, 117–118

joins, 160–161

MAX(), 113–114

MIN(), 114–115

naming aliases, 119

overview, 109

SUM(), 115–116

aliases

alternative uses, 96

concatenating fields, 95–96

creating, 153

fields, concatenating, 95–96

table names, 153–154

alphabetical sort order, ...