Index_V

V

VALUE() function, 375 “376

VALUES clause, with INSERT statement, 248 “249

VARCHAR2 data type, 12, 391, 400, 415, 552

VARCHAR2 strings, 400, 415

VARIABLE command, 539 “540

variable definition, viewing, 155 “157

variable definition characters , 154

variables , 152 “157

binding to statements, 511

PL/SQL, 334

removing using UNDEFINE, 155, 157

types of in SQL*Plus, 152

uses for, 152

using ACCEPT to define, 158

using to enter a column name , 154

using in reports , 158 “160

using in scripts, 158 “159

variables in scripts, passing values to, 159 “160

VARIANCE() function, 92

varray elements

increasing the number of, 416

modifying, 394 “395

selecting, 394

size or precision of, 415 “416

varray_package, 401, 403

varrays (VARRAY types), 391 “395, 555

creating, 391, 415

explained, 390

getting information on, 392 “393

manipulating, 401 “403

populating, 394

using to define a column, 392

using in temporary tables, 416

vi editor, setting as default editor, 146

view constraints, getting information on, 326

view definitions, 325 “326

views, 320 “329

benefits of, 320

with CHECK OPTION constraint, 324

creating and using, 321 “328

dropping, 329

modifying, 328 “329

with READ ONLY constraint, 324 “325

types of, 321