Index

D

data

combining results from queries, 158

filtering rows

aggregated (see HAVING clause).

individually (see WHERE clause).

unique retrieval (see DISTINCT keyword).

grouping data (see GROUP BY clause).

inserting data (see INSERT statement).

querying data (see SELECT statement).

removing (see DELETE statement).

retrieving data (see SELECT statement).

updating data (see UPDATE statement).

Data Control Language (DCL), 3

Data Definition Language (DDL), 3

data integrity

see integrity.

Data Manipulation Language (DML), 3

data normalization, 17, 18

data provider, 5

Data Query Language (DQL), 3

data type conversions

casting to numbers, 135

casting to strings, 133

data types, 13

Access, 537

binary object, 531

bit, 531

character, 14, 531

currency, 531

date and time, 14, 531

DB2, 534

definition, 10

floating-point, 14

for the RDBMS, 531

integer, 14

money, 113

MySQL, 535

numeric, 14, 531

autonumbering, 531

Oracle, 533

SQL Server, 532

string, 14

text, 14

transferring data, 13

database transactions

see transactions.

databases

see relational databases.

date and time data types, 14, 531

DB2, 535

MySQL, 536

Oracle, 534

SQL Server, 533

DATE data type

InstantUniversity database, 515

DATE function, 133

DATEDIFF function, 128

datetime calculating, 126

Access, 132

date formats, 126

DB2, 131

MySQL, 131

Oracle, 130

SQL Server, 128

datetime calculating functions

DATE, 133

DATEDIFF, 128

DAYS, 131

GETDATE, 129

TO_DAYS, 131

datetime data type

InstantUniversity database, 515

MySQL, 536

SQL Server, 533

DAYS function, 131

DBA role, 316

dbclob data type, 534

deadlocks

isolation levels, 297

DEALLOCATE keyword

using cursors, 238

DEC/DECIMAL function, 136

decimal data types, 14

DB2, 535

MySQL, 536

Oracle, 534

ProductCatalog database, 400

SQL Server, 532

declarative language, 5

Declarative Referential Integrity (DRI)

see referential integrity.

DECLARE keyword

DB2, 244

Oracle, 219

variables, stored procedures, 217

default INSERT values

DEFAULT keyword, 221

default values, 15, 69, 334

DEFAULT VALUES keyword, 72

DELETE statement, 78

deleting all rows, 80

cautionary note, 79

logging

DB2, 386

Oracle, 379

SQL Server, 370

modifying data with views, 198

MySQL, 80

object-level permissions, 305

ONLY keyword, 80

Oracle, 80

permissions

DB2, 321

Oracle, 317

SQL Server, 311

second DELETE FROM clause, 80

stored procedure, using, 435, 441

subqueries, 154

DENSERANK function

ProductCatalog database, 414, 423

DENY command, 311, 313

Department table, 396

inserting rows, 403

updataing data, 432

DESC keyword

ORDER BY clause, 46

DETERMINISTIC keyword, 141

Development Center, DB2

stored procedures, 208

dialects, SQL, 6

DIFFERENCE operator, 158

disabling triggers, 382

DISCONNECT statement, 512

disconnecting, 512

DISTINCT keyword, 47

Access, 84

modifying data with views, 198

ProductCatalog database, 417–419

using with AVG function, 88

using with COUNT function, 84

using with SUM function, 87

distributed transactions, 298

double data type

Access, 537

DB2, 535

MySQL, 536

Oracle, 534

DOUBLE function, 136

DROP INDEX command, 357

DROP PROCEDURE command, 216

DROP ROLE command, 320

DROP TABLE command, 331, 332

DROP TRIGGER command, 365

DROP USER command, 315

DROP VIEW command, 201

DUAL table, 349

role-based security, 473, 483

DUP_VAL_ON_INDEX exception, 256

durability of transactions, 268

DYNAMIC type cursor, 236