Oracle Database 10g SQL (Osborne ORACLE Press Series)

M

main() method (JDBC), 500 “501

master (parent) table, 16, 254

master-detail relationship, 16

MAX() function, 91 “92, 168

MEASURES clause, 236

MEMBER FUNCTION clause, 369

MEMBER of operator, 422

member_of_example() procedure, 422

MERGE statement, 250, 256 “258

MERGE INTO clause, 257

USING...ON clause, 257

WHEN MATCHED THEN clause, 258

WHEN NOT MATCHED clause, 258

metacharacters, regular expression, 83 “85

MIN() function, 91 “92

MINUS operator, 186

minute, datetime formatting parameter for, 107

missing values, handling, 241 “243

MOD() function, 74 “75

MODEL clause, 235 “244

example of, 235 “237

handling null and missing values, 241 “243

month

datetime formatting parameters for, 106

getting the current, 239 “240

MONTHS_BETWEEN() function, 117 “118

more_employees table, 194 “195

more_products table, 183 “184

moving average, performing, 225 “226

multilevel collection type, 399 “401

multiple column subqueries, 173

multiple row subqueries, 171 “173

ALL with, 172 “173

ANY with, 172

IN with, 171 “172

multiplication operator (*), 30

MULTISET EXCEPT, 420

MULTISET INTERSECT, 420

MULTISET operator, 420 “421

MULTISET UNION, 420

multiset_example() procedure, 420