Index_V

V

validating, SQL statements, 528

value

caching, Oracle 9i sequences, 136

changeable, storing, 285

changing existing, 541

columns

constraints, 85–86

default, 86–87

concatenating, 214

expression, comparing to predefined (CASE), 359–361

from other tables, 184–185

grouping larger than certain number (HAVING), 266–267

matching (IN), 375

parameters, passing by, 495–496

populating tables (INSERT), 182–183

providing missing, 259–263

rows matching (EXISTS), 376–377

same, populating, 137

single for each order, 265–266

skipping columns, 178

value, empty (NULL)

allowing, MS SQL Server 2000, 212, 213–214

arithmetic operators, 372

column constraints, 85, 86, 148

data types, 75

excluding, calculating set of values, 342

host variables, embedded SQL, 532–533

multiple columns, populating, 183–184

setting all values to, 194

sorting precedence, 269

specifying, MS SQL Server 2000, 259

VARCHAR column size, tables, increasing, 152

variables, 490–491

varying arrays, 71

varying length character strings, 45

vendors

C2-level security certification, 454

databases other than "big three", 767–770

JDBC, 569

overall SQL compliance, 24

proprietary versus SQL-compliant language, 42

Versant/SQL, 770

version information, MS SQL Server 2000, 481

video files, holding. See binary strings

views

accessible, describing, 458, 460, 461

altering

DB2 UDB 8.1, 163

MS SQL Server 2000, 163

Oracle 9i, 162

based on another view example, 120

creating

DB2 UDB 8.1, 116–118

MS SQL Server 2000, 117–118

Oracle 9i, 114–116

SQL99, 112–113

DDL statements, syntax, 729

different totals, 120

dropping

DB2 UDB 8.1, 164

MS SQL Server 2000, 164

Oracle 9i, 163

FROM clause, 251

indexes, creating, MS SQL Server 2000, 112

INFORMATION_SCHEMA objects, 466–467

joining, 119–120

listing

DB2 UDB 8.1, 467

MS SQL Server 2000, 473

nested tables, 70

OR REPLACE, simulating, 119

Oracle data directory, 459–462

records in (COUNT), 340–342

security, 38–39, 435–438

stored procedures, 477–478

with subquery, 121

with UNION example, 120–121

updateable, 469

Visual Basic, 581–583

VisualStudio.NET IDE, 588–589