Oracle Database 10g SQL (Osborne ORACLE Press Series)

G

GET command, 146

get methods (JDBC), 485 “486, 488, 490 “491

GETCHUNKSIZE() function, 455

getconnection() method (JDBC), 482 “483, 486

getErrorCode() method (Java), 499

GETLENGTH() function, 455 “456

getMessage() method (Java), 499

getObject() method (Java), 496

get_products() method, 380 “381

in nested_table_package, 405

in varray_package, 403

get_sell_by_date() method, 369 “370, 374

getSQLState() method (Java), 499

GET_STORAGE_LIMIT() function, 455

GET_SYSTEM_CHANGE_NUMBER() procedure, 268

GLOBAL TEMPORARY clause of CREATE TABLE, 294

Globalization Support Guide (Oracle Corp.), 515

GMT (Greenwich Mean Time), 120

GRANT command, 11, 266, 273 “275, 278, 285 “286

greater than operator (>), 38, 167

GROUP BY clause, 93 “98, 327 “328, 535

with aggregate functions, 95

with AVG() function, 94

with COUNT() function, 95

extended, 201 “203, 206 “207

using a column multiple times in, 212 “213

using with WHERE clause, 98

using with WHERE and HAVING, 98 “99

group computation, 90

group function not allowed here (error), 97

group sorting, using ORDER BY clause, 95 “96

GROUP_ID() function, 213 “214

GROUPING bit vector, computing, 210 “211

grouping rows, 93 “99

with aggregate functions, 94 “95

and filtering using HAVING, 97 “98

with multiple columns in a group, 94

GROUPING SETS clause, 210, 221

GROUPING() function, 207 “210

in converting multiple column values, 208 “209

with CUBE, 209

DECODE() on value returned from, 208

with single column in a ROLLUP, 207 “208

GROUPING_ID() function, 210 “212

query that illustrates, 211

useful application of, 212

groups

dividing into subgroups, 218

ranking items in, 216 “221