Index

V

values

see also rows.

default values, 15, 69

NULL, 14

relational databases, 8

varbinary data type, 532

varchar data type, 14

Access, 537

DB2, 534

MySQL, 536

Oracle, 533

ProductCatalog database, 400

SQL Server, 532

VARCHAR function, 134

vargraphic data type, 534

variables

Access, 217

assigning values, 219

DB2, 219

MySQL, 219

Oracle, 220

SQL Server, 219

cursors, 219

declaring, 217

DB2, 218

Oracle, 219

prefixes required, 217

stored procedures, 217

views, 193

availability by RDBMS, 193

creating (see CREATE VIEW command).

deleting, 201

INSTEAD OF triggers, 365

modifying data, 198

modifying view definition, 199

DB2, 199

Oracle, 199, 200

SQL Server, 199

security, 193, 303

user access, 303

WITH CHECK OPTION clause, 198

virtual tables

see views.