Indexes - RECORD type
RECORD variable, 4-18
REF CURSOR type, 4-15
reference type, 4-15
relational database, 1-1, 1-4
result set, 4-33
object, 1-2, 1-3, 3-2, 3-28, 4-2, 4-9, 5-2
object types, 2-1
overview, 1-2
ownership, 1-2
target, 7-10
SELECT INTO statement, 4-20, 4-39, 4-42, 4-43
SELECT statement, 1-2, 2-6, 2-7, 3-21, 3-22, 3-29,
4-37, 4-38, 4-39, 4-43, 4-44, 5-7, 5-9, 6-5, 6-10, 6-11,
6-13, 6-14, 6-15, 6-17, 6-18, 6-20, 6-21, 6-22, 6-23,
6-24, 6-31, 6-32, 7-6, 7-11
CASE function, 2-26
column, 2-7, 2-8
concatenate, 2-16
convert type, 2-21, 2-22
count rows, 2-23
currency template, 2-21
date interval, 2-18, 2-19
day of month, 2-19
DECODE function, 2-27
DENSE_RANK function, 2-25
distinct values, 2-23
extract, 2-17
format template, 2-21
GROUP BY clause, 2-23, 2-24
HAVING clause, 2-24
match in a list, 2-10
match in another table, 2-11
match pattern, 2-11
match string, 2-10
multiple conditions, 2-9
NVL function, 2-25
NVL2 function, 2-25
ORDER BY clause, 2-24
pad, 2-17
replace, 2-18
replace pattern, 2-12
restrict, 2-8
return location, 2-13
return number of occurances, 2-13
return substring, 2-12
round off, 2-15
single condition, 2-9
standard format, 2-21
statistics, 2-24
system date, 2-20
trim, 2-16
truncation, 2-15
WHERE clause, 2-8
WITHIN GROUP function, 2-25