|
|
backslash (\), 356
Backus-Naur Form. See BNF
bank
ATM withdrawal operation, 217–218
security standard, 452
batch mode, 681–683
BETWEEN expression and expression logical operator, 373–375
BETWEEN operator, 256
BFILE, SQL data type, 74
biggest orders, 344
binary data
encrypting, 443
read-only access, 74
binary instructions, executing, 528
binary numbers
converting to decimal, 773
storing bytes and bits, 44
binary strings
DB2 UDB 8.1, 52
described, 44, 51
MS SQL Server 2000, 52–53
Oracle 9i, 52
SQL99, 52
bits
length of expression, 308
storing, 44, 52, 74
bitwise operators
AND (&), 390
exclusive OR (/\), 390–392
NOT (~), 383, 390
OR (|), 390
blank spaces, removing from strings (TRIM, LTRIM, and RTRIM), 327–328
BLOB (binary, nonstructured objects)
described, 52
encrypting, 443
block structure, procedural language, key elements, 491–493
BNF (Backus-Naur Form)
DCL statements, 731
DDL statements
indexes, 729
schemas, 729–730
stored procedures, 730
tables, 728–729
triggers, 731
user-defined functions, 730
views, 729
described, 727–728
DML statements, 731–732
DQL statements, 732–734
book, recommended, Oracle Administration and Management (Michael Ault), 209
books, storing. See CLOB
Boolean expressions
complement or inverter (NOT), 775
described, 774–775
exclusive sum (XOR), 776
identities, 778–779
inverse product (NAND), 776–777
inverse sum (NOR), 777
negating (NOT), 381–382
precedence, 777–778
product (AND), 381, 775
SQL data types, 73
sum (OR), 775–776
Borland database, 130
brackets (()), 198
BS7799 security standard, 451
B-Tree indexes, 106, 108
business rules
ACME sample database, 613–614
archiving complex, 185
minimum and maximum order amount, discounts, 284–286
security through stored procedures, 440
table structure, changing, 145
values, changing, 285
byte
checking number, 357
storing, 44, 309
|
|