/ Chip 1997 September / CHIP_CD_1997_09_PL.iso / software / testsoft / adabas / help / tutorial.hlp

< prev

next >

MacOS 8.1

Win98

DOS

view JSON data

view as text

+--------+-------------------------+-------------------------+--------+--------+
|00000000| 3f 5f 03 00 15 4d 0a 00 | d9 00 00 00 4d 9b 0d 00 |?_...M..|....M...|
|00000010| c9 00 00 00 c0 00 00 00 | 00 6c 03 15 00 01 00 86 |........|.l......|
|00000020| 9c f5 30 00 00 01 00 12 | 00 41 44 41 42 41 53 20 |..0.....|.ADABAS |
|00000030| 44 20 54 75 74 6f 72 69 | 61 6c 00 03 00 04 00 00 |D Tutori|al......|
|00000040| 00 00 00 02 00 20 00 43 | 6f 70 79 72 69 67 68 74 |..... .C|opyright|
|00000050| 20 ae 20 31 39 39 36 20 | 62 79 20 53 6f 66 74 77 | . 1996 |by Softw|
|00000060| 61 72 65 20 41 47 00 04 | 00 10 00 42 72 6f 77 73 |are AG..|...Brows|
|00000070| 65 42 75 74 74 6f 6e 73 | 28 29 00 06 00 5a 00 87 |eButtons|()...Z..|
|00000080| 02 6d 61 69 6e 00 1c 00 | 02 00 3f 6d 61 69 6e 00 |.main...|..?main.|
|00000090| 00 8c 03 3b 41 44 41 42 | 41 53 20 44 20 54 75 74 |...;ADAB|AS D Tut|
|000000a0| 6f 72 69 61 6c 00 00 57 | 01 47 01 47 01 e4 09 f4 |orial..W|.G.G....|
|000000b0| 08 1c 20 78 4f 00 00 9f | 01 6d 00 23 00 23 00 ae |.. xO...|.m.#.#..|
|000000c0| 4f 13 2c 87 01 6c 08 47 | 01 ea 02 9f 01 07 00 00 |O.,..l.G|........|
|000000d0| 00 9f 01 9f 01 ff ff 80 | 00 2f 04 00 00 ff ff ff |........|./......|
|000000e0| ff 04 3b 29 02 04 00 04 | 7a 34 00 88 88 88 88 88 |..;)....|z4......|
|000000f0| 88 70 ff f0 ff f0 ff 0f | 00 00 00 00 00 00 ff ff |.p......|........|
|00000100| 01 00 01 00 64 00 00 00 | 07 00 64 00 ff ff ff ff |....d...|..d.....|
|00000110| 7c 43 4f 4e 54 45 58 54 | 00 d1 a7 02 00 7c 43 54 ||CONTEXT|.....|CT|
|00000120| 58 4f 4d 41 50 00 bf 3d | 02 00 7c 46 4f 4e 54 00 |XOMAP..=|..|FONT.|
|00000130| 84 3c 02 00 7c 4b 57 42 | 54 52 45 45 00 d1 4f 02 |.<..|KWB|TREE..O.|
|00000140| 00 7c 4b 57 44 41 54 41 | 00 ca 40 02 00 7c 4b 57 |.|KWDATA|..@..|KW|
|00000150| 4d 41 50 00 bf 49 02 00 | 7c 53 59 53 54 45 4d 00 |MAP..I..||SYSTEM.|
|00000160| 10 00 00 00 7c 54 4f 50 | 49 43 00 f7 07 00 00 7c |....|TOP|IC.....||
|00000170| 54 54 4c 42 54 52 45 45 | 00 d1 87 02 00 7c 62 6d |TTLBTREE|.....|bm|
|00000180| 30 00 00 b0 02 00 7c 62 | 6d 31 00 78 e5 02 00 7c |0.....|b|m1.x...||
|00000190| 62 6d 31 30 00 b5 c2 03 | 00 7c 62 6d 31 31 00 0f |bm10....|.|bm11..|
|000001a0| e0 03 00 7c 62 6d 31 32 | 00 7c fd 03 00 7c 62 6d |...|bm12|.|...|bm|
|000001b0| 31 33 00 4a 12 04 00 7c | 62 6d 31 34 00 14 21 04 |13.J...||bm14..!.|
|000001c0| 00 7c 62 6d 31 35 00 4d | 31 04 00 7c 62 6d 31 36 |.|bm15.M|1..|bm16|
|000001d0| 00 13 3e 04 00 7c 62 6d | 31 37 00 e9 51 04 00 7c |..>..|bm|17..Q..||
|000001e0| 62 6d 31 38 00 dd 66 04 | 00 7c 62 6d 31 39 00 b4 |bm18..f.|.|bm19..|
|000001f0| 83 04 00 7c 62 6d 32 00 | 6d fd 02 00 7c 62 6d 32 |...|bm2.|m...|bm2|
|00000200| 30 00 73 98 04 00 7c 62 | 6d 32 31 00 bf b1 04 00 |0.s...|b|m21.....|
|00000210| 7c 62 6d 32 32 00 29 c4 | 04 00 7c 62 6d 32 33 00 ||bm22.).|..|bm23.|
|00000220| 65 d0 04 00 7c 62 6d 32 | 34 00 ed e1 04 00 7c 62 |e...|bm2|4.....|b|
|00000230| 6d 32 35 00 71 fb 04 00 | 7c 62 6d 32 36 00 aa 0c |m25.q...||bm26...|
|00000240| 05 00 7c 62 6d 32 37 00 | af 28 05 00 7c 62 6d 32 |..|bm27.|.(..|bm2|
|00000250| 38 00 6d 35 05 00 7c 62 | 6d 32 39 00 5d 4e 05 00 |8.m5..|b|m29.]N..|
|00000260| 7c 62 6d 33 00 29 12 03 | 00 7c 62 6d 33 30 00 71 ||bm3.)..|.|bm30.q|
|00000270| 6f 05 00 7c 62 6d 33 31 | 00 0d 7b 05 00 7c 62 6d |o..|bm31|..{..|bm|
|00000280| 33 32 00 5d 87 05 00 7c | 62 6d 33 33 00 ea 97 05 |32.]...||bm33....|
|00000290| 00 7c 62 6d 33 34 00 00 | a7 05 00 7c 62 6d 33 35 |.|bm34..|...|bm35|
|000002a0| 00 8d c5 05 00 7c 62 6d | 33 36 00 64 e0 05 00 7c |.....|bm|36.d...||
|000002b0| 62 6d 33 37 00 f1 fe 05 | 00 7c 62 6d 33 38 00 7e |bm37....|.|bm38.~|
|000002c0| 1d 06 00 7c 62 6d 33 39 | 00 43 38 06 00 7c 62 6d |...|bm39|.C8..|bm|
|000002d0| 34 00 d8 26 03 00 7c 62 | 6d 34 30 00 a6 47 06 00 |4..&..|b|m40..G..|
|000002e0| 7c 62 6d 34 31 00 99 60 | 06 00 7c 62 6d 34 32 00 ||bm41..`|..|bm42.|
|000002f0| 0c 78 06 00 7c 62 6d 34 | 33 00 4a 91 06 00 7c 62 |.x..|bm4|3.J...|b|
|00000300| 6d 34 34 00 f5 a5 06 00 | 7c 62 6d 34 35 00 dc bb |m44.....||bm45...|
|00000310| 06 00 7c 62 6d 34 36 00 | b9 cb 06 00 7c 62 6d 34 |..|bm46.|....|bm4|
|00000320| 37 00 33 d8 06 00 7c 62 | 6d 34 38 00 d4 03 07 00 |7.3...|b|m48.....|
|00000330| 7c 62 6d 34 39 00 7e 47 | 07 00 7c 62 6d 35 00 92 ||bm49.~G|..|bm5..|
|00000340| 3a 03 00 7c 62 6d 35 30 | 00 ef 70 07 00 7c 62 6d |:..|bm50|..p..|bm|
|00000350| 35 31 00 9b 8d 07 00 7c | 62 6d 35 32 00 e6 aa 07 |51.....||bm52....|
|00000360| 00 7c 62 6d 35 33 00 61 | b9 07 00 7c 62 6d 35 34 |.|bm53.a|...|bm54|
|00000370| 00 da ca 07 00 7c 62 6d | 35 35 00 53 dc 07 00 7c |.....|bm|55.S...||
|00000380| 62 6d 35 36 00 c4 eb 07 | 00 7c 62 6d 35 37 00 89 |bm56....|.|bm57..|
|00000390| 08 08 00 7c 62 6d 35 38 | 00 46 2d 08 00 7c 62 6d |...|bm58|.F-..|bm|
|000003a0| 35 39 00 56 40 08 00 7c | 62 6d 36 00 6e 4f 03 00 |59.V@..||bm6.nO..|
|000003b0| 7c 62 6d 36 30 00 22 53 | 08 00 7c 62 6d 36 31 00 ||bm60."S|..|bm61.|
|000003c0| 2e 62 08 00 7c 62 6d 36 | 32 00 39 67 08 00 7c 62 |.b..|bm6|2.9g..|b|
|000003d0| 6d 36 33 00 4d 6c 08 00 | 7c 62 6d 36 34 00 38 78 |m63.Ml..||bm64.8x|
|000003e0| 08 00 7c 62 6d 36 35 00 | b0 8f 08 00 7c 62 6d 36 |..|bm65.|....|bm6|
|000003f0| 36 00 38 9e 08 00 7c 62 | 6d 36 37 00 7c ae 08 00 |6.8...|b|m67.|...|
|00000400| 7c 62 6d 36 38 00 54 c2 | 08 00 7c 62 6d 36 39 00 ||bm68.T.|..|bm69.|
|00000410| ad d0 08 00 7c 62 6d 37 | 00 b0 5e 03 00 7c 62 6d |....|bm7|..^..|bm|
|00000420| 37 30 00 78 e6 08 00 7c | 62 6d 37 31 00 6f 01 09 |70.x...||bm71.o..|
|00000430| 00 7c 62 6d 37 32 00 5b | 10 09 00 7c 62 6d 37 33 |.|bm72.[|...|bm73|
|00000440| 00 b7 1c 09 00 7c 62 6d | 37 34 00 40 2f 09 00 7c |.....|bm|74.@/..||
|00000450| 62 6d 37 35 00 62 3e 09 | 00 7c 62 6d 37 36 00 4a |bm75.b>.|.|bm76.J|
|00000460| 52 09 00 7c 62 6d 37 37 | 00 32 66 09 00 7c 62 6d |R..|bm77|.2f..|bm|
|00000470| 37 38 00 f4 79 09 00 7c | 62 6d 37 39 00 b8 85 09 |78..y..||bm79....|
|00000480| 00 7c 62 6d 38 00 31 79 | 03 00 7c 62 6d 38 30 00 |.|bm8.1y|..|bm80.|
|00000490| 6c a7 09 00 7c 62 6d 38 | 31 00 1a ba 09 00 7c 62 |l...|bm8|1.....|b|
|000004a0| 6d 38 32 00 e8 dd 09 00 | 7c 62 6d 38 33 00 68 f0 |m82.....||bm83.h.|
|000004b0| 09 00 7c 62 6d 38 34 00 | 3c 02 0a 00 7c 62 6d 38 |..|bm84.|<...|bm8|
|000004c0| 35 00 99 12 0a 00 7c 62 | 6d 38 36 00 01 24 0a 00 |5.....|b|m86..$..|
|000004d0| 7c 62 6d 38 37 00 37 2f | 0a 00 7c 62 6d 38 38 00 ||bm87.7/|..|bm88.|
|000004e0| 31 35 0a 00 7c 62 6d 38 | 39 00 02 3d 0a 00 7c 62 |15..|bm8|9..=..|b|
|000004f0| 6d 39 00 f3 9d 03 00 7c | 62 6d 39 30 00 40 42 0a |m9.....||bm90.@B.|
|00000500| 00 00 17 00 17 00 17 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000510| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000520| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000530| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000540| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000550| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000560| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000570| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000580| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000590| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000005a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000005b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000005c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000005d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000005e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000005f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000600| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000610| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000620| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000630| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000640| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000650| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000660| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000670| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000680| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000690| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000006a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000006b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000006c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000006d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000006e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000006f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000700| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000710| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000720| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000730| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000740| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000750| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000760| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000770| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000780| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000790| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000007a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000007b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000007c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000007d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000007e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000007f0| 00 00 00 00 00 00 00 8d | 34 02 00 84 34 02 00 20 |........|4...4.. |
|00000800| ff ff ff ff 0c 00 00 00 | 00 00 00 00 42 00 00 00 |........|....B...|
|00000810| 11 00 00 00 ff ff ff ff | 4e 00 00 00 31 00 00 00 |........|N...1...|
|00000820| 02 b2 11 00 00 ff ff ff | ff ff ff ff ff 00 00 00 |........|........|
|00000830| 00 4e 00 00 00 7c 00 00 | 00 09 42 00 00 41 44 41 |.N...|..|..B..ADA|
|00000840| 42 41 53 20 44 20 54 75 | 74 6f 72 69 61 6c 2e 00 |BAS D Tu|torial..|
|00000850| 00 00 0b 00 00 00 0c 00 | 00 00 7c 00 00 00 23 00 |........|..|...#.|
|00000860| 00 00 20 16 80 16 00 80 | 00 00 00 00 80 03 00 82 |.. .....|........|
|00000870| ff 00 43 6f 6e 74 65 6e | 74 73 00 00 28 00 00 00 |..Conten|ts..(...|
|00000880| 03 00 00 00 4e 00 00 00 | a4 00 00 00 25 00 00 00 |....N...|....%...|
|00000890| 20 1a 80 06 00 80 00 00 | 0a 00 94 b8 80 04 00 82 | .......|........|
|000008a0| ff 00 00 00 48 00 00 00 | 19 00 00 00 7c 00 00 00 |....H...|....|...|
|000008b0| ec 00 00 00 2f 00 00 00 | 20 2e 80 32 00 80 00 00 |..../...| ..2....|
|000008c0| 0e 00 84 8c b8 e3 0d 45 | 55 2c 80 05 00 89 80 06 |.......E|U,......|
|000008d0| 00 82 ff 00 00 4f 72 64 | 65 72 69 6e 67 20 74 68 |.....Ord|ering th|
|000008e0| 65 20 4d 61 6e 75 61 6c | 00 00 00 00 34 00 00 00 |e Manual|....4...|
|000008f0| 0f 00 00 00 a4 00 00 00 | 20 01 00 00 25 00 00 00 |........| ...%...|
|00000900| 20 1a 80 1e 00 80 00 00 | 06 00 b0 98 80 07 00 82 | .......|........|
|00000910| ff 00 49 6e 74 72 6f 64 | 75 63 74 69 6f 6e 00 00 |..Introd|uction..|
|00000920| 41 00 00 00 12 00 00 00 | ec 00 00 00 61 01 00 00 |A.......|....a...|
|00000930| 2f 00 00 00 20 2e 80 24 | 00 80 00 00 0e 00 84 8c |/... ..$|........|
|00000940| b8 e3 f9 3c 50 9c 80 05 | 00 89 80 06 00 82 ff 00 |...<P...|........|
|00000950| 00 49 6e 74 72 6f 64 75 | 63 74 69 6f 6e 00 00 00 |.Introdu|ction...|
|00000960| 00 34 00 00 00 0f 00 00 | 00 20 01 00 00 95 01 00 |.4......|. ......|
|00000970| 00 25 00 00 00 20 1a 80 | 1e 00 80 00 00 06 00 b0 |.%... ..|........|
|00000980| 98 80 07 00 82 ff 00 46 | 75 6e 64 61 6d 65 6e 74 |.......F|undament|
|00000990| 61 6c 73 00 00 cd 01 00 | 00 28 01 00 00 61 01 00 |als.....|.(...a..|
|000009a0| 00 62 03 00 00 a5 00 00 | 00 20 18 81 51 02 00 80 |.b......|. ..Q...|
|000009b0| 00 00 0e 00 84 8c b8 e3 | ce 22 0e 36 80 05 00 89 |........|.".6....|
|000009c0| 80 06 00 82 e3 04 fb 4d | c9 80 05 00 89 80 06 00 |.......M|........|
|000009d0| 82 e3 a4 1a 3d f1 80 05 | 00 89 80 06 00 82 e3 e8 |....=...|........|
|000009e0| 94 b9 6e 80 05 00 89 80 | 06 00 82 e3 38 06 6d 7e |..n.....|....8.m~|
|000009f0| 80 05 00 89 80 06 00 82 | e3 ca d1 8f 7b 80 05 00 |........|....{...|
|00000a00| 89 80 06 00 82 e3 90 28 | c0 f7 80 05 00 89 80 06 |.......(|........|
|00000a10| 00 82 e3 13 37 8b 27 80 | 05 00 89 80 06 00 82 e3 |....7.'.|........|
|00000a20| 9e 4f 82 dc 80 05 00 89 | 80 06 00 82 e3 5d 9e a3 |.O......|.....]..|
|00000a30| c1 80 05 00 89 80 06 00 | 82 ff 00 00 46 75 6e 64 |........|....Fund|
|00000a40| 61 6d 65 6e 74 61 6c 73 | 00 00 00 00 00 45 78 61 |amentals|.....Exa|
|00000a50| 6d 70 6c 65 a0 6f 66 a0 | 61 a0 53 45 4c 45 43 54 |mple.of.|a.SELECT|
|00000a60| a0 53 74 61 74 65 6d 65 | 6e 74 00 00 00 00 00 53 |.Stateme|nt.....S|
|00000a70| 65 6c 65 63 74 69 6e 67 | a0 50 61 72 74 69 63 75 |electing|.Particu|
|00000a80| 6c 61 72 a0 43 6f 6c 75 | 6d 6e 73 00 00 00 00 00 |lar.Colu|mns.....|
|00000a90| 4f 72 64 65 72 69 6e 67 | a0 43 6f 6c 75 6d 6e 73 |Ordering|.Columns|
|00000aa0| 00 00 00 00 00 53 65 6c | 65 63 74 69 6e 67 a0 50 |.....Sel|ecting.P|
|00000ab0| 61 72 74 69 63 75 6c 61 | 72 a0 52 6f 77 73 00 00 |articula|r.Rows..|
|00000ac0| 00 00 00 4f 72 64 65 72 | 69 6e 67 a0 52 6f 77 73 |...Order|ing.Rows|
|00000ad0| 00 00 00 00 00 4f 72 64 | 65 72 69 6e 67 a0 41 63 |.....Ord|ering.Ac|
|00000ae0| 63 6f 72 64 69 6e 67 a0 | 74 6f a0 4d 6f 72 65 a0 |cording.|to.More.|
|00000af0| 74 68 61 6e a0 4f 6e 65 | a0 43 6f 6c 75 6d 6e 00 |than.One|.Column.|
|00000b00| 00 00 00 00 45 6c 69 6d | 69 6e 61 74 69 6e 67 a0 |....Elim|inating.|
|00000b10| 44 75 70 6c 69 63 61 74 | 65 a0 52 6f 77 73 00 00 |Duplicat|e.Rows..|
|00000b20| 00 00 00 4b 65 65 70 69 | 6e 67 a0 52 65 73 75 6c |...Keepi|ng.Resul|
|00000b30| 74 a0 53 65 74 73 00 00 | 00 00 00 49 6e 74 72 6f |t.Sets..|...Intro|
|00000b40| 64 75 63 69 6e 67 a0 4e | 65 77 a0 52 65 73 75 6c |ducing.N|ew.Resul|
|00000b50| 74 a0 43 6f 6c 75 6d 6e | a0 4e 61 6d 65 73 00 00 |t.Column|.Names..|
|00000b60| 00 00 3d 00 00 00 18 00 | 00 00 95 01 00 00 9f 03 |..=.....|........|
|00000b70| 00 00 25 00 00 00 20 1a | 80 30 00 80 00 00 06 00 |..%... .|.0......|
|00000b80| b0 98 80 07 00 82 ff 00 | 43 6f 6e 64 69 74 69 6f |........|Conditio|
|00000b90| 6e 61 6c a0 53 65 6c 65 | 63 74 69 6f 6e 00 00 e8 |nal.Sele|ction...|
|00000ba0| 01 00 00 43 01 00 00 62 | 03 00 00 87 05 00 00 a5 |...C...b|........|
|00000bb0| 00 00 00 20 18 81 87 02 | 00 80 00 00 0e 00 84 8c |... ....|........|
|00000bc0| b8 e3 c5 33 81 46 80 05 | 00 89 80 06 00 82 e3 c7 |...3.F..|........|
|00000bd0| 0a a6 d0 80 05 00 89 80 | 06 00 82 e3 2d 5d 6e 58 |........|....-]nX|
|00000be0| 80 05 00 89 80 06 00 82 | e3 6c e1 45 af 80 05 00 |........|.l.E....|
|00000bf0| 89 80 06 00 82 e3 60 9d | 1f 85 80 05 00 89 80 06 |......`.|........|
|00000c00| 00 82 e3 80 8d 60 b7 80 | 05 00 89 80 06 00 82 e3 |.....`..|........|
|00000c10| 23 f3 7f 9a 80 05 00 89 | 80 06 00 82 e3 d2 59 a5 |#.......|......Y.|
|00000c20| be 80 05 00 89 80 06 00 | 82 e3 12 54 07 75 80 05 |........|...T.u..|
|00000c30| 00 89 80 06 00 82 e3 2b | 3f c8 cd 80 05 00 89 80 |.......+|?.......|
|00000c40| 06 00 82 ff 00 00 43 6f | 6e 64 69 74 69 6f 6e 61 |......Co|nditiona|
|00000c50| 6c a0 53 65 6c 65 63 74 | 69 6f 6e 00 00 00 00 00 |l.Select|ion.....|
|00000c60| 43 6f 6d 70 61 72 69 73 | 6f 6e a0 4f 70 65 72 61 |Comparis|on.Opera|
|00000c70| 74 69 6f 6e 73 00 00 00 | 00 00 4d 75 6c 74 69 70 |tions...|..Multip|
|00000c80| 6c 65 a0 43 6f 6e 64 69 | 74 69 6f 6e 73 3a a0 41 |le.Condi|tions:.A|
|00000c90| 4e 44 2c a0 4f 52 00 00 | 00 00 00 52 61 6e 67 65 |ND,.OR..|...Range|
|00000ca0| 73 a0 6f 66 a0 56 61 6c | 75 65 73 3a a0 42 45 54 |s.of.Val|ues:.BET|
|00000cb0| 57 45 45 4e a0 78 a0 41 | 4e 44 a0 79 00 00 00 00 |WEEN.x.A|ND.y....|
|00000cc0| 00 56 61 6c 75 65 73 a0 | 69 6e a0 61 a0 53 65 74 |.Values.|in.a.Set|
|00000cd0| 3a a0 49 4e a0 28 78 2c | 79 2c 7a 29 00 00 00 00 |:.IN.(x,|y,z)....|
|00000ce0| 00 53 65 61 72 63 68 69 | 6e 67 a0 46 6f 72 a0 43 |.Searchi|ng.For.C|
|00000cf0| 68 61 72 61 63 74 65 72 | a0 53 74 72 69 6e 67 73 |haracter|.Strings|
|00000d00| 00 00 00 00 00 4e 65 67 | 61 74 69 76 65 a0 43 6f |.....Neg|ative.Co|
|00000d10| 6e 64 69 74 69 6f 6e 73 | 3a a0 4e 4f 54 00 00 00 |nditions|:.NOT...|
|00000d20| 00 00 4e 4f 54 a0 77 69 | 74 68 a0 4e 55 4c 4c 2c |..NOT.wi|th.NULL,|
|00000d30| a0 4c 49 4b 45 2c a0 49 | 4e 2c a0 42 45 54 57 45 |.LIKE,.I|N,.BETWE|
|00000d40| 45 4e 00 00 00 00 00 47 | 72 6f 75 70 69 6e 67 a0 |EN.....G|rouping.|
|00000d50| 56 61 6c 75 65 73 3a a0 | 47 52 4f 55 50 a0 42 59 |Values:.|GROUP.BY|
|00000d60| 00 00 00 00 00 47 72 6f | 75 70 73 a0 77 69 74 68 |.....Gro|ups.with|
|00000d70| a0 43 6f 6e 64 69 74 69 | 6f 6e 73 3a a0 48 41 56 |.Conditi|ons:.HAV|
|00000d80| 49 4e 47 00 00 00 00 3e | 00 00 00 19 00 00 00 9f |ING....>|........|
|00000d90| 03 00 00 c5 05 00 00 25 | 00 00 00 20 1a 80 32 00 |.......%|... ..2.|
|00000da0| 80 00 00 06 00 b0 98 80 | 07 00 82 ff 00 56 69 72 |........|.....Vir|
|00000db0| 74 75 61 6c a0 52 65 73 | 75 6c 74 a0 43 6f 6c 75 |tual.Res|ult.Colu|
|00000dc0| 6d 6e 73 00 00 e0 01 00 | 00 3b 01 00 00 87 05 00 |mns.....|.;......|
|00000dd0| 00 a5 07 00 00 a5 00 00 | 00 20 18 81 77 02 00 80 |........|. ..w...|
|00000de0| 00 00 0e 00 84 8c b8 e3 | 9c 3a bd c7 80 05 00 89 |........|.:......|
|00000df0| 80 06 00 82 e3 01 f3 0c | de 80 05 00 89 80 06 00 |........|........|
|00000e00| 82 e3 33 5c 32 76 80 05 | 00 89 80 06 00 82 e3 74 |..3\2v..|.......t|
|00000e10| 5e 2f c0 80 05 00 89 80 | 06 00 82 e3 d0 50 25 94 |^/......|.....P%.|
|00000e20| 80 05 00 89 80 06 00 82 | e3 4b 98 21 f8 80 05 00 |........|.K.!....|
|00000e30| 89 80 06 00 82 e3 65 af | 74 f9 80 05 00 89 80 06 |......e.|t.......|
|00000e40| 00 82 e3 52 ac cf 04 80 | 05 00 89 80 06 00 82 e3 |...R....|........|
|00000e50| 90 4f 4e 95 80 05 00 89 | 80 06 00 82 e3 da 0a 03 |.ON.....|........|
|00000e60| 7c 80 05 00 89 80 06 00 | 82 ff 00 00 45 78 70 61 ||.......|....Expa|
|00000e70| 6e 64 69 6e 67 a0 74 68 | 65 a0 53 61 6d 70 6c 65 |nding.th|e.Sample|
|00000e80| 00 00 00 00 00 41 72 69 | 74 68 6d 65 74 69 63 a0 |.....Ari|thmetic.|
|00000e90| 77 69 74 68 69 6e a0 74 | 68 65 a0 52 65 73 75 6c |within.t|he.Resul|
|00000ea0| 74 a0 4c 69 73 74 00 00 | 00 00 00 45 78 70 72 65 |t.List..|...Expre|
|00000eb0| 73 73 69 6f 6e 73 a0 77 | 69 74 68 a0 2b 2c a0 2d |ssions.w|ith.+,.-|
|00000ec0| 2c a0 2a 2c a0 2f a0 2c | a0 44 49 56 2c a0 4d 4f |,.*,./.,|.DIV,.MO|
|00000ed0| 44 00 00 00 00 00 41 72 | 69 74 68 6d 65 74 69 63 |D.....Ar|ithmetic|
|00000ee0| a0 4f 70 65 72 61 74 69 | 6f 6e 73 00 00 00 00 00 |.Operati|ons.....|
|00000ef0| 54 72 69 67 6f 6e 6f 6d | 65 74 72 69 63 a0 46 75 |Trigonom|etric.Fu|
|00000f00| 6e 63 74 69 6f 6e 73 00 | 00 00 00 00 44 61 74 65 |nctions.|....Date|
|00000f10| a0 61 6e 64 a0 54 69 6d | 65 a0 43 61 6c 63 75 6c |.and.Tim|e.Calcul|
|00000f20| 61 74 69 6f 6e 73 00 00 | 00 00 00 45 76 61 6c 75 |ations..|...Evalu|
|00000f30| 61 74 69 6f 6e a0 53 65 | 71 75 65 6e 63 65 00 00 |ation.Se|quence..|
|00000f40| 00 00 00 41 72 69 74 68 | 6d 65 74 69 63 a0 69 6e |...Arith|metic.in|
|00000f50| a0 61 a0 43 6f 6e 64 69 | 74 69 6f 6e 00 00 00 00 |.a.Condi|tion....|
|00000f60| 00 43 6f 6c 75 6d 6e 73 | a0 77 69 74 68 a0 53 65 |.Columns|.with.Se|
|00000f70| 74 a0 46 75 6e 63 74 69 | 6f 6e 73 00 00 00 00 00 |t.Functi|ons.....|
|00000f80| 4f 70 65 72 61 74 69 6f | 6e 73 a0 77 69 74 68 a0 |Operatio|ns.with.|
|00000f90| 43 68 61 72 61 63 74 65 | 72 a0 53 74 72 69 6e 67 |Characte|r.String|
|00000fa0| 73 00 00 00 00 32 00 00 | 00 0d 00 00 00 c5 05 00 |s....2..|........|
|00000fb0| 00 d7 07 00 00 25 00 00 | 00 20 1a 80 1a 00 80 00 |.....%..|. ......|
|00000fc0| 00 06 00 b0 98 80 07 00 | 82 ff 00 53 75 62 71 75 |........|...Subqu|
|00000fd0| 65 72 69 65 73 00 00 66 | 00 00 00 2a 00 00 00 a5 |eries..f|...*....|
|00000fe0| 07 00 00 3d 08 00 00 3c | 00 00 00 20 48 80 54 00 |...=...<|... H.T.|
|00000ff0| 80 00 00 0e 00 84 8c b8 | e3 ec 16 32 1c 80 05 00 |........|...2....|
|00001000| 89 80 06 00 82 e3 0d f1 | 4c 8f 80 05 00 89 80 06 |........|L.......|
|00001010| 00 82 ff 00 00 49 4e 2c | a0 41 4c 4c 2c a0 41 4e |.....IN,|.ALL,.AN|
|00001020| 59 2c a0 45 58 49 53 54 | 53 00 00 00 00 00 43 6f |Y,.EXIST|S.....Co|
|00001030| 72 72 65 6c 61 74 69 6f | 6e 00 00 00 00 48 00 00 |rrelatio|n....H..|
|00001040| 00 23 00 00 00 d7 07 00 | 00 85 08 00 00 25 00 00 |.#......|.....%..|
|00001050| 00 20 1a 80 46 00 80 00 | 00 06 00 b0 98 80 07 00 |. ..F...|........|
|00001060| 82 ff 00 43 6f 6c 75 6d | 6e 73 a0 66 72 6f 6d a0 |...Colum|ns.from.|
|00001070| 54 77 6f a0 61 6e 64 a0 | 4d 6f 72 65 a0 54 61 62 |Two.and.|More.Tab|
|00001080| 6c 65 73 00 00 9b 00 00 | 00 52 00 00 00 3d 08 00 |les.....|.R...=..|
|00001090| 00 20 09 00 00 49 00 00 | 00 20 62 80 a4 00 80 00 |. ...I..|. b.....|
|000010a0| 00 0e 00 84 8c b8 e3 01 | 12 8e 86 80 05 00 89 80 |........|........|
|000010b0| 06 00 82 e3 a0 5b 6d 8c | 80 05 00 89 80 06 00 82 |.....[m.|........|
|000010c0| e3 50 8d 18 a8 80 05 00 | 89 80 06 00 82 ff 00 00 |.P......|........|
|000010d0| 49 6e 66 6f 72 6d 61 74 | 69 6f 6e a0 66 72 6f 6d |Informat|ion.from|
|000010e0| a0 54 77 6f a0 54 61 62 | 6c 65 73 00 00 00 00 00 |.Two.Tab|les.....|
|000010f0| 49 6e 66 6f 72 6d 61 74 | 69 6f 6e a0 66 72 6f 6d |Informat|ion.from|
|00001100| a0 54 68 72 65 65 a0 54 | 61 62 6c 65 73 00 00 00 |.Three.T|ables...|
|00001110| 00 00 4f 75 74 65 72 a0 | 4a 6f 69 6e 00 00 00 00 |..Outer.|Join....|
|00001120| 36 00 00 00 11 00 00 00 | 85 08 00 00 56 09 00 00 |6.......|....V...|
|00001130| 25 00 00 00 20 1a 80 22 | 00 80 00 00 06 00 b0 98 |%... .."|........|
|00001140| 80 07 00 82 ff 00 53 65 | 74 a0 4f 70 65 72 61 74 |......Se|t.Operat|
|00001150| 69 6f 6e 73 00 00 8d 00 | 00 00 37 00 00 00 20 09 |ions....|..7... .|
|00001160| 00 00 e3 09 00 00 56 00 | 00 00 20 7c 80 6e 00 80 |......V.|.. |.n..|
|00001170| 00 00 0e 00 84 8c b8 e3 | 82 4c ed 32 80 05 00 89 |........|.L.2....|
|00001180| 80 06 00 82 e3 4e fe 1c | ae 80 05 00 89 80 06 00 |.....N..|........|
|00001190| 82 e3 97 72 ca 2a 80 05 | 00 89 80 06 00 82 e3 e2 |...r.*..|........|
|000011a0| 2f 2e 03 80 05 00 89 80 | 06 00 82 ff 00 00 53 65 |/.......|......Se|
|000011b0| 74 a0 4f 70 65 72 61 74 | 69 6f 6e 73 00 00 00 00 |t.Operat|ions....|
|000011c0| 00 55 4e 49 4f 4e 00 00 | 00 00 00 49 4e 54 45 52 |.UNION..|...INTER|
|000011d0| 53 45 43 54 00 00 00 00 | 00 45 58 43 45 50 54 00 |SECT....|.EXCEPT.|
|000011e0| 00 00 00 43 00 00 00 1e | 00 00 00 56 09 00 00 26 |...C....|...V...&|
|000011f0| 0a 00 00 25 00 00 00 20 | 1a 80 3c 00 80 00 00 06 |...%... |..<.....|
|00001200| 00 b0 98 80 07 00 82 ff | 00 44 61 74 61 a0 44 65 |........|.Data.De|
|00001210| 66 69 6e 69 74 69 6f 6e | a0 61 6e 64 a0 45 6e 74 |finition|.and.Ent|
|00001220| 72 69 65 73 00 00 21 02 | 00 00 48 01 00 00 e3 09 |ries..!.|..H.....|
|00001230| 00 00 47 0c 00 00 d9 00 | 00 00 20 80 81 91 02 00 |..G.....|.. .....|
|00001240| 80 00 00 0e 00 84 8c b8 | e3 3a 2b 07 ea 80 05 00 |........|.:+.....|
|00001250| 89 80 06 00 82 e3 e8 eb | 11 1e 80 05 00 89 80 06 |........|........|
|00001260| 00 82 e3 36 16 14 b7 80 | 05 00 89 80 06 00 82 e3 |...6....|........|
|00001270| 5b c8 f3 d1 80 05 00 89 | 80 06 00 82 e3 c2 a1 f6 |[.......|........|
|00001280| e6 80 05 00 89 80 06 00 | 82 e3 dd ed 73 00 80 05 |........|....s...|
|00001290| 00 89 80 06 00 82 e3 66 | c8 65 c9 80 05 00 89 80 |.......f|.e......|
|000012a0| 06 00 82 e3 f2 52 ac 06 | 80 05 00 89 80 06 00 82 |.....R..|........|
|000012b0| e3 49 2c 02 99 80 05 00 | 89 80 06 00 82 e3 ac 8f |.I,.....|........|
|000012c0| 1c 39 80 05 00 89 80 06 | 00 82 e3 6e eb 4c d1 80 |.9......|...n.L..|
|000012d0| 05 00 89 80 06 00 82 e3 | ae 38 41 ec 80 05 00 89 |........|.8A.....|
|000012e0| 80 06 00 82 e3 79 ab b0 | c5 80 05 00 89 80 06 00 |.....y..|........|
|000012f0| 82 e3 f4 2b 13 39 80 05 | 00 89 80 06 00 82 ff 00 |...+.9..|........|
|00001300| 00 43 72 65 61 74 69 6e | 67 a0 61 a0 54 61 62 6c |.Creatin|g.a.Tabl|
|00001310| 65 00 00 00 00 00 44 61 | 74 61 a0 54 79 70 65 73 |e.....Da|ta.Types|
|00001320| a0 69 6e a0 61 a0 54 61 | 62 6c 65 00 00 00 00 00 |.in.a.Ta|ble.....|
|00001330| 43 6f 6c 75 6d 6e a0 43 | 6f 6e 73 74 72 61 69 6e |Column.C|onstrain|
|00001340| 74 73 00 00 00 00 00 52 | 65 70 6c 69 63 61 74 65 |ts.....R|eplicate|
|00001350| 64 a0 54 61 62 6c 65 73 | 00 00 00 00 00 49 6e 73 |d.Tables|.....Ins|
|00001360| 65 72 74 69 6e 67 a0 52 | 6f 77 73 00 00 00 00 00 |erting.R|ows.....|
|00001370| 55 70 64 61 74 69 6e 67 | a0 52 6f 77 73 00 00 00 |Updating|.Rows...|
|00001380| 00 00 44 65 6c 65 74 69 | 6e 67 a0 52 6f 77 73 00 |..Deleti|ng.Rows.|
|00001390| 00 00 00 00 52 65 6c 61 | 74 69 6f 6e 73 a0 62 65 |....Rela|tions.be|
|000013a0| 74 77 65 65 6e a0 54 61 | 62 6c 65 73 00 00 00 00 |tween.Ta|bles....|
|000013b0| 00 55 70 64 61 74 69 6e | 67 a0 43 6f 6c 75 6d 6e |.Updatin|g.Column|
|000013c0| a0 44 65 66 69 6e 69 74 | 69 6f 6e 73 00 00 00 00 |.Definit|ions....|
|000013d0| 00 53 68 6f 72 74 a0 4e | 61 6d 65 73 a0 66 6f 72 |.Short.N|ames.for|
|000013e0| a0 61 a0 54 61 62 6c 65 | 00 00 00 00 00 43 72 65 |.a.Table|.....Cre|
|000013f0| 61 74 69 6e 67 a0 56 69 | 65 77 73 00 00 00 00 00 |ating.Vi|ews.....|
|00001400| 43 72 65 61 74 69 6e 67 | a0 53 6e 61 70 73 68 6f |Creating|.Snapsho|
|00001410| 74 a0 54 61 62 6c 65 73 | 00 00 00 00 00 43 72 65 |t.Tables|.....Cre|
|00001420| 61 74 69 6e 67 a0 61 6e | a0 49 6e 64 65 78 00 00 |ating.an|.Index..|
|00001430| 00 00 00 43 72 65 61 74 | 69 6e 67 a0 44 6f 6d 61 |...Creat|ing.Doma|
|00001440| 69 6e 73 00 00 00 00 ba | 00 00 00 57 00 00 00 26 |ins.....|...W...&|
|00001450| 0a 00 00 01 0d 00 00 63 | 00 00 00 20 96 80 ae 00 |.......c|... ....|
|00001460| 80 00 00 0e 00 84 8c b8 | e3 21 e0 b5 fc 80 05 00 |........|.!......|
|00001470| 89 80 06 00 82 e3 dc 51 | e2 52 80 05 00 89 80 06 |.......Q|.R......|
|00001480| 00 82 e3 4d 93 f1 3c 80 | 05 00 89 80 06 00 82 e3 |...M..<.|........|
|00001490| 48 e8 a8 2d 80 05 00 89 | 80 06 00 82 e3 13 31 e2 |H..-....|......1.|
|000014a0| e8 80 05 00 89 80 06 00 | 82 ff 00 00 44 42 a0 50 |........|....DB.P|
|000014b0| 72 6f 63 65 64 75 72 65 | 73 00 00 00 00 00 54 72 |rocedure|s.....Tr|
|000014c0| 69 67 67 65 72 73 00 00 | 00 00 00 44 42 a0 46 75 |iggers..|...DB.Fu|
|000014d0| 6e 63 74 69 6f 6e 73 00 | 00 00 00 00 44 72 6f 70 |nctions.|....Drop|
|000014e0| 70 69 6e 67 a0 4f 62 6a | 65 63 74 73 00 00 00 00 |ping.Obj|ects....|
|000014f0| 00 54 72 61 6e 73 61 63 | 74 69 6f 6e 73 00 00 00 |.Transac|tions...|
|00001500| 00 3d 00 00 00 18 00 00 | 00 47 0c 00 00 3e 0d 00 |.=......|.G...>..|
|00001510| 00 25 00 00 00 20 1a 80 | 30 00 80 00 00 06 00 b0 |.%... ..|0.......|
|00001520| 98 80 07 00 82 ff 00 41 | 63 63 65 73 73 69 6e 67 |.......A|ccessing|
|00001530| a0 53 69 6e 67 6c 65 a0 | 52 6f 77 73 00 00 f0 00 |.Single.|Rows....|
|00001540| 00 00 8c 00 00 00 01 0d | 00 00 2e 0e 00 00 64 00 |........|......d.|
|00001550| 00 00 20 96 80 19 01 00 | 80 00 00 0e 00 84 8c b8 |.. .....|........|
|00001560| e3 30 52 17 60 80 05 00 | 89 80 06 00 82 e3 6d 9e |.0R.`...|......m.|
|00001570| c2 d1 80 05 00 89 80 06 | 00 82 e3 71 f4 be 49 80 |........|...q..I.|
|00001580| 05 00 89 80 06 00 82 e3 | 26 71 3d a9 80 05 00 89 |........|&q=.....|
|00001590| 80 06 00 82 e3 ea 84 e7 | da 80 05 00 89 80 06 00 |........|........|
|000015a0| 82 ff 00 00 4b 65 79 a0 | 43 6f 6e 63 65 70 74 00 |....Key.|Concept.|
|000015b0| 00 00 00 00 44 69 72 65 | 63 74 a0 41 63 63 65 73 |....Dire|ct.Acces|
|000015c0| 73 a0 55 73 69 6e 67 a0 | 61 a0 4b 65 79 00 00 00 |s.Using.|a.Key...|
|000015d0| 00 00 50 6f 73 69 74 69 | 6f 6e 2d 62 61 73 65 64 |..Positi|on-based|
|000015e0| a0 41 63 63 65 73 73 a0 | 55 73 69 6e 67 a0 61 a0 |.Access.|Using.a.|
|000015f0| 4b 65 79 00 00 00 00 00 | 43 6f 6e 64 69 74 69 6f |Key.....|Conditio|
|00001600| 6e 61 6c a0 50 6f 73 69 | 74 69 6f 6e 2d 62 61 73 |nal.Posi|tion-bas|
|00001610| 65 64 a0 41 63 63 65 73 | 73 00 00 00 00 00 4d 75 |ed.Acces|s.....Mu|
|00001620| 6c 74 69 70 6c 65 a0 4b | 65 79 00 00 00 00 35 00 |ltiple.K|ey....5.|
|00001630| 00 00 10 00 00 00 3e 0d | 00 00 63 0e 00 00 25 00 |......>.|..c...%.|
|00001640| 00 00 20 1a 80 20 00 80 | 00 00 06 00 b0 98 80 07 |.. .. ..|........|
|00001650| 00 82 ff 00 41 75 74 68 | 6f 72 69 7a 61 74 69 6f |....Auth|orizatio|
|00001660| 6e 00 00 d4 00 00 00 7e | 00 00 00 2e 0e 00 00 37 |n......~|.......7|
|00001670| 0f 00 00 56 00 00 00 20 | 7c 80 fc 00 80 00 00 0e |...V... ||.......|
|00001680| 00 84 8c b8 e3 67 cd a5 | b3 80 05 00 89 80 06 00 |.....g..|........|
|00001690| 82 e3 d3 15 23 75 80 05 | 00 89 80 06 00 82 e3 ee |....#u..|........|
|000016a0| 4a 6e d4 80 05 00 89 80 | 06 00 82 e3 21 74 16 7d |Jn......|....!t.}|
|000016b0| 80 05 00 89 80 06 00 82 | ff 00 00 55 73 65 72 a0 |........|...User.|
|000016c0| 43 6c 61 73 73 65 73 00 | 00 00 00 00 54 68 65 a0 |Classes.|....The.|
|000016d0| 53 59 53 44 42 41 a0 49 | 6e 73 74 61 6c 6c 73 a0 |SYSDBA.I|nstalls.|
|000016e0| 44 42 41 73 00 00 00 00 | 00 54 68 65 a0 44 42 41 |DBAs....|.The.DBA|
|000016f0| 73 a0 49 6e 73 74 61 6c | 6c a0 41 64 64 69 74 69 |s.Instal|l.Additi|
|00001700| 6f 6e 61 6c a0 55 73 65 | 72 73 00 00 00 00 00 4d |onal.Use|rs.....M|
|00001710| 6f 64 69 66 79 69 6e 67 | a0 61 6e 64 a0 52 65 6d |odifying|.and.Rem|
|00001720| 6f 76 69 6e 67 a0 55 73 | 65 72 a0 50 72 6f 66 69 |oving.Us|er.Profi|
|00001730| 6c 65 73 00 00 00 00 3b | 00 00 00 16 00 00 00 63 |les....;|.......c|
|00001740| 0e 00 00 72 0f 00 00 25 | 00 00 00 20 1a 80 2c 00 |...r...%|... ..,.|
|00001750| 80 00 00 06 00 b0 98 80 | 07 00 82 ff 00 43 61 74 |........|.....Cat|
|00001760| 61 6c 6f 67 a0 49 6e 66 | 6f 72 6d 61 74 69 6f 6e |alog.Inf|ormation|
|00001770| 00 00 c2 01 00 00 f6 00 | 00 00 37 0f 00 00 40 41 |........|..7...@A|
|00001780| 00 00 cc 00 00 00 20 66 | 81 ed 01 00 80 00 00 0e |...... f|........|
|00001790| 00 84 8c b8 e3 14 65 d9 | 40 80 05 00 89 80 06 00 |......e.|@.......|
|000017a0| 82 e3 f3 c7 e1 b8 80 05 | 00 89 80 06 00 82 e3 2e |........|........|
|000017b0| 26 5d fa 80 05 00 89 80 | 06 00 82 e3 a8 72 dd 82 |&]......|.....r..|
|000017c0| 80 05 00 89 80 06 00 82 | e3 e5 d5 74 7a 80 05 00 |........|...tz...|
|000017d0| 89 80 06 00 82 e3 7c f4 | 49 db 80 05 00 89 80 06 |......|.|I.......|
|000017e0| 00 82 e3 53 28 c6 50 80 | 05 00 89 80 06 00 82 e3 |...S(.P.|........|
|000017f0| 19 f6 b5 37 80 05 00 89 | 80 06 00 82 e3 92 bd 65 |...7....|.......e|
|00001800| 72 0f 00 00 40 41 00 00 | 0c 00 00 00 e0 80 05 00 |r...@A..|........|
|00001810| 89 80 06 00 82 e3 7f 9a | 06 7e 80 05 00 89 80 06 |........|.~......|
|00001820| 00 82 e3 85 c7 b2 4b 80 | 05 00 89 80 06 00 82 e3 |......K.|........|
|00001830| b5 7a f5 6e 80 05 00 89 | 80 06 00 82 e3 03 6e 54 |.z.n....|......nT|
|00001840| ad 80 05 00 89 80 06 00 | 82 ff 00 00 43 61 74 61 |........|....Cata|
|00001850| 6c 6f 67 a0 49 6e 66 6f | 72 6d 61 74 69 6f 6e 00 |log.Info|rmation.|
|00001860| 00 00 00 00 54 61 62 6c | 65 73 00 00 00 00 00 44 |....Tabl|es.....D|
|00001870| 6f 6d 61 69 6e 73 00 00 | 00 00 00 43 6f 6e 73 74 |omains..|...Const|
|00001880| 72 61 69 6e 74 73 00 00 | 00 00 00 56 69 65 77 73 |raints..|...Views|
|00001890| 00 00 00 00 00 53 79 6e | 6f 6e 79 6d 73 00 00 00 |.....Syn|onyms...|
|000018a0| 00 00 50 72 69 6d 61 72 | 79 a0 4b 65 79 73 00 00 |..Primar|y.Keys..|
|000018b0| 00 00 00 49 6e 64 65 78 | 65 73 00 00 00 00 00 52 |...Index|es.....R|
|000018c0| 65 66 65 72 65 6e 74 69 | 61 6c a0 49 6e 74 65 67 |eferenti|al.Integ|
|000018d0| 72 69 74 79 a0 43 6f 6e | 73 74 72 61 69 6e 74 73 |rity.Con|straints|
|000018e0| 00 00 00 00 00 50 72 69 | 76 69 6c 65 67 65 73 00 |.....Pri|vileges.|
|000018f0| 00 00 00 00 55 73 65 72 | a0 50 72 6f 66 69 6c 65 |....User|.Profile|
|00001900| 73 00 00 00 00 00 41 64 | 6d 69 6e 69 73 74 72 61 |s.....Ad|ministra|
|00001910| 74 69 76 65 a0 49 6e 66 | 6f 72 6d 61 74 69 6f 6e |tive.Inf|ormation|
|00001920| 00 00 00 00 00 53 74 61 | 74 69 73 74 69 63 61 6c |.....Sta|tistical|
|00001930| a0 49 6e 66 6f 72 6d 61 | 74 69 6f 6e 00 00 00 00 |.Informa|tion....|
|00001940| 37 00 00 00 12 00 00 00 | 72 0f 00 00 77 41 00 00 |7.......|r...wA..|
|00001950| 25 00 00 00 20 1a 80 24 | 00 80 00 00 06 00 b0 98 |%... ..$|........|
|00001960| 80 07 00 82 ff 00 54 68 | 65 a0 54 61 62 6c 65 73 |......Th|e.Tables|
|00001970| a0 55 73 65 64 00 00 44 | 00 00 00 15 00 00 00 40 |.Used..D|.......@|
|00001980| 41 00 00 bb 41 00 00 2f | 00 00 00 20 2e 80 2a 00 |A...A../|... ..*.|
|00001990| 80 00 00 0e 00 84 8c b8 | e3 aa 6c b5 30 80 05 00 |........|..l.0...|
|000019a0| 89 80 06 00 82 ff 00 00 | 54 68 65 a0 54 61 62 6c |........|The.Tabl|
|000019b0| 65 73 a0 55 73 65 64 00 | 00 00 00 26 00 00 00 03 |es.Used.|...&....|
|000019c0| 00 00 00 77 41 00 00 e1 | 41 00 00 23 00 00 00 20 |...wA...|A..#... |
|000019d0| 16 80 06 00 80 00 00 00 | 00 80 04 00 82 ff 00 00 |........|........|
|000019e0| 00 28 00 00 00 03 00 00 | 00 bb 41 00 00 09 42 00 |.(......|..A...B.|
|000019f0| 00 25 00 00 00 20 1a 80 | 06 00 80 00 00 06 00 bc |.%... ..|........|
|00001a00| 98 80 05 00 82 ff 00 00 | 00 44 00 00 00 13 00 00 |........|.D......|
|00001a10| 00 e1 41 00 00 4d 42 00 | 00 31 00 00 00 02 02 04 |..A..MB.|.1......|
|00001a20| 00 00 ff ff ff ff ff ff | ff ff 01 00 00 00 4d 42 |........|......MB|
|00001a30| 00 00 86 42 00 00 57 46 | 00 00 4f 72 64 65 72 69 |...B..WF|..Orderi|
|00001a40| 6e 67 20 74 68 65 20 4d | 61 6e 75 61 6c 39 00 00 |ng the M|anual9..|
|00001a50| 00 16 00 00 00 09 42 00 | 00 86 42 00 00 23 00 00 |......B.|..B..#..|
|00001a60| 00 20 16 80 2c 00 80 00 | 00 00 00 80 03 00 82 ff |. ..,...|........|
|00001a70| 00 4f 72 64 65 72 69 6e | 67 20 74 68 65 20 4d 61 |.Orderin|g the Ma|
|00001a80| 6e 75 61 6c 00 00 56 02 | 00 00 20 02 00 00 4d 42 |nual..V.|.. ...MB|
|00001a90| 00 00 dc 44 00 00 36 00 | 00 00 20 3a 80 41 04 00 |...D..6.|.. :.A..|
|00001aa0| 80 00 00 00 00 80 08 00 | 82 82 80 09 00 82 82 82 |........|........|
|00001ab0| 82 82 82 82 80 0a 00 80 | 0b 00 82 ff 00 20 00 4d |........|..... .M|
|00001ac0| 61 6e 75 61 6c 20 4f 72 | 64 65 72 20 4e 75 6d 62 |anual Or|der Numb|
|00001ad0| 65 72 3a 20 20 45 53 44 | 36 31 31 2d 30 32 31 41 |er:  ESD|611-021A|
|00001ae0| 4c 4c 00 00 20 00 54 68 | 69 73 20 6f 6e 6c 69 6e |LL.. .Th|is onlin|
|00001af0| 65 20 68 65 6c 70 20 69 | 73 20 61 70 70 6c 69 63 |e help i|s applic|
|00001b00| 61 62 6c 65 20 74 6f 20 | 41 44 41 42 41 53 20 44 |able to |ADABAS D|
|00001b10| 20 56 65 72 73 69 6f 6e | 20 36 2e 31 2e 31 20 50 | Version| 6.1.1 P|
|00001b20| 45 20 61 6e 64 20 74 6f | 20 61 6c 6c 20 73 75 62 |E and to| all sub|
|00001b30| 73 65 71 75 65 6e 74 20 | 72 65 6c 65 61 73 65 73 |sequent |releases|
|00001b40| 2c 20 75 6e 6c 65 73 73 | 20 6f 74 68 65 72 77 69 |, unless| otherwi|
|00001b50| 73 65 20 69 6e 64 69 63 | 61 74 65 64 20 69 6e 20 |se indic|ated in |
|00001b60| 6e 65 77 20 65 64 69 74 | 69 6f 6e 73 20 6f 72 20 |new edit|ions or |
|00001b70| 74 65 63 68 6e 69 63 61 | 6c 20 6e 65 77 73 6c 65 |technica|l newsle|
|00001b80| 74 74 65 72 73 2e 00 20 | 00 53 70 65 63 69 66 69 |tters.. |.Specifi|
|00001b90| 63 61 74 69 6f 6e 73 20 | 63 6f 6e 74 61 69 6e 65 |cations |containe|
|00001ba0| 64 20 68 65 72 65 69 6e | 20 61 72 65 20 73 75 62 |d herein| are sub|
|00001bb0| 6a 65 63 74 20 74 6f 20 | 63 68 61 6e 67 65 20 61 |ject to |change a|
|00001bc0| 6e 64 20 74 68 65 73 65 | 20 63 68 61 6e 67 65 73 |nd these| changes|
|00001bd0| 20 77 69 6c 6c 20 62 65 | 20 72 65 70 6f 72 74 65 | will be| reporte|
|00001be0| 64 20 69 6e 20 73 75 62 | 73 65 71 75 65 6e 74 20 |d in sub|sequent |
|00001bf0| 72 65 76 69 73 69 6f 6e | 73 20 6f 72 20 65 64 69 |revision|s or edi|
|00001c00| 74 69 6f 6e 73 2e 00 20 | 00 52 65 61 64 65 72 73 |tions.. |.Readers|
|00001c10| 27 20 63 6f 6d 6d 65 6e | 74 73 20 61 72 65 20 77 |' commen|ts are w|
|00001c20| 65 6c 63 6f 6d 65 64 2e | 20 43 6f 6d 6d 65 6e 74 |elcomed.| Comment|
|00001c30| 73 20 6d 61 79 20 62 65 | 20 61 64 64 72 65 73 73 |s may be| address|
|00001c40| 65 64 20 74 6f 20 74 68 | 65 20 44 6f 63 75 6d 65 |ed to th|e Docume|
|00001c50| 6e 74 61 74 69 6f 6e 20 | 44 65 70 61 72 74 6d 65 |ntation |Departme|
|00001c60| 6e 74 20 61 74 20 74 68 | 65 20 61 64 64 72 65 73 |nt at th|e addres|
|00001c70| 73 20 6f 6e 20 74 68 65 | 20 62 61 63 6b 20 63 6f |s on the| back co|
|00001c80| 76 65 72 2e 00 20 00 00 | d3 00 20 20 20 20 4e 6f |ver.. ..|..    No|
|00001c90| 76 65 6d 62 65 72 20 32 | 33 2c 20 31 39 39 35 2c |vember 2|3, 1995,|
|00001ca0| 20 53 4f 46 54 57 41 52 | 45 20 41 47 2c 20 47 65 | SOFTWAR|E AG, Ge|
|00001cb0| 72 6d 61 6e 79 20 26 20 | 53 4f 46 54 57 41 52 45 |rmany & |SOFTWARE|
|00001cc0| 20 41 47 20 6f 66 20 4e | 6f 72 74 68 20 41 6d 65 | AG of N|orth Ame|
|00001cd0| 72 69 63 61 2c 20 49 6e | 63 2e 00 00 3a 00 00 00 |rica, In|c...:...|
|00001ce0| 16 00 00 00 86 42 00 00 | 16 45 00 00 24 00 00 00 |.....B..|.E..$...|
|00001cf0| 20 18 80 2c 00 80 00 00 | 02 00 98 80 09 00 82 ff | ..,....|........|
|00001d00| 00 41 6c 6c 20 72 69 67 | 68 74 73 20 72 65 73 65 |.All rig|hts rese|
|00001d10| 72 76 65 64 00 00 41 01 | 00 00 1b 01 00 00 dc 44 |rved..A.|.......D|
|00001d20| 00 00 57 46 00 00 26 00 | 00 00 20 1a 80 37 02 00 |..WF..&.|.. ..7..|
|00001d30| 80 00 00 00 00 80 09 00 | 82 82 82 ff 00 50 72 69 |........|.....Pri|
|00001d40| 6e 74 65 64 20 69 6e 20 | 74 68 65 20 46 65 64 65 |nted in |the Fede|
|00001d50| 72 61 6c 20 52 65 70 75 | 62 6c 69 63 20 6f 66 20 |ral Repu|blic of |
|00001d60| 47 65 72 6d 61 6e 79 00 | 20 00 54 68 65 20 53 4f |Germany.| .The SO|
|00001d70| 46 54 57 41 52 45 20 41 | 47 20 64 6f 63 75 6d 65 |FTWARE A|G docume|
|00001d80| 6e 74 61 74 69 6f 6e 20 | 6f 66 74 65 6e 20 72 65 |ntation |often re|
|00001d90| 66 65 72 73 20 74 6f 20 | 6e 75 6d 65 72 6f 75 73 |fers to |numerous|
|00001da0| 20 68 61 72 64 77 61 72 | 65 20 61 6e 64 20 73 6f | hardwar|e and so|
|00001db0| 66 74 77 61 72 65 20 70 | 72 6f 64 75 63 74 73 20 |ftware p|roducts |
|00001dc0| 62 79 20 74 68 65 69 72 | 20 74 72 61 64 65 20 6e |by their| trade n|
|00001dd0| 61 6d 65 73 2e 20 49 6e | 20 6d 6f 73 74 2c 20 69 |ames. In| most, i|
|00001de0| 66 20 6e 6f 74 20 61 6c | 6c 20 63 61 73 65 73 2c |f not al|l cases,|
|00001df0| 20 74 68 65 73 65 20 64 | 65 73 69 67 6e 61 74 69 | these d|esignati|
|00001e00| 6f 6e 73 20 61 72 65 20 | 63 6c 61 69 6d 65 64 20 |ons are |claimed |
|00001e10| 61 73 20 74 72 61 64 65 | 6d 61 72 6b 73 20 6f 72 |as trade|marks or|
|00001e20| 20 72 65 67 69 73 74 65 | 72 65 64 20 74 72 61 64 | registe|red trad|
|00001e30| 65 6d 61 72 6b 73 20 62 | 79 20 74 68 65 69 72 20 |emarks b|y their |
|00001e40| 72 65 73 70 65 63 74 69 | 76 65 20 63 6f 6d 70 61 |respecti|ve compa|
|00001e50| 6e 69 65 73 2e 00 00 4c | 00 00 00 1b 00 00 00 16 |nies...L|........|
|00001e60| 45 00 00 a3 46 00 00 31 | 00 00 00 02 ae 08 00 00 |E...F..1|........|
|00001e70| ff ff ff ff ff ff ff ff | 02 00 00 00 a3 46 00 00 |........|.....F..|
|00001e80| d5 46 00 00 52 4f 00 00 | 49 6e 74 72 6f 64 75 63 |.F..RO..|Introduc|
|00001e90| 74 69 6f 6e 20 2d 20 49 | 6e 74 72 6f 64 75 63 74 |tion - I|ntroduct|
|00001ea0| 69 6f 6e 32 00 00 00 0f | 00 00 00 57 46 00 00 d5 |ion2....|...WF...|
|00001eb0| 46 00 00 23 00 00 00 20 | 16 80 1e 00 80 00 00 00 |F..#... |........|
|00001ec0| 00 80 03 00 82 ff 00 49 | 6e 74 72 6f 64 75 63 74 |.......I|ntroduct|
|00001ed0| 69 6f 6e 00 00 3a 02 00 | 00 0f 02 00 00 a3 46 00 |ion..:..|......F.|
|00001ee0| 00 0f 49 00 00 2b 00 00 | 00 20 24 80 1f 04 00 80 |..I..+..|. $.....|
|00001ef0| 00 00 10 00 e3 80 80 0c | 00 82 82 82 82 82 82 ff |........|........|
|00001f00| 00 20 00 41 44 41 42 41 | 53 20 44 20 69 73 20 61 |. .ADABA|S D is a|
|00001f10| 20 72 65 6c 61 74 69 6f | 6e 61 6c 20 64 61 74 61 | relatio|nal data|
|00001f20| 62 61 73 65 20 73 79 73 | 74 65 6d 20 77 69 74 68 |base sys|tem with|
|00001f30| 20 61 6e 20 53 51 4c 20 | 28 53 74 72 75 63 74 75 | an SQL |(Structu|
|00001f40| 72 65 64 20 51 75 65 72 | 79 20 4c 61 6e 67 75 61 |red Quer|y Langua|
|00001f50| 67 65 29 20 63 6f 6d 70 | 61 74 69 62 6c 65 20 6c |ge) comp|atible l|
|00001f60| 61 6e 67 75 61 67 65 20 | 69 6e 74 65 72 66 61 63 |anguage |interfac|
|00001f70| 65 2e 20 41 44 41 42 41 | 53 20 64 61 74 61 20 69 |e. ADABA|S data i|
|00001f80| 73 20 6f 72 67 61 6e 69 | 7a 65 64 20 69 6e 20 74 |s organi|zed in t|
|00001f90| 68 65 20 66 6f 72 6d 20 | 6f 66 20 74 61 62 6c 65 |he form |of table|
|00001fa0| 73 2e 20 41 20 73 65 74 | 20 6f 66 20 73 69 6d 70 |s. A set| of simp|
|00001fb0| 6c 65 20 73 74 61 74 65 | 6d 65 6e 74 73 20 62 61 |le state|ments ba|
|00001fc0| 73 65 64 20 6f 6e 20 74 | 68 65 20 45 6e 67 6c 69 |sed on t|he Engli|
|00001fd0| 73 68 20 6c 61 6e 67 75 | 61 67 65 20 73 65 72 76 |sh langu|age serv|
|00001fe0| 65 73 20 74 6f 20 66 6f | 72 6d 75 6c 61 74 65 20 |es to fo|rmulate |
|00001ff0| 61 20 6c 61 72 67 65 20 | 76 61 72 69 65 74 79 20 |a large |variety |
|00002000| 6f 66 20 64 61 74 61 62 | 61 73 65 20 6f 70 65 72 |of datab|ase oper|
|00002010| 61 74 69 6f 6e 73 2e 20 | 00 20 00 54 68 69 73 20 |ations. |. .This |
|00002020| 6d 65 61 6e 73 20 73 70 | 65 63 69 66 69 63 61 6c |means sp|ecifical|
|00002030| 6c 79 3a 20 00 20 00 54 | 68 65 20 53 45 4c 45 43 |ly: . .T|he SELEC|
|00002040| 54 20 73 74 61 74 65 6d | 65 6e 74 20 65 6e 61 62 |T statem|ent enab|
|00002050| 6c 65 73 20 74 68 65 20 | 75 73 65 72 20 74 6f 20 |les the |user to |
|00002060| 72 65 74 72 69 65 76 65 | 20 64 61 74 61 20 66 72 |retrieve| data fr|
|00002070| 6f 6d 20 61 20 74 61 62 | 6c 65 20 72 6f 77 20 62 |om a tab|le row b|
|00002080| 79 20 72 6f 77 20 6f 72 | 20 63 6f 6c 75 6d 6e 20 |y row or| column |
|00002090| 62 79 20 63 6f 6c 75 6d | 6e 2e 20 52 6f 77 73 20 |by colum|n. Rows |
|000020a0| 66 72 6f 6d 20 73 65 76 | 65 72 61 6c 20 74 61 62 |from sev|eral tab|
|000020b0| 6c 65 73 20 63 61 6e 20 | 62 65 20 63 6f 6d 62 69 |les can |be combi|
|000020c0| 6e 65 64 20 77 69 74 68 | 20 65 61 63 68 20 6f 74 |ned with| each ot|
|000020d0| 68 65 72 2e 20 44 61 74 | 61 20 63 61 6e 20 62 65 |her. Dat|a can be|
|000020e0| 20 73 6f 72 74 65 64 2c | 20 67 72 6f 75 70 65 64 | sorted,| grouped|
|000020f0| 2c 20 61 6e 64 20 75 73 | 65 64 20 66 6f 72 20 63 |, and us|ed for c|
|00002100| 61 6c 63 75 6c 61 74 69 | 6f 6e 73 2e 20 00 00 17 |alculati|ons. ...|
|00002110| 02 00 00 eb 01 00 00 d5 | 46 00 00 26 4b 00 00 2c |........|F..&K..,|
|00002120| 00 00 00 20 26 80 d7 03 | 00 80 00 00 10 00 e3 80 |... &...|........|
|00002130| 80 0c 00 82 82 82 82 82 | 82 82 ff 00 20 00 52 6f |........|.... .Ro|
|00002140| 77 73 20 61 72 65 20 69 | 6e 73 65 72 74 65 64 20 |ws are i|nserted |
|00002150| 75 73 69 6e 67 20 74 68 | 65 20 49 4e 53 45 52 54 |using th|e INSERT|
|00002160| 20 73 74 61 74 65 6d 65 | 6e 74 20 61 6e 64 20 64 | stateme|nt and d|
|00002170| 65 6c 65 74 65 64 20 75 | 73 69 6e 67 20 74 68 65 |eleted u|sing the|
|00002180| 20 44 45 4c 45 54 45 20 | 73 74 61 74 65 6d 65 6e | DELETE |statemen|
|00002190| 74 2e 20 54 68 65 20 55 | 50 44 41 54 45 20 73 74 |t. The U|PDATE st|
|000021a0| 61 74 65 6d 65 6e 74 20 | 63 61 6e 20 62 65 20 75 |atement |can be u|
|000021b0| 73 65 64 20 74 6f 20 6d | 6f 64 69 66 79 20 74 68 |sed to m|odify th|
|000021c0| 65 20 64 61 74 61 2e 20 | 00 20 00 41 6e 6f 74 68 |e data. |. .Anoth|
|000021d0| 65 72 20 67 72 6f 75 70 | 20 6f 66 20 73 74 61 74 |er group| of stat|
|000021e0| 65 6d 65 6e 74 73 20 73 | 65 72 76 65 73 20 74 6f |ements s|erves to|
|000021f0| 20 64 65 66 69 6e 65 20 | 61 6e 64 20 72 65 64 65 | define |and rede|
|00002200| 66 69 6e 65 20 74 68 65 | 20 73 74 72 75 63 74 75 |fine the| structu|
|00002210| 72 65 20 6f 66 20 61 20 | 74 61 62 6c 65 2e 00 20 |re of a |table.. |
|00002220| 00 20 00 57 65 20 72 65 | 63 6f 6d 6d 65 6e 64 20 |. .We re|commend |
|00002230| 74 68 65 20 75 73 65 72 | 20 74 6f 20 77 6f 72 6b |the user| to work|
|00002240| 20 64 69 72 65 63 74 6c | 79 20 77 69 74 68 20 74 | directl|y with t|
|00002250| 68 65 20 64 61 74 61 62 | 61 73 65 20 62 79 20 74 |he datab|ase by t|
|00002260| 72 79 69 6e 67 20 6f 75 | 74 20 74 68 65 20 65 78 |rying ou|t the ex|
|00002270| 61 6d 70 6c 65 73 20 70 | 72 6f 76 69 64 65 64 20 |amples p|rovided |
|00002280| 69 6e 20 74 68 69 73 20 | 6f 6e 6c 69 6e 65 20 68 |in this |online h|
|00002290| 65 6c 70 2e 20 46 6f 72 | 20 63 65 72 74 61 69 6e |elp. For| certain|
|000022a0| 20 70 72 6f 62 6c 65 6d | 73 2c 20 79 6f 75 20 6d | problem|s, you m|
|000022b0| 61 79 20 74 68 75 73 20 | 61 70 70 72 6f 61 63 68 |ay thus |approach|
|000022c0| 20 74 68 65 20 72 65 73 | 75 6c 74 20 73 74 65 70 | the res|ult step|
|000022d0| 20 62 79 20 73 74 65 70 | 2e 20 59 6f 75 20 6d 61 | by step|. You ma|
|000022e0| 79 20 62 75 69 6c 64 20 | 79 6f 75 72 20 6f 77 6e |y build |your own|
|000022f0| 20 73 61 6d 70 6c 65 73 | 20 66 6f 72 20 74 68 69 | samples| for thi|
|00002300| 73 20 70 75 72 70 6f 73 | 65 20 6f 72 20 75 73 65 |s purpos|e or use|
|00002310| 20 65 78 69 73 74 69 6e | 67 20 65 78 61 6d 70 6c | existin|g exampl|
|00002320| 65 73 2e 20 00 00 4e 02 | 00 00 25 02 00 00 0f 49 |es. ..N.|..%....I|
|00002330| 00 00 74 4d 00 00 29 00 | 00 00 20 20 80 4b 04 00 |..tM..).|..  .K..|
|00002340| 80 00 00 10 00 e3 80 80 | 0c 00 82 82 82 82 ff 00 |........|........|
|00002350| 20 00 57 69 74 68 20 65 | 61 63 68 20 41 44 41 42 | .With e|ach ADAB|
|00002360| 41 53 20 76 65 72 73 69 | 6f 6e 2c 20 64 65 6d 6f |AS versi|on, demo|
|00002370| 20 73 61 6d 70 6c 65 73 | 20 61 72 65 20 64 69 73 | samples| are dis|
|00002380| 74 72 69 62 75 74 65 64 | 20 77 68 69 63 68 20 63 |tributed| which c|
|00002390| 61 6e 20 62 65 20 6c 6f | 61 64 65 64 20 61 75 74 |an be lo|aded aut|
|000023a0| 6f 6d 61 74 69 63 61 6c | 6c 79 2e 20 49 6e 73 74 |omatical|ly. Inst|
|000023b0| 72 75 63 74 69 6f 6e 73 | 20 66 6f 72 20 74 68 65 |ructions| for the|
|000023c0| 69 72 20 69 6e 73 74 61 | 6c 6c 61 74 69 6f 6e 20 |ir insta|llation |
|000023d0| 61 72 65 20 63 6f 6e 74 | 61 69 6e 65 64 20 69 6e |are cont|ained in|
|000023e0| 20 74 68 65 20 63 6f 72 | 72 65 73 70 6f 6e 64 69 | the cor|respondi|
|000023f0| 6e 67 20 52 45 41 44 4d | 45 20 66 69 6c 65 2e 20 |ng READM|E file. |
|00002400| 54 68 65 20 73 61 6d 70 | 6c 65 20 74 61 62 6c 65 |The samp|le table|
|00002410| 73 20 6d 61 69 6e 6c 79 | 20 63 6f 72 72 65 73 70 |s mainly| corresp|
|00002420| 6f 6e 64 20 74 6f 20 74 | 68 65 20 74 61 62 6c 65 |ond to t|he table|
|00002430| 73 20 64 65 73 63 72 69 | 62 65 64 20 68 65 72 65 |s descri|bed here|
|00002440| 20 61 6e 64 20 63 61 6e | 20 74 68 65 72 65 66 6f | and can| therefo|
|00002450| 72 65 20 68 65 6c 70 20 | 79 6f 75 20 74 6f 20 6c |re help |you to l|
|00002460| 65 61 72 6e 20 6f 6e 20 | 74 68 65 20 73 79 73 74 |earn on |the syst|
|00002470| 65 6d 2e 20 00 20 00 54 | 68 69 73 20 74 75 74 6f |em. . .T|his tuto|
|00002480| 72 69 61 6c 20 6d 61 6b | 65 73 20 74 68 65 20 75 |rial mak|es the u|
|00002490| 73 65 72 20 61 63 71 75 | 61 69 6e 74 65 64 20 77 |ser acqu|ainted w|
|000024a0| 69 74 68 20 74 68 65 20 | 53 51 4c 20 6c 61 6e 67 |ith the |SQL lang|
|000024b0| 75 61 67 65 20 6f 6e 20 | 74 68 65 20 62 61 73 69 |uage on |the basi|
|000024c0| 73 20 6f 66 20 74 68 65 | 20 64 61 74 61 62 61 73 |s of the| databas|
|000024d0| 65 20 73 79 73 74 65 6d | 20 41 44 41 42 41 53 2e |e system| ADABAS.|
|000024e0| 20 54 68 65 20 6f 6e 6c | 69 6e 65 20 68 65 6c 70 | The onl|ine help|
|000024f0| 20 69 73 20 62 6f 74 68 | 20 61 20 67 65 6e 65 72 | is both| a gener|
|00002500| 61 6c 20 61 6e 64 20 61 | 20 73 70 65 63 69 61 6c |al and a| special|
|00002510| 20 6d 65 61 6e 73 20 6f | 66 20 69 6e 73 74 72 75 | means o|f instru|
|00002520| 63 74 69 6f 6e 20 74 68 | 61 74 20 61 6c 73 6f 20 |ction th|at also |
|00002530| 65 78 70 6c 61 69 6e 73 | 20 73 6f 6d 65 20 6f 66 |explains| some of|
|00002540| 20 74 68 65 20 41 44 41 | 42 41 53 20 66 65 61 74 | the ADA|BAS feat|
|00002550| 75 72 65 73 20 74 68 61 | 74 20 65 78 63 65 65 64 |ures tha|t exceed|
|00002560| 20 74 68 65 20 53 51 4c | 20 73 74 61 6e 64 61 72 | the SQL| standar|
|00002570| 64 2e 00 00 90 00 00 00 | 68 00 00 00 26 4b 00 00 |d.......|h...&K..|
|00002580| 04 4e 00 00 28 00 00 00 | 20 20 80 d0 00 80 00 00 |.N..(...|  ......|
|00002590| 10 00 e3 80 80 0c 00 82 | 82 82 82 ff 00 20 00 20 |........|..... . |
|000025a0| 00 54 68 65 20 66 6f 6c | 6c 6f 77 69 6e 67 20 73 |.The fol|lowing s|
|000025b0| 74 61 6e 64 61 72 64 20 | 6c 69 74 65 72 61 74 75 |tandard |literatu|
|000025c0| 72 65 20 69 73 20 72 65 | 63 6f 6d 6d 65 6e 64 65 |re is re|commende|
|000025d0| 64 20 61 73 20 61 20 67 | 65 6e 65 72 61 6c 20 69 |d as a g|eneral i|
|000025e0| 6e 74 72 6f 64 75 63 74 | 69 6f 6e 20 74 6f 20 74 |ntroduct|ion to t|
|000025f0| 68 65 20 53 51 4c 20 6c | 61 6e 67 75 61 67 65 3a |he SQL l|anguage:|
|00002600| 00 20 00 00 81 00 00 00 | 53 00 00 00 74 4d 00 00 |. ......|S...tM..|
|00002610| 85 4e 00 00 2e 00 00 00 | 20 2c 80 a6 00 80 00 00 |.N......| ,......|
|00002620| 50 02 39 81 2c 82 39 01 | 80 0c 00 83 82 83 82 83 |P.9.,.9.|........|
|00002630| 82 ff 00 28 31 29 00 4c | 41 4e 20 54 69 6d 65 73 |...(1).L|AN Times|
|00002640| 20 47 75 69 64 65 20 74 | 6f 20 53 51 4c 20 00 00 | Guide t|o SQL ..|
|00002650| 4a 61 6d 65 73 20 52 2e | 20 47 72 6f 66 66 2c 20 |James R.| Groff, |
|00002660| 50 61 75 6c 20 4e 2e 20 | 57 65 69 6e 62 65 72 67 |Paul N. |Weinberg|
|00002670| 00 00 4d 63 47 72 61 77 | 2d 48 69 6c 6c 2c 20 31 |..McGraw|-Hill, 1|
|00002680| 39 39 34 00 00 2c 00 00 | 00 04 00 00 00 04 4e 00 |994..,..|......N.|
|00002690| 00 b1 4e 00 00 28 00 00 | 00 20 20 80 08 00 80 00 |..N..(..|.  .....|
|000026a0| 00 10 02 e3 80 82 39 01 | 80 0c 00 82 ff 00 20 00 |......9.|...... .|
|000026b0| 00 75 00 00 00 47 00 00 | 00 85 4e 00 00 26 4f 00 |.u...G..|..N..&O.|
|000026c0| 00 2e 00 00 00 20 2c 80 | 8e 00 80 00 00 50 02 39 |..... ,.|.....P.9|
|000026d0| 81 2c 82 39 01 80 0c 00 | 83 82 83 82 83 82 ff 00 |.,.9....|........|
|000026e0| 28 32 29 00 49 6e 74 72 | 6f 64 75 63 74 69 6f 6e |(2).Intr|oduction|
|000026f0| 20 74 6f 20 44 61 74 61 | 62 61 73 65 20 53 79 73 | to Data|base Sys|
|00002700| 74 65 6d 00 00 43 2e 4a | 2e 20 44 61 74 65 00 00 |tem..C.J|. Date..|
|00002710| 41 64 64 69 73 6f 6e 20 | 57 65 73 6c 65 79 2c 20 |Addison |Wesley, |
|00002720| 31 39 39 30 00 00 2c 00 | 00 00 06 00 00 00 b1 4e |1990..,.|.......N|
|00002730| 00 00 52 4f 00 00 26 00 | 00 00 20 1c 80 0c 00 80 |..RO..&.|.. .....|
|00002740| 00 00 10 00 e3 80 80 0c | 00 82 82 ff 00 20 00 20 |........|..... . |
|00002750| 00 00 4c 00 00 00 1b 00 | 00 00 26 4f 00 00 9e 4f |..L.....|..&O...O|
|00002760| 00 00 31 00 00 00 02 cc | 02 00 00 ff ff ff ff 00 |..1.....|........|
|00002770| 00 01 00 03 00 00 00 9e | 4f 00 00 d0 4f 00 00 77 |........|O...O..w|
|00002780| 82 00 00 46 75 6e 64 61 | 6d 65 6e 74 61 6c 73 20 |...Funda|mentals |
|00002790| 2d 20 46 75 6e 64 61 6d | 65 6e 74 61 6c 73 32 00 |- Fundam|entals2.|
|000027a0| 00 00 0f 00 00 00 52 4f | 00 00 d0 4f 00 00 23 00 |......RO|...O..#.|
|000027b0| 00 00 20 16 80 1e 00 80 | 00 00 00 00 80 03 00 82 |.. .....|........|
|000027c0| ff 00 46 75 6e 64 61 6d | 65 6e 74 61 6c 73 00 00 |..Fundam|entals..|
|000027d0| 9b 02 00 00 64 02 00 00 | 9e 4f 00 00 77 82 00 00 |....d...|.O..w...|
|000027e0| 37 00 00 00 20 3c 80 cb | 04 00 80 00 00 10 00 e3 |7... <..|........|
|000027f0| 80 80 0c 00 82 82 82 83 | 86 22 08 80 02 00 00 00 |........|."......|
|00002800| d0 4f 00 00 77 82 00 00 | 52 4f 00 00 00 82 82 82 |.O..w...|RO......|
|00002810| 82 82 ff 00 20 00 54 68 | 65 20 66 6f 6c 6c 6f 77 |.... .Th|e follow|
|00002820| 69 6e 67 20 65 78 61 6d | 70 6c 65 73 20 61 72 65 |ing exam|ples are|
|00002830| 20 62 61 73 65 64 20 6f | 6e 20 61 20 74 61 62 6c | based o|n a tabl|
|00002840| 65 20 63 61 6c 6c 65 64 | 20 27 63 75 73 74 6f 6d |e called| 'custom|
|00002850| 65 72 27 2e 20 49 74 20 | 63 6f 6e 74 61 69 6e 73 |er'. It |contains|
|00002860| 20 74 68 65 20 66 6f 6c | 6c 6f 77 69 6e 67 20 64 | the fol|lowing d|
|00002870| 61 74 61 3a 20 00 20 00 | 00 00 00 20 00 49 6e 20 |ata: . .|... .In |
|00002880| 74 68 69 73 20 73 69 6d | 70 6c 65 20 64 61 74 61 |this sim|ple data|
|00002890| 20 6d 6f 64 65 6c 2c 20 | 65 61 63 68 20 72 6f 77 | model, |each row|
|000028a0| 20 63 6f 6e 74 61 69 6e | 73 20 74 68 65 20 63 6f | contain|s the co|
|000028b0| 6d 70 6c 65 74 65 20 69 | 6e 66 6f 72 6d 61 74 69 |mplete i|nformati|
|000028c0| 6f 6e 20 73 74 6f 72 65 | 64 20 61 62 6f 75 74 20 |on store|d about |
|000028d0| 61 20 70 61 72 74 69 63 | 75 6c 61 72 20 63 75 73 |a partic|ular cus|
|000028e0| 74 6f 6d 65 72 3a 20 61 | 20 6e 75 6d 62 65 72 20 |tomer: a| number |
|000028f0| 66 6f 72 20 63 6c 65 61 | 72 20 69 64 65 6e 74 69 |for clea|r identi|
|00002900| 66 69 63 61 74 69 6f 6e | 2c 20 74 68 65 20 74 69 |fication|, the ti|
|00002910| 74 6c 65 20 74 6f 20 62 | 65 20 75 73 65 64 20 69 |tle to b|e used i|
|00002920| 6e 20 63 6f 72 72 65 73 | 70 6f 6e 64 65 6e 63 65 |n corres|pondence|
|00002930| 2c 20 74 68 65 20 6e 61 | 6d 65 2c 20 74 68 65 20 |, the na|me, the |
|00002940| 61 64 64 72 65 73 73 2c | 20 61 6e 64 20 74 68 65 |address,| and the|
|00002950| 20 63 75 72 72 65 6e 74 | 20 61 63 63 6f 75 6e 74 | current| account|
|00002960| 2e 20 4f 74 68 65 72 20 | 63 6f 6c 75 6d 6e 73 20 |. Other |columns |
|00002970| 6e 65 65 64 65 64 20 69 | 6e 20 72 65 61 6c 20 61 |needed i|n real a|
|00002980| 70 70 6c 69 63 61 74 69 | 6f 6e 73 20 68 61 76 65 |pplicati|ons have|
|00002990| 20 62 65 65 6e 20 6f 6d | 69 74 74 65 64 20 66 6f | been om|itted fo|
|000029a0| 72 20 74 68 65 20 73 61 | 6b 65 20 6f 66 20 63 6c |r the sa|ke of cl|
|000029b0| 61 72 69 74 79 2e 20 00 | 20 00 46 72 6f 6d 20 74 |arity. .| .From t|
|000029c0| 68 69 73 20 74 61 62 6c | 65 2c 20 77 68 69 63 68 |his tabl|e, which|
|000029d0| 20 63 61 6e 20 62 65 63 | 6f 6d 65 20 76 65 72 79 | can bec|ome very|
|000029e0| 20 6c 6f 6e 67 20 61 6e | 64 20 76 65 72 79 20 77 | long an|d very w|
|000029f0| 69 64 65 2c 20 73 75 62 | 74 61 62 6c 65 73 20 63 |ide, sub|tables c|
|00002a00| 61 6e 20 62 65 20 73 65 | 6c 65 63 74 65 64 20 66 |an be se|lected f|
|00002a10| 6f 72 20 70 72 6f 63 65 | 73 73 69 6e 67 20 70 75 |or proce|ssing pu|
|00002a20| 72 70 6f 73 65 73 20 6f | 72 20 66 6f 72 20 73 70 |rposes o|r for sp|
|00002a30| 65 63 69 61 6c 20 74 61 | 73 6b 73 2e 20 54 68 69 |ecial ta|sks. Thi|
|00002a40| 73 20 63 61 6e 20 62 65 | 20 64 6f 6e 65 20 76 65 |s can be| done ve|
|00002a50| 72 79 20 65 61 73 69 6c | 79 20 77 69 74 68 20 74 |ry easil|y with t|
|00002a60| 68 65 20 66 6f 6c 6c 6f | 77 69 6e 67 20 6d 65 74 |he follo|wing met|
|00002a70| 68 6f 64 3a 20 00 00 4e | 00 00 00 1d 00 00 00 d0 |hod: ..N|........|
|00002a80| 4f 00 00 c5 82 00 00 31 | 00 00 00 02 d7 03 00 00 |O......1|........|
|00002a90| ce 8a 00 00 49 03 01 00 | 04 00 00 00 c5 82 00 00 |....I...|........|
|00002aa0| 08 83 00 00 ae 86 00 00 | 45 78 61 6d 70 6c 65 a0 |........|Example.|
|00002ab0| 6f 66 a0 61 a0 53 45 4c | 45 43 54 a0 53 74 61 74 |of.a.SEL|ECT.Stat|
|00002ac0| 65 6d 65 6e 74 43 00 00 | 00 20 00 00 00 77 82 00 |ementC..|. ...w..|
|00002ad0| 00 08 83 00 00 23 00 00 | 00 20 16 80 40 00 80 00 |.....#..|. ..@...|
|00002ae0| 00 00 00 80 03 00 82 ff | 00 45 78 61 6d 70 6c 65 |........|.Example|
|00002af0| a0 6f 66 a0 61 a0 53 45 | 4c 45 43 54 a0 53 74 61 |.of.a.SE|LECT.Sta|
|00002b00| 74 65 6d 65 6e 74 00 00 | 49 02 00 00 0e 02 00 00 |tement..|I.......|
|00002b10| c5 82 00 00 51 85 00 00 | 3b 00 00 00 20 44 80 1d |....Q...|;... D..|
|00002b20| 04 00 80 00 00 10 00 e3 | 80 80 0c 00 82 82 82 80 |........|........|
|00002b30| 0d 00 82 82 82 82 80 0c | 00 82 82 82 82 82 82 82 |........|........|
|00002b40| 82 82 ff 00 20 00 46 6f | 72 20 63 6c 61 72 69 74 |.... .Fo|r clarit|
|00002b50| 79 20 72 65 61 73 6f 6e | 73 2c 20 55 50 50 45 52 |y reason|s, UPPER|
|00002b60| 20 63 61 73 65 20 63 68 | 61 72 61 63 74 65 72 73 | case ch|aracters|
|00002b70| 20 61 72 65 20 75 73 65 | 64 20 69 6e 20 74 68 65 | are use|d in the|
|00002b80| 20 66 6f 6c 6c 6f 77 69 | 6e 67 20 66 6f 72 20 41 | followi|ng for A|
|00002b90| 44 41 42 41 53 20 73 74 | 61 74 65 6d 65 6e 74 73 |DABAS st|atements|
|00002ba0| 2c 20 6c 6f 77 65 72 20 | 63 61 73 65 20 63 68 61 |, lower |case cha|
|00002bb0| 72 61 63 74 65 72 73 20 | 66 6f 72 20 74 61 62 6c |racters |for tabl|
|00002bc0| 65 20 61 6e 64 20 63 6f | 6c 75 6d 6e 20 6e 61 6d |e and co|lumn nam|
|00002bd0| 65 73 2e 20 00 20 00 00 | 53 45 4c 45 43 54 20 74 |es. . ..|SELECT t|
|00002be0| 69 74 6c 65 2c 20 6e 61 | 6d 65 2c 20 63 69 74 79 |itle, na|me, city|
|00002bf0| 2c 20 73 74 61 74 65 2c | 20 7a 69 70 00 20 20 20 |, state,| zip.   |
|00002c00| 20 20 20 20 46 52 4f 4d | 20 63 75 73 74 6f 6d 65 |    FROM| custome|
|00002c10| 72 00 20 20 20 20 20 20 | 20 20 20 20 20 20 57 48 |r.      |      WH|
|00002c20| 45 52 45 20 73 74 61 74 | 65 20 3d 20 27 43 41 27 |ERE stat|e = 'CA'|
|00002c30| 00 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |.       |        |
|00002c40| 20 20 20 4f 52 44 45 52 | 20 42 59 20 6e 61 6d 65 |   ORDER| BY name|
|00002c50| 00 00 20 00 20 00 54 68 | 69 73 20 6d 65 61 6e 73 |.. . .Th|is means|
|00002c60| 3a 20 00 20 00 2a 20 46 | 69 6e 64 20 28 53 45 4c |: . .* F|ind (SEL|
|00002c70| 45 43 54 29 20 00 2a 20 | 74 68 65 20 63 6f 6c 75 |ECT) .* |the colu|
|00002c80| 6d 6e 73 20 74 69 74 6c | 65 2c 20 6e 61 6d 65 2c |mns titl|e, name,|
|00002c90| 20 63 69 74 79 2c 20 73 | 74 61 74 65 2c 20 7a 69 | city, s|tate, zi|
|00002ca0| 70 20 00 2a 20 69 6e 20 | 74 68 65 20 74 61 62 6c |p .* in |the tabl|
|00002cb0| 65 20 27 63 75 73 74 6f | 6d 65 72 27 20 28 46 52 |e 'custo|mer' (FR|
|00002cc0| 4f 4d 29 20 00 2a 20 66 | 6f 72 20 74 68 65 20 72 |OM) .* f|or the r|
|00002cd0| 6f 77 73 20 77 69 74 68 | 20 74 68 65 20 76 61 6c |ows with| the val|
|00002ce0| 75 65 20 27 43 41 27 20 | 69 6e 20 74 68 65 20 63 |ue 'CA' |in the c|
|00002cf0| 6f 6c 75 6d 6e 20 27 73 | 74 61 74 65 27 20 28 57 |olumn 's|tate' (W|
|00002d00| 48 45 52 45 29 20 00 2a | 20 61 6e 64 20 6f 72 64 |HERE) .*| and ord|
|00002d10| 65 72 20 74 68 65 20 72 | 65 73 75 6c 74 20 72 6f |er the r|esult ro|
|00002d20| 77 73 20 61 6c 70 68 61 | 62 65 74 69 63 61 6c 6c |ws alpha|beticall|
|00002d30| 79 20 61 63 63 6f 72 64 | 69 6e 67 20 74 6f 20 6e |y accord|ing to n|
|00002d40| 61 6d 65 20 28 4f 52 44 | 45 52 20 42 59 29 20 00 |ame (ORD|ER BY) .|
|00002d50| 00 5d 01 00 00 1a 01 00 | 00 08 83 00 00 ae 86 00 |.]......|........|
|00002d60| 00 43 00 00 00 20 54 80 | 37 02 00 80 00 00 10 00 |.C... T.|7.......|
|00002d70| e3 80 80 0c 00 82 82 82 | 82 80 0d 00 82 82 82 82 |........|........|
|00002d80| 80 0c 00 82 82 82 82 83 | 86 22 08 80 02 00 00 01 |........|."......|
|00002d90| 00 82 82 ff 00 20 00 20 | 00 54 68 65 20 67 65 6e |..... . |.The gen|
|00002da0| 65 72 61 6c 20 66 6f 72 | 6d 20 6f 66 20 61 20 53 |eral for|m of a S|
|00002db0| 45 4c 45 43 54 20 73 74 | 61 74 65 6d 65 6e 74 20 |ELECT st|atement |
|00002dc0| 6c 6f 6f 6b 73 20 6c 69 | 6b 65 20 74 68 69 73 3a |looks li|ke this:|
|00002dd0| 20 00 20 00 00 20 20 20 | 20 53 45 4c 45 43 54 2e | . ..   | SELECT.|
|00002de0| 2e 2e 2e 2e 20 20 20 20 | 20 77 68 69 63 68 20 63 |....    | which c|
|00002df0| 6f 6c 75 6d 6e 73 00 20 | 20 20 20 46 52 4f 4d 2e |olumns. |   FROM.|
|00002e00| 2e 2e 2e 2e 2e 2e 20 20 | 20 20 20 77 68 69 63 68 |......  |   which|
|00002e10| 20 74 61 62 6c 65 00 20 | 20 20 20 57 48 45 52 45 | table. |   WHERE|
|00002e20| 2e 2e 2e 2e 2e 2e 20 20 | 20 20 20 74 68 65 20 63 |......  |   the c|
|00002e30| 6f 6e 64 69 74 69 6f 6e | 20 69 73 00 20 20 20 20 |ondition| is.    |
|00002e40| 4f 52 44 45 52 20 42 59 | 2e 2e 2e 20 20 20 20 20 |ORDER BY|...     |
|00002e50| 69 6e 20 74 68 65 20 66 | 6f 6c 6c 6f 77 69 6e 67 |in the f|ollowing|
|00002e60| 20 77 61 79 00 00 20 00 | 20 00 54 68 65 20 72 65 | way.. .| .The re|
|00002e70| 73 75 6c 74 20 6f 66 20 | 74 68 65 20 53 45 4c 45 |sult of |the SELE|
|00002e80| 43 54 20 73 74 61 74 65 | 6d 65 6e 74 20 69 73 20 |CT state|ment is |
|00002e90| 74 68 65 20 66 6f 6c 6c | 6f 77 69 6e 67 20 74 61 |the foll|owing ta|
|00002ea0| 62 6c 65 3a 20 00 20 00 | 00 00 00 20 00 00 4d 00 |ble: . .|... ..M.|
|00002eb0| 00 00 1c 00 00 00 51 85 | 00 00 fb 86 00 00 31 00 |......Q.|......1.|
|00002ec0| 00 00 02 52 01 00 00 00 | 00 01 00 4d 04 01 00 05 |...R....|...M....|
|00002ed0| 00 00 00 fb 86 00 00 3d | 87 00 00 5e 88 00 00 53 |.......=|...^...S|
|00002ee0| 65 6c 65 63 74 69 6e 67 | a0 50 61 72 74 69 63 75 |electing|.Particu|
|00002ef0| 6c 61 72 a0 43 6f 6c 75 | 6d 6e 73 42 00 00 00 1f |lar.Colu|mnsB....|
|00002f00| 00 00 00 ae 86 00 00 3d | 87 00 00 23 00 00 00 20 |.......=|...#... |
|00002f10| 16 80 3e 00 80 00 00 00 | 00 80 03 00 82 ff 00 53 |..>.....|.......S|
|00002f20| 65 6c 65 63 74 69 6e 67 | a0 50 61 72 74 69 63 75 |electing|.Particu|
|00002f30| 6c 61 72 a0 43 6f 6c 75 | 6d 6e 73 00 00 21 01 00 |lar.Colu|mns..!..|
|00002f40| 00 e4 00 00 00 fb 86 00 | 00 5e 88 00 00 3d 00 00 |........|.^...=..|
|00002f50| 00 20 48 80 cb 01 00 80 | 00 00 10 00 e3 80 80 0c |. H.....|........|
|00002f60| 00 82 82 82 80 0d 00 82 | 82 82 83 86 22 08 80 02 |........|...."...|
|00002f70| 00 00 02 00 82 80 0c 00 | 82 ff 00 20 00 43 6f 6c |........|... .Col|
|00002f80| 75 6d 6e 73 20 61 72 65 | 20 73 65 6c 65 63 74 65 |umns are| selecte|
|00002f90| 64 20 66 72 6f 6d 20 61 | 20 62 61 73 65 20 74 61 |d from a| base ta|
|00002fa0| 62 6c 65 20 73 69 6d 70 | 6c 79 20 62 79 20 73 70 |ble simp|ly by sp|
|00002fb0| 65 63 69 66 79 69 6e 67 | 20 74 68 65 69 72 20 6e |ecifying| their n|
|00002fc0| 61 6d 65 73 20 61 66 74 | 65 72 20 74 68 65 20 6b |ames aft|er the k|
|00002fd0| 65 79 77 6f 72 64 20 53 | 45 4c 45 43 54 20 61 6e |eyword S|ELECT an|
|00002fe0| 64 20 73 65 70 61 72 61 | 74 69 6e 67 20 74 68 65 |d separa|ting the|
|00002ff0| 6d 20 62 79 20 63 6f 6d | 6d 61 73 2e 20 42 6c 61 |m by com|mas. Bla|
|00003000| 6e 6b 73 20 6d 61 79 20 | 62 65 20 75 73 65 64 2c |nks may |be used,|
|00003010| 20 62 75 74 20 61 72 65 | 20 6e 6f 74 20 6e 65 65 | but are| not nee|
|00003020| 64 65 64 2e 20 00 20 00 | 00 53 45 4c 45 43 54 20 |ded. . .|.SELECT |
|00003030| 6e 61 6d 65 2c 20 66 69 | 72 73 74 6e 61 6d 65 00 |name, fi|rstname.|
|00003040| 20 20 20 20 20 20 20 46 | 52 4f 4d 20 63 75 73 74 |       F|ROM cust|
|00003050| 6f 6d 65 72 00 20 00 00 | 00 00 00 20 00 00 41 00 |omer. ..|... ..A.|
|00003060| 00 00 10 00 00 00 3d 87 | 00 00 9f 88 00 00 31 00 |......=.|......1.|
|00003070| 00 00 02 52 02 00 00 49 | 03 01 00 38 06 01 00 06 |...R...I|...8....|
|00003080| 00 00 00 9f 88 00 00 d5 | 88 00 00 f6 8a 00 00 4f |........|.......O|
|00003090| 72 64 65 72 69 6e 67 a0 | 43 6f 6c 75 6d 6e 73 36 |rdering.|Columns6|
|000030a0| 00 00 00 13 00 00 00 5e | 88 00 00 d5 88 00 00 23 |.......^|.......#|
|000030b0| 00 00 00 20 16 80 26 00 | 80 00 00 00 00 80 03 00 |... ..&.|........|
|000030c0| 82 ff 00 4f 72 64 65 72 | 69 6e 67 a0 43 6f 6c 75 |...Order|ing.Colu|
|000030d0| 6d 6e 73 00 00 21 02 00 | 00 d7 01 00 00 9f 88 00 |mns..!..|........|
|000030e0| 00 f6 8a 00 00 4a 00 00 | 00 20 62 80 b1 03 00 80 |.....J..|. b.....|
|000030f0| 00 00 10 00 e3 80 80 0c | 00 82 82 82 80 0d 00 82 |........|........|
|00003100| 82 82 83 86 22 08 80 02 | 00 00 03 00 82 80 0c 00 |...."...|........|
|00003110| 82 82 82 82 80 0d 00 82 | 82 80 0c 00 82 82 ff 00 |........|........|
|00003120| 20 00 54 68 65 20 73 65 | 6c 65 63 74 65 64 20 63 | .The se|lected c|
|00003130| 6f 6c 75 6d 6e 73 20 61 | 72 65 20 61 72 72 61 6e |olumns a|re arran|
|00003140| 67 65 64 20 69 6e 20 74 | 68 65 20 6f 72 64 65 72 |ged in t|he order|
|00003150| 20 6f 66 20 74 68 65 20 | 63 6f 6c 75 6d 6e 20 6e | of the |column n|
|00003160| 61 6d 65 73 2c 20 61 73 | 20 74 68 65 79 20 61 72 |ames, as| they ar|
|00003170| 65 20 73 70 65 63 69 66 | 69 65 64 20 69 6e 20 74 |e specif|ied in t|
|00003180| 68 65 20 53 45 4c 45 43 | 54 20 73 74 61 74 65 6d |he SELEC|T statem|
|00003190| 65 6e 74 20 61 6e 64 20 | 6e 6f 74 20 61 73 20 74 |ent and |not as t|
|000031a0| 68 65 79 20 61 72 65 20 | 73 74 6f 72 65 64 20 69 |hey are |stored i|
|000031b0| 6e 20 74 68 65 20 62 61 | 73 65 20 74 61 62 6c 65 |n the ba|se table|
|000031c0| 2e 20 00 20 00 00 53 45 | 4c 45 43 54 20 66 69 72 |. . ..SE|LECT fir|
|000031d0| 73 74 6e 61 6d 65 2c 20 | 6e 61 6d 65 00 20 20 20 |stname, |name.   |
|000031e0| 20 20 20 20 46 52 4f 4d | 20 63 75 73 74 6f 6d 65 |    FROM| custome|
|000031f0| 72 00 20 00 00 00 00 00 | 20 00 20 00 41 6e 20 27 |r. .....| . .An '|
|00003200| 2a 27 20 63 61 6e 20 62 | 65 20 75 73 65 64 20 69 |*' can b|e used i|
|00003210| 6e 73 74 65 61 64 20 6f | 66 20 74 68 65 20 6c 69 |nstead o|f the li|
|00003220| 73 74 20 6f 66 20 63 6f | 6c 75 6d 6e 20 6e 61 6d |st of co|lumn nam|
|00003230| 65 73 2e 20 54 68 65 20 | 75 73 65 72 20 72 65 63 |es. The |user rec|
|00003240| 65 69 76 65 73 20 61 6c | 6c 20 74 68 65 20 74 61 |eives al|l the ta|
|00003250| 62 6c 65 20 63 6f 6c 75 | 6d 6e 73 20 69 6e 20 74 |ble colu|mns in t|
|00003260| 68 65 20 6f 72 64 65 72 | 20 64 65 66 69 6e 65 64 |he order| defined|
|00003270| 20 69 6e 20 74 68 65 20 | 64 61 74 61 62 61 73 65 | in the |database|
|00003280| 2e 20 00 20 00 00 53 45 | 4c 45 43 54 20 20 2a 00 |. . ..SE|LECT  *.|
|00003290| 20 20 20 20 20 20 20 20 | 46 52 4f 4d 20 63 75 73 |        |FROM cus|
|000032a0| 74 6f 6d 65 72 00 00 20 | 00 70 72 6f 64 75 63 65 |tomer.. |.produce|
|000032b0| 73 20 74 68 65 20 74 61 | 62 6c 65 20 27 63 75 73 |s the ta|ble 'cus|
|000032c0| 74 6f 6d 65 72 27 20 77 | 69 74 68 20 61 6c 6c 20 |tomer' w|ith all |
|000032d0| 69 74 73 20 63 6f 6c 75 | 6d 6e 73 20 61 6e 64 20 |its colu|mns and |
|000032e0| 72 6f 77 73 20 61 73 20 | 74 68 65 20 72 65 73 75 |rows as |the resu|
|000032f0| 6c 74 2e 20 00 00 4a 00 | 00 00 19 00 00 00 d5 88 |lt. ..J.|........|
|00003300| 00 00 40 8b 00 00 31 00 | 00 00 02 2d 05 00 00 4d |..@...1.|...-...M|
|00003310| 04 01 00 00 80 01 00 07 | 00 00 00 40 8b 00 00 7f |........|...@....|
|00003320| 8b 00 00 87 c0 00 00 53 | 65 6c 65 63 74 69 6e 67 |.......S|electing|
|00003330| a0 50 61 72 74 69 63 75 | 6c 61 72 a0 52 6f 77 73 |.Particu|lar.Rows|
|00003340| 3f 00 00 00 1c 00 00 00 | f6 8a 00 00 7f 8b 00 00 |?.......|........|
|00003350| 23 00 00 00 20 16 80 38 | 00 80 00 00 00 00 80 03 |#... ..8|........|
|00003360| 00 82 ff 00 53 65 6c 65 | 63 74 69 6e 67 a0 50 61 |....Sele|cting.Pa|
|00003370| 72 74 69 63 75 6c 61 72 | a0 52 6f 77 73 00 00 0d |rticular|.Rows...|
|00003380| 02 00 00 c2 01 00 00 40 | 8b 00 00 8c 8d 00 00 4b |.......@|.......K|
|00003390| 00 00 00 20 64 80 87 03 | 00 80 00 00 10 00 e3 80 |... d...|........|
|000033a0| 80 0c 00 82 82 82 82 82 | 82 80 0d 00 82 82 82 82 |........|........|
|000033b0| 83 86 22 08 80 02 00 00 | 04 00 82 80 0c 00 82 82 |..".....|........|
|000033c0| 82 82 82 80 0d 00 82 82 | 82 ff 00 20 00 49 6e 20 |........|... .In |
|000033d0| 61 64 64 69 74 69 6f 6e | 20 74 6f 20 72 65 73 74 |addition| to rest|
|000033e0| 72 69 63 74 69 6e 67 20 | 74 68 65 20 6e 75 6d 62 |ricting |the numb|
|000033f0| 65 72 20 6f 66 20 63 6f | 6c 75 6d 6e 73 20 69 6e |er of co|lumns in|
|00003400| 20 61 20 62 61 73 65 20 | 74 61 62 6c 65 2c 20 69 | a base |table, i|
|00003410| 74 20 69 73 20 61 6c 73 | 6f 20 70 6f 73 73 69 62 |t is als|o possib|
|00003420| 6c 65 20 74 6f 20 72 65 | 73 74 72 69 63 74 20 74 |le to re|strict t|
|00003430| 68 65 20 6e 75 6d 62 65 | 72 20 6f 66 20 72 6f 77 |he numbe|r of row|
|00003440| 73 2e 20 52 6f 77 73 20 | 61 72 65 20 73 65 6c 65 |s. Rows |are sele|
|00003450| 63 74 65 64 20 62 79 20 | 66 6f 72 6d 75 6c 61 74 |cted by |formulat|
|00003460| 69 6e 67 20 61 20 57 48 | 45 52 45 20 63 6f 6e 64 |ing a WH|ERE cond|
|00003470| 69 74 69 6f 6e 2e 20 00 | 20 00 20 00 53 65 6c 65 |ition. .| . .Sele|
|00003480| 63 74 69 6f 6e 20 6f 66 | 20 72 6f 77 73 20 77 69 |ction of| rows wi|
|00003490| 74 68 20 74 68 65 20 63 | 69 74 79 20 27 4e 65 77 |th the c|ity 'New|
|000034a0| 20 59 6f 72 6b 27 3a 20 | 00 20 00 00 53 45 4c 45 | York': |. ..SELE|
|000034b0| 43 54 20 74 69 74 6c 65 | 2c 20 66 69 72 73 74 6e |CT title|, firstn|
|000034c0| 61 6d 65 2c 20 6e 61 6d | 65 2c 20 63 69 74 79 00 |ame, nam|e, city.|
|000034d0| 20 20 20 20 20 20 20 46 | 52 4f 4d 20 63 75 73 74 |       F|ROM cust|
|000034e0| 6f 6d 65 72 00 20 20 20 | 20 20 20 20 57 48 45 52 |omer.   |    WHER|
|000034f0| 45 20 63 69 74 79 20 3d | 20 27 4e 65 77 20 59 6f |E city =| 'New Yo|
|00003500| 72 6b 27 00 20 00 00 00 | 00 00 20 00 20 00 20 00 |rk'. ...|.. . . .|
|00003510| 53 65 6c 65 63 74 69 6f | 6e 20 6f 66 20 72 6f 77 |Selectio|n of row|
|00003520| 73 20 77 69 74 68 20 61 | 6e 20 61 63 63 6f 75 6e |s with a|n accoun|
|00003530| 74 20 6f 66 20 30 2e 30 | 30 3a 20 00 20 00 00 53 |t of 0.0|0: . ..S|
|00003540| 45 4c 45 43 54 20 6e 61 | 6d 65 2c 20 63 69 74 79 |ELECT na|me, city|
|00003550| 2c 20 61 63 63 6f 75 6e | 74 00 20 20 20 20 20 20 |, accoun|t.      |
|00003560| 20 46 52 4f 4d 20 63 75 | 73 74 6f 6d 65 72 00 20 | FROM cu|stomer. |
|00003570| 20 20 20 20 20 20 57 48 | 45 52 45 20 61 63 63 6f |      WH|ERE acco|
|00003580| 75 6e 74 20 3d 20 30 2e | 30 30 00 00 37 02 00 00 |unt = 0.|00..7...|
|00003590| d2 01 00 00 7f 8b 00 00 | c3 8f 00 00 65 00 00 00 |........|....e...|
|000035a0| 20 98 80 a9 03 00 80 00 | 00 10 00 e3 80 80 0d 00 | .......|........|
|000035b0| 82 83 86 22 08 80 02 00 | 00 05 00 82 80 0c 00 82 |..."....|........|
|000035c0| 82 82 82 80 0e 00 80 0c | 00 82 82 80 0d 00 82 82 |........|........|
|000035d0| 82 82 83 86 22 08 80 02 | 00 00 06 00 82 80 0c 00 |...."...|........|
|000035e0| 82 82 80 0d 00 82 82 82 | 82 82 80 0c 00 82 82 82 |........|........|
|000035f0| ff 00 20 00 00 00 00 00 | 20 00 20 00 4e 6f 77 20 |.. .....| . .Now |
|00003600| 74 68 6f 73 65 20 72 6f | 77 73 20 61 72 65 20 74 |those ro|ws are t|
|00003610| 6f 20 62 65 20 73 65 6c | 65 63 74 65 64 20 77 68 |o be sel|ected wh|
|00003620| 69 63 68 20 68 61 76 65 | 20 6e 6f 20 76 61 6c 75 |ich have| no valu|
|00003630| 65 20 69 6e 20 61 20 73 | 70 65 63 69 66 69 65 64 |e in a s|pecified|
|00003640| 20 63 6f 6c 75 6d 6e 2e | 20 00 20 00 22 4e 6f 20 | column.| . ."No |
|00003650| 76 61 6c 75 65 22 20 69 | 73 20 00 6e 6f 74 20 00 |value" i|s .not .|
|00003660| 69 6e 64 69 63 61 74 65 | 64 20 62 79 20 74 68 65 |indicate|d by the|
|00003670| 20 76 61 6c 75 65 20 22 | 30 22 20 6f 72 20 22 20 | value "|0" or " |
|00003680| 22 2c 20 62 75 74 20 62 | 79 20 4e 55 4c 4c 2e 20 |", but b|y NULL. |
|00003690| 00 20 00 00 53 45 4c 45 | 43 54 20 74 69 74 6c 65 |. ..SELE|CT title|
|000036a0| 2c 20 66 69 72 73 74 6e | 61 6d 65 2c 20 6e 61 6d |, firstn|ame, nam|
|000036b0| 65 00 20 20 20 20 20 20 | 20 46 52 4f 4d 20 63 75 |e.      | FROM cu|
|000036c0| 73 74 6f 6d 65 72 00 20 | 20 20 20 20 20 20 57 48 |stomer. |      WH|
|000036d0| 45 52 45 20 66 69 72 73 | 74 6e 61 6d 65 20 49 53 |ERE firs|tname IS|
|000036e0| 20 4e 55 4c 4c 00 20 00 | 00 00 00 00 20 00 20 00 | NULL. .|.... . .|
|000036f0| 00 53 45 4c 45 43 54 20 | 6e 61 6d 65 2c 20 63 69 |.SELECT |name, ci|
|00003700| 74 79 00 20 20 20 20 20 | 20 20 46 52 4f 4d 20 63 |ty.     |  FROM c|
|00003710| 75 73 74 6f 6d 65 72 00 | 20 20 20 20 20 20 20 57 |ustomer.|       W|
|00003720| 48 45 52 45 20 61 63 63 | 6f 75 6e 74 20 49 53 20 |HERE acc|ount IS |
|00003730| 4e 55 4c 4c 00 20 00 2a | 2a 2a 45 52 52 4f 52 20 |NULL. .*|**ERROR |
|00003740| 31 30 30 20 52 4f 57 20 | 4e 4f 54 20 46 4f 55 4e |100 ROW |NOT FOUN|
|00003750| 44 00 20 00 20 00 20 00 | 49 66 20 6f 6e 6c 79 20 |D. . . .|If only |
|00003760| 74 68 65 20 66 69 72 73 | 74 20 66 69 76 65 20 63 |the firs|t five c|
|00003770| 6f 6c 75 6d 6e 73 20 61 | 72 65 20 74 6f 20 62 65 |olumns a|re to be|
|00003780| 20 6f 75 74 70 75 74 2c | 20 61 6e 64 20 70 72 6f | output,| and pro|
|00003790| 76 69 64 65 64 20 77 69 | 74 68 20 6e 75 6d 62 65 |vided wi|th numbe|
|000037a0| 72 73 2c 20 74 68 65 20 | 73 74 61 74 65 6d 65 6e |rs, the |statemen|
|000037b0| 74 20 69 73 20 61 73 20 | 66 6f 6c 6c 6f 77 73 3a |t is as |follows:|
|000037c0| 20 00 00 b8 00 00 00 7b | 00 00 00 8c 8d 00 00 87 | ......{|........|
|000037d0| c0 00 00 3d 00 00 00 20 | 4a 80 f8 00 80 00 00 10 |...=... |J.......|
|000037e0| 00 e3 80 80 0c 00 82 80 | 0d 00 82 82 82 80 0c 00 |........|........|
|000037f0| 82 82 82 83 86 22 08 80 | 02 00 00 07 00 82 82 ff |....."..|........|
|00003800| c3 8f 00 00 87 c0 00 00 | f6 8a 00 00 00 20 00 00 |........|..... ..|
|00003810| 53 45 4c 45 43 54 20 52 | 4f 57 4e 4f 2c 20 63 6e |SELECT R|OWNO, cn|
|00003820| 6f 2c 20 74 69 74 6c 65 | 2c 20 66 69 72 73 74 6e |o, title|, firstn|
|00003830| 61 6d 65 2c 20 6e 61 6d | 65 00 20 20 20 20 20 20 |ame, nam|e.      |
|00003840| 20 46 52 4f 4d 20 63 75 | 73 74 6f 6d 65 72 00 20 | FROM cu|stomer. |
|00003850| 20 20 20 20 20 20 57 48 | 45 52 45 20 52 4f 57 4e |      WH|ERE ROWN|
|00003860| 4f 20 3c 3d 20 35 00 00 | 20 00 54 68 65 6e 20 74 |O <= 5..| .Then t|
|00003870| 68 65 20 72 65 73 75 6c | 74 20 69 73 3a 20 00 20 |he resul|t is: . |
|00003880| 00 00 00 00 20 00 00 3e | 00 00 00 0d 00 00 00 c3 |.... ..>|........|
|00003890| 8f 00 00 c5 c0 00 00 31 | 00 00 00 02 f4 0a 00 00 |.......1|........|
|000038a0| 38 06 01 00 a0 89 01 00 | 08 00 00 00 c5 c0 00 00 |8.......|........|
|000038b0| f8 c0 00 00 bb cb 00 00 | 4f 72 64 65 72 69 6e 67 |........|Ordering|
|000038c0| a0 52 6f 77 73 33 00 00 | 00 10 00 00 00 87 c0 00 |.Rows3..|........|
|000038d0| 00 f8 c0 00 00 23 00 00 | 00 20 16 80 20 00 80 00 |.....#..|. .. ...|
|000038e0| 00 00 00 80 03 00 82 ff | 00 4f 72 64 65 72 69 6e |........|.Orderin|
|000038f0| 67 a0 52 6f 77 73 00 00 | 27 02 00 00 e4 01 00 00 |g.Rows..|'.......|
|00003900| c5 c0 00 00 1f c3 00 00 | 43 00 00 00 20 54 80 cb |........|C... T..|
|00003910| 03 00 80 00 00 10 00 e3 | 80 80 0c 00 82 82 82 82 |........|........|
|00003920| 82 82 80 0d 00 82 82 82 | 82 83 86 22 08 80 02 00 |........|..."....|
|00003930| 00 08 00 82 80 0c 00 82 | 82 82 ff 00 20 00 4f 52 |........|.... .OR|
|00003940| 44 45 52 20 42 59 20 73 | 70 65 63 69 66 69 65 73 |DER BY s|pecifies|
|00003950| 20 74 68 65 20 6f 72 64 | 65 72 20 69 6e 20 77 68 | the ord|er in wh|
|00003960| 69 63 68 20 74 68 65 20 | 72 6f 77 73 20 61 72 65 |ich the |rows are|
|00003970| 20 74 6f 20 62 65 20 6f | 75 74 70 75 74 2e 20 00 | to be o|utput. .|
|00003980| 20 00 20 00 49 6e 20 74 | 68 65 20 66 69 72 73 74 | . .In t|he first|
|00003990| 20 65 78 61 6d 70 6c 65 | 2c 20 61 6c 6c 20 72 6f | example|, all ro|
|000039a0| 77 73 20 61 72 65 20 61 | 6c 70 68 61 62 65 74 69 |ws are a|lphabeti|
|000039b0| 63 61 6c 6c 79 20 6f 72 | 64 65 72 65 64 20 61 63 |cally or|dered ac|
|000039c0| 63 6f 72 64 69 6e 67 20 | 74 6f 20 27 6e 61 6d 65 |cording |to 'name|
|000039d0| 27 2e 20 00 20 00 00 53 | 45 4c 45 43 54 20 6e 61 |'. . ..S|ELECT na|
|000039e0| 6d 65 2c 20 66 69 72 73 | 74 6e 61 6d 65 2c 20 63 |me, firs|tname, c|
|000039f0| 69 74 79 2c 20 61 63 63 | 6f 75 6e 74 00 20 20 20 |ity, acc|ount.   |
|00003a00| 20 20 20 20 46 52 4f 4d | 20 63 75 73 74 6f 6d 65 |    FROM| custome|
|00003a10| 72 00 20 20 20 20 20 20 | 20 4f 52 44 45 52 20 42 |r.      | ORDER B|
|00003a20| 59 20 6e 61 6d 65 00 20 | 00 00 00 00 00 20 00 20 |Y name. |..... . |
|00003a30| 00 49 6e 20 74 68 65 20 | 6e 65 78 74 20 65 78 61 |.In the |next exa|
|00003a40| 6d 70 6c 65 2c 20 74 68 | 65 20 72 6f 77 73 20 61 |mple, th|e rows a|
|00003a50| 72 65 20 61 72 72 61 6e | 67 65 64 20 69 6e 20 6e |re arran|ged in n|
|00003a60| 75 6d 65 72 69 63 61 6c | 6c 79 20 64 65 73 63 65 |umerical|ly desce|
|00003a70| 6e 64 69 6e 67 20 28 44 | 45 53 43 29 20 6f 72 64 |nding (D|ESC) ord|
|00003a80| 65 72 2e 20 49 66 20 6e | 6f 20 6f 72 64 65 72 20 |er. If n|o order |
|00003a90| 69 73 20 73 70 65 63 69 | 66 69 65 64 20 66 6f 72 |is speci|fied for|
|00003aa0| 20 61 20 73 6f 72 74 20 | 63 6f 6c 75 6d 6e 2c 20 | a sort |column, |
|00003ab0| 61 73 63 65 6e 64 69 6e | 67 20 6f 72 64 65 72 20 |ascendin|g order |
|00003ac0| 69 73 20 61 6c 77 61 79 | 73 20 74 68 65 20 69 6d |is alway|s the im|
|00003ad0| 70 6c 69 63 69 74 20 73 | 6f 72 74 69 6e 67 20 64 |plicit s|orting d|
|00003ae0| 65 66 61 75 6c 74 2e 20 | 41 73 63 65 6e 64 69 6e |efault. |Ascendin|
|00003af0| 67 20 63 61 6e 20 61 6c | 73 6f 20 62 65 20 65 78 |g can al|so be ex|
|00003b00| 70 6c 69 63 69 74 6c 79 | 20 73 70 65 63 69 66 69 |plicitly| specifi|
|00003b10| 65 64 20 77 69 74 68 20 | 41 53 43 2e 20 00 00 15 |ed with |ASC. ...|
|00003b20| 02 00 00 c4 01 00 00 f8 | c0 00 00 34 c5 00 00 51 |........|...4...Q|
|00003b30| 00 00 00 20 70 80 8b 03 | 00 80 00 00 10 00 e3 80 |... p...|........|
|00003b40| 80 0c 00 82 80 0d 00 82 | 82 82 82 83 86 22 08 80 |........|....."..|
|00003b50| 02 00 00 09 00 82 80 0c | 00 82 82 82 82 82 82 82 |........|........|
|00003b60| 80 0d 00 82 82 82 80 0c | 00 82 82 82 82 82 82 ff |........|........|
|00003b70| 00 20 00 00 53 45 4c 45 | 43 54 20 6e 61 6d 65 2c |. ..SELE|CT name,|
|00003b80| 20 66 69 72 73 74 6e 61 | 6d 65 2c 20 63 69 74 79 | firstna|me, city|
|00003b90| 2c 20 61 63 63 6f 75 6e | 74 00 20 20 20 20 20 20 |, accoun|t.      |
|00003ba0| 20 46 52 4f 4d 20 63 75 | 73 74 6f 6d 65 72 00 20 | FROM cu|stomer. |
|00003bb0| 20 20 20 20 20 20 4f 52 | 44 45 52 20 42 59 20 61 |      OR|DER BY a|
|00003bc0| 63 63 6f 75 6e 74 20 44 | 45 53 43 00 20 00 00 00 |ccount D|ESC. ...|
|00003bd0| 00 00 20 00 20 00 41 20 | 73 6f 72 74 20 63 6f 6c |.. . .A |sort col|
|00003be0| 75 6d 6e 20 6e 65 65 64 | 20 6e 6f 74 20 62 65 20 |umn need| not be |
|00003bf0| 61 6e 20 6f 75 74 70 75 | 74 20 63 6f 6c 75 6d 6e |an outpu|t column|
|00003c00| 20 61 73 20 77 65 6c 6c | 2e 20 00 20 00 20 00 54 | as well|. . . .T|
|00003c10| 68 65 20 70 6f 73 69 74 | 69 6f 6e 20 6e 75 6d 62 |he posit|ion numb|
|00003c20| 65 72 20 6d 61 79 20 62 | 65 20 73 70 65 63 69 66 |er may b|e specif|
|00003c30| 69 65 64 20 69 6e 20 74 | 68 65 20 6f 75 74 70 75 |ied in t|he outpu|
|00003c40| 74 20 6c 69 73 74 20 69 | 6e 73 74 65 61 64 20 6f |t list i|nstead o|
|00003c50| 66 20 74 68 65 20 73 6f | 72 74 20 63 6f 6c 75 6d |f the so|rt colum|
|00003c60| 6e 20 6e 61 6d 65 3a 20 | 00 20 00 00 53 45 4c 45 |n name: |. ..SELE|
|00003c70| 43 54 20 6e 61 6d 65 2c | 20 66 69 72 73 74 6e 61 |CT name,| firstna|
|00003c80| 6d 65 2c 20 63 69 74 79 | 2c 20 61 63 63 6f 75 6e |me, city|, accoun|
|00003c90| 74 00 20 20 20 20 20 20 | 20 46 52 4f 4d 20 63 75 |t.      | FROM cu|
|00003ca0| 73 74 6f 6d 65 72 00 20 | 20 20 20 20 20 20 4f 52 |stomer. |      OR|
|00003cb0| 44 45 52 20 42 59 20 34 | 20 44 45 53 43 00 00 20 |DER BY 4| DESC.. |
|00003cc0| 00 54 68 65 20 6f 72 64 | 65 72 20 66 6f 72 20 41 |.The ord|er for A|
|00003cd0| 53 43 49 49 20 63 6f 64 | 65 20 69 73 3a 20 00 20 |SCII cod|e is: . |
|00003ce0| 00 20 20 20 20 31 2e a0 | a0 20 42 6c 61 6e 6b 73 |.    1..|. Blanks|
|00003cf0| 20 00 20 20 20 20 32 2e | a0 a0 20 53 70 65 63 69 | .    2.|.. Speci|
|00003d00| 61 6c 20 63 68 61 72 61 | 63 74 65 72 73 20 28 25 |al chara|cters (%|
|00003d10| 2c 26 2c 2b 2c 2d 2c 2a | 2c 2f 2c 2e 2e 2e 29 20 |,&,+,-,*|,/,...) |
|00003d20| 00 20 20 20 20 33 2e a0 | a0 20 4e 75 6d 62 65 72 |.    3..|. Number|
|00003d30| 73 20 00 00 bf 02 00 00 | 86 02 00 00 1f c3 00 00 |s ......|........|
|00003d40| f3 c7 00 00 39 00 00 00 | 20 40 80 0d 05 00 80 00 |....9...| @......|
|00003d50| 00 10 00 e3 80 80 0c 00 | 82 82 82 82 82 82 82 82 |........|........|
|00003d60| 82 82 82 82 82 82 82 82 | 82 82 82 82 ff 00 20 20 |........|......  |
|00003d70| 20 20 34 2e a0 a0 20 53 | 70 65 63 69 61 6c 20 63 |  4... S|pecial c|
|00003d80| 68 61 72 61 63 74 65 72 | 73 20 20 28 3a 2c 3b 2c |haracter|s  (:,;,|
|00003d90| 3c 2c 3d 2c 3e 2c 2e 2e | 2e 29 20 00 20 20 20 20 |<,=,>,..|.) .    |
|00003da0| 35 2e a0 a0 20 43 61 70 | 69 74 61 6c 20 6c 65 74 |5... Cap|ital let|
|00003db0| 74 65 72 73 20 00 20 20 | 20 20 36 2e a0 a0 20 53 |ters .  |  6... S|
|00003dc0| 6d 61 6c 6c 20 6c 65 74 | 74 65 72 73 20 00 20 20 |mall let|ters .  |
|00003dd0| 20 20 37 2e a0 a0 20 4e | 75 6c 6c 20 76 61 6c 75 |  7... N|ull valu|
|00003de0| 65 20 00 20 00 20 00 54 | 68 65 20 6f 72 64 65 72 |e . . .T|he order|
|00003df0| 20 66 6f 72 20 45 42 43 | 44 49 43 20 63 6f 64 65 | for EBC|DIC code|
|00003e00| 20 69 73 3a 20 00 20 00 | 20 20 20 20 31 2e a0 a0 | is: . .|    1...|
|00003e10| 20 42 6c 61 6e 6b 73 20 | 00 20 20 20 20 32 2e a0 | Blanks |.    2..|
|00003e20| a0 20 53 70 65 63 69 61 | 6c 20 63 68 61 72 61 63 |. Specia|l charac|
|00003e30| 74 65 72 73 20 28 2b 2c | 26 2c 2a 2c 3b 2c 2d 2c |ters (+,|&,*,;,-,|
|00003e40| 2f 2c 25 2c 3a 2c 2e 2e | 2e 29 20 00 20 20 20 20 |/,%,:,..|.) .    |
|00003e50| 33 2e a0 a0 20 53 6d 61 | 6c 6c 20 6c 65 74 74 65 |3... Sma|ll lette|
|00003e60| 72 73 20 00 20 20 20 20 | 34 2e a0 a0 20 43 61 70 |rs .    |4... Cap|
|00003e70| 69 74 61 6c 20 6c 65 74 | 74 65 72 73 20 00 20 20 |ital let|ters .  |
|00003e80| 20 20 35 2e a0 a0 20 4e | 75 6d 62 65 72 73 20 00 |  5... N|umbers .|
|00003e90| 20 20 20 20 36 2e a0 a0 | 20 4e 75 6c 6c 20 76 61 |    6...| Null va|
|00003ea0| 6c 75 65 20 00 20 00 20 | 00 54 68 65 20 74 79 70 |lue . . |.The typ|
|00003eb0| 65 20 6f 66 20 63 6f 64 | 69 6e 67 20 69 73 20 65 |e of cod|ing is e|
|00003ec0| 73 74 61 62 6c 69 73 68 | 65 64 20 77 68 69 6c 65 |stablish|ed while|
|00003ed0| 20 64 65 66 69 6e 69 6e | 67 20 74 68 65 20 74 61 | definin|g the ta|
|00003ee0| 62 6c 65 20 28 73 65 65 | 20 62 65 6c 6f 77 29 2e |ble (see| below).|
|00003ef0| 20 00 20 00 20 00 54 6f | 20 6f 62 74 61 69 6e 20 | . . .To| obtain |
|00003f00| 61 20 75 73 65 66 75 6c | 20 68 61 6e 64 6c 69 6e |a useful| handlin|
|00003f10| 67 20 61 6e 64 20 73 6f | 72 74 69 6e 67 20 6f 66 |g and so|rting of|
|00003f20| 20 75 6d 6c 61 75 74 73 | 20 61 6e 64 20 73 70 65 | umlauts| and spe|
|00003f30| 63 69 61 6c 20 6c 65 74 | 74 65 72 73 20 6f 63 63 |cial let|ters occ|
|00003f40| 75 72 72 69 6e 67 20 69 | 6e 20 6f 74 68 65 72 20 |urring i|n other |
|00003f50| 6c 61 6e 67 75 61 67 65 | 73 2c 20 41 44 41 42 41 |language|s, ADABA|
|00003f60| 53 20 75 73 65 73 20 73 | 6f 2d 63 61 6c 6c 65 64 |S uses s|o-called|
|00003f70| 20 27 4d 41 50 43 48 41 | 52 20 53 45 54 73 27 2e | 'MAPCHA|R SETs'.|
|00003f80| 20 41 20 44 45 46 41 55 | 4c 54 4d 41 50 20 66 6f | A DEFAU|LTMAP fo|
|00003f90| 72 20 74 68 65 20 63 6f | 6e 76 65 72 73 69 6f 6e |r the co|nversion|
|00003fa0| 20 6f 66 20 63 6f 75 6e | 74 72 79 2d 73 70 65 63 | of coun|try-spec|
|00003fb0| 69 66 69 63 20 6c 65 74 | 74 65 72 73 20 69 73 20 |ific let|ters is |
|00003fc0| 63 72 65 61 74 65 64 20 | 64 75 72 69 6e 67 20 74 |created |during t|
|00003fd0| 68 65 20 69 6e 73 74 61 | 6c 6c 61 74 69 6f 6e 20 |he insta|llation |
|00003fe0| 6f 66 20 74 68 65 20 64 | 61 74 61 62 61 73 65 2e |of the d|atabase.|
|00003ff0| 20 00 00 eb 02 00 00 b8 | 02 00 00 34 c5 00 00 de | .......|...4....|
|00004000| ca 00 00 33 00 00 00 20 | 34 80 71 05 00 80 00 00 |...3... |4.q.....|
|00004010| 10 00 e3 80 80 0c 00 82 | 82 82 82 82 82 82 82 82 |........|........|
|00004020| 82 82 82 82 82 ff 00 20 | 00 54 68 65 20 64 61 74 |....... |.The dat|
|00004030| 61 62 61 73 65 20 61 64 | 6d 69 6e 69 73 74 72 61 |abase ad|ministra|
|00004040| 74 6f 72 20 63 61 6e 20 | 63 72 65 61 74 65 20 4d |tor can |create M|
|00004050| 41 50 43 48 41 52 20 53 | 45 54 73 20 6f 66 20 68 |APCHAR S|ETs of h|
|00004060| 69 73 20 6f 77 6e 2e 20 | 57 68 65 6e 20 64 6f 69 |is own. |When doi|
|00004070| 6e 67 20 73 6f 2c 20 68 | 65 20 64 65 66 69 6e 65 |ng so, h|e define|
|00004080| 73 20 74 68 65 20 77 61 | 79 20 69 6e 20 77 68 69 |s the wa|y in whi|
|00004090| 63 68 20 73 70 65 63 69 | 61 6c 20 6c 65 74 74 65 |ch speci|al lette|
|000040a0| 72 73 20 68 61 76 65 20 | 74 6f 20 62 65 20 6d 61 |rs have |to be ma|
|000040b0| 70 70 65 64 20 74 6f 20 | 6f 74 68 65 72 20 6c 65 |pped to |other le|
|000040c0| 74 74 65 72 73 2c 20 74 | 68 75 73 20 69 6e 66 6c |tters, t|hus infl|
|000040d0| 75 65 6e 63 69 6e 67 20 | 74 68 65 20 73 6f 72 74 |uencing |the sort|
|000040e0| 20 73 65 71 75 65 6e 63 | 65 2e 20 00 20 00 20 00 | sequenc|e. . . .|
|000040f0| 46 6f 72 20 65 78 61 6d | 70 6c 65 2c 20 69 66 20 |For exam|ple, if |
|00004100| 27 fc 27 20 28 69 6e 20 | 41 53 43 49 49 20 72 65 |'.' (in |ASCII re|
|00004110| 70 72 65 73 65 6e 74 69 | 6f 6e 20 58 27 46 43 27 |presenti|on X'FC'|
|00004120| 29 20 69 73 20 74 6f 20 | 62 65 20 73 6f 72 74 65 |) is to |be sorte|
|00004130| 64 20 61 73 20 27 75 65 | 27 2c 20 74 68 65 20 66 |d as 'ue|', the f|
|00004140| 6f 6c 6c 6f 77 69 6e 67 | 20 61 73 73 69 67 6e 6d |ollowing| assignm|
|00004150| 65 6e 74 20 6d 75 73 74 | 20 62 65 20 6d 61 64 65 |ent must| be made|
|00004160| 3a 20 00 20 00 a0 a0 a0 | a0 a0 a0 a0 a0 a0 a0 a0 |: . ....|........|
|00004170| a0 46 43 a0 a0 a0 a0 a0 | a0 2e 2e 2e a0 a0 a0 a0 |.FC.....|........|
|00004180| a0 a0 75 65 20 00 20 00 | 49 66 20 27 fc 27 20 69 |..ue . .|If '.' i|
|00004190| 73 20 74 6f 20 62 65 20 | 73 6f 72 74 65 64 20 61 |s to be |sorted a|
|000041a0| 73 20 27 75 27 2c 20 74 | 68 65 6e 20 74 68 65 20 |s 'u', t|hen the |
|000041b0| 6c 69 6e 65 20 6c 6f 6f | 6b 73 20 6c 69 6b 65 20 |line loo|ks like |
|000041c0| 74 68 69 73 3a 20 00 20 | 00 a0 a0 a0 a0 a0 a0 a0 |this: . |........|
|000041d0| a0 a0 a0 a0 a0 46 43 a0 | a0 a0 a0 a0 a0 2e 2e 2e |.....FC.|........|
|000041e0| a0 a0 a0 a0 a0 a0 a0 75 | 20 00 20 00 20 00 54 6f |.......u| . . .To|
|000041f0| 20 6f 62 74 61 69 6e 20 | 61 20 70 61 72 74 69 63 | obtain |a partic|
|00004200| 75 6c 61 72 20 73 6f 72 | 74 20 73 65 71 75 65 6e |ular sor|t sequen|
|00004210| 63 65 20 66 6f 72 20 61 | 20 72 65 73 75 6c 74 20 |ce for a| result |
|00004220| 74 61 62 6c 65 2c 20 74 | 68 65 20 66 75 6e 63 74 |table, t|he funct|
|00004230| 69 6f 6e 20 4d 41 50 43 | 48 41 52 20 6d 75 73 74 |ion MAPC|HAR must|
|00004240| 20 62 65 20 75 73 65 64 | 2e 20 49 66 20 74 68 65 | be used|. If the|
|00004250| 20 73 6f 72 74 20 73 65 | 71 75 65 6e 63 65 20 69 | sort se|quence i|
|00004260| 73 20 74 6f 20 64 65 76 | 69 61 74 65 20 66 72 6f |s to dev|iate fro|
|00004270| 6d 20 74 68 65 20 44 45 | 46 41 55 4c 54 4d 41 50 |m the DE|FAULTMAP|
|00004280| 2c 20 61 20 4d 41 50 43 | 48 41 52 20 53 45 54 20 |, a MAPC|HAR SET |
|00004290| 64 65 66 69 6e 65 64 20 | 62 79 20 74 68 65 20 61 |defined |by the a|
|000042a0| 64 6d 69 6e 69 73 74 72 | 61 74 6f 72 20 6d 75 73 |dministr|ator mus|
|000042b0| 74 20 62 65 20 73 70 65 | 63 69 66 69 65 64 20 61 |t be spe|cified a|
|000042c0| 73 20 61 72 67 75 6d 65 | 6e 74 20 6f 66 20 74 68 |s argume|nt of th|
|000042d0| 65 20 66 75 6e 63 74 69 | 6f 6e 2e 20 00 00 dd 00 |e functi|on. ....|
|000042e0| 00 00 a8 00 00 00 f3 c7 | 00 00 bb cb 00 00 35 00 |........|......5.|
|000042f0| 00 00 20 38 80 51 01 00 | 80 00 00 10 00 e3 80 80 |.. 8.Q..|........|
|00004300| 0c 00 82 82 82 82 80 0d | 00 82 82 82 80 0c 00 82 |........|........|
|00004310| 82 82 ff 00 20 00 20 00 | 54 68 65 20 73 74 61 74 |.... . .|The stat|
|00004320| 65 6d 65 6e 74 20 00 20 | 00 00 53 45 4c 45 43 54 |ement . |..SELECT|
|00004330| 20 6e 61 6d 65 2c 20 66 | 69 72 73 74 6e 61 6d 65 | name, f|irstname|
|00004340| 2c 20 63 69 74 79 2c 20 | 61 63 63 6f 75 6e 74 2c |, city, |account,|
|00004350| 20 4d 41 50 43 48 41 52 | 28 6e 61 6d 65 29 20 6c | MAPCHAR|(name) l|
|00004360| 6e 61 6d 65 00 20 20 20 | 20 20 20 20 46 52 4f 4d |name.   |    FROM|
|00004370| 20 63 75 73 74 6f 6d 65 | 72 00 20 20 20 20 20 20 | custome|r.      |
|00004380| 20 4f 52 44 45 52 20 42 | 59 20 6c 6e 61 6d 65 00 | ORDER B|Y lname.|
|00004390| 00 20 00 70 72 6f 64 75 | 63 65 73 20 74 68 65 20 |. .produ|ces the |
|000043a0| 64 65 73 69 72 65 64 20 | 73 6f 72 74 20 73 65 71 |desired |sort seq|
|000043b0| 75 65 6e 63 65 2e 20 00 | 20 00 00 5b 00 00 00 2a |uence. .| ..[...*|
|000043c0| 00 00 00 de ca 00 00 16 | cc 00 00 31 00 00 00 02 |........|...1....|
|000043d0| 9f 03 00 00 00 80 01 00 | 00 00 02 00 09 00 00 00 |........|........|
|000043e0| 16 cc 00 00 66 cc 00 00 | 0c 00 01 00 4f 72 64 65 |....f...|....Orde|
|000043f0| 72 69 6e 67 a0 41 63 63 | 6f 72 64 69 6e 67 a0 74 |ring.Acc|ording.t|
|00004400| 6f a0 4d 6f 72 65 a0 74 | 68 61 6e a0 4f 6e 65 a0 |o.More.t|han.One.|
|00004410| 43 6f 6c 75 6d 6e 50 00 | 00 00 2d 00 00 00 bb cb |ColumnP.|..-.....|
|00004420| 00 00 66 cc 00 00 23 00 | 00 00 20 16 80 5a 00 80 |..f...#.|.. ..Z..|
|00004430| 00 00 00 00 80 03 00 82 | ff 00 4f 72 64 65 72 69 |........|..Orderi|
|00004440| 6e 67 a0 41 63 63 6f 72 | 64 69 6e 67 a0 74 6f a0 |ng.Accor|ding.to.|
|00004450| 4d 6f 72 65 a0 74 68 61 | 6e a0 4f 6e 65 a0 43 6f |More.tha|n.One.Co|
|00004460| 6c 75 6d 6e 00 00 1f 02 | 00 00 ee 01 00 00 16 cc |lumn....|........|
|00004470| 00 00 85 ce 00 00 31 00 | 00 00 20 30 80 dd 03 00 |......1.|.. 0....|
|00004480| 80 00 00 10 00 e3 80 80 | 0c 00 82 82 82 82 82 82 |........|........|
|00004490| 82 82 80 0d 00 82 ff 00 | 20 00 54 6f 20 70 65 72 |........| .To per|
|000044a0| 66 6f 72 6d 20 61 20 73 | 6f 72 74 69 6e 67 20 61 |form a s|orting a|
|000044b0| 63 63 6f 72 64 69 6e 67 | 20 74 6f 20 6d 6f 72 65 |ccording| to more|
|000044c0| 20 74 68 61 6e 20 6f 6e | 65 20 63 72 69 74 65 72 | than on|e criter|
|000044d0| 69 6f 6e 2c 20 61 6c 6c | 20 73 6f 72 74 20 63 6f |ion, all| sort co|
|000044e0| 6c 75 6d 6e 20 6e 61 6d | 65 73 20 6d 75 73 74 20 |lumn nam|es must |
|000044f0| 62 65 20 65 6e 74 65 72 | 65 64 20 69 6e 20 74 68 |be enter|ed in th|
|00004500| 65 20 6f 72 64 65 72 20 | 6f 66 20 74 68 65 69 72 |e order |of their|
|00004510| 20 69 6d 70 6f 72 74 61 | 6e 63 65 2e 20 45 61 63 | importa|nce. Eac|
|00004520| 68 20 63 6f 6c 75 6d 6e | 20 6e 61 6d 65 20 63 61 |h column| name ca|
|00004530| 6e 20 62 65 20 71 75 61 | 6c 69 66 69 65 64 20 62 |n be qua|lified b|
|00004540| 79 20 41 53 43 20 6f 72 | 20 44 45 53 43 2e 20 54 |y ASC or| DESC. T|
|00004550| 68 65 73 65 20 71 75 61 | 6c 69 66 69 63 61 74 69 |hese qua|lificati|
|00004560| 6f 6e 73 20 63 61 6e 20 | 61 6c 73 6f 20 62 65 20 |ons can |also be |
|00004570| 6d 69 78 65 64 2e 20 00 | 20 00 49 6e 20 74 68 65 |mixed. .| .In the|
|00004580| 20 6e 65 78 74 20 74 77 | 6f 20 65 78 61 6d 70 6c | next tw|o exampl|
|00004590| 65 73 2c 20 74 68 65 20 | 73 6f 72 74 69 6e 67 20 |es, the |sorting |
|000045a0| 69 73 20 64 6f 6e 65 20 | 61 63 63 6f 72 64 69 6e |is done |accordin|
|000045b0| 67 20 74 6f 20 74 77 6f | 20 63 72 69 74 65 72 69 |g to two| criteri|
|000045c0| 61 2c 20 74 68 65 20 6f | 72 64 65 72 20 2d 20 61 |a, the o|rder - a|
|000045d0| 6e 64 20 74 68 65 72 65 | 66 6f 72 65 20 74 68 65 |nd there|fore the|
|000045e0| 20 69 6d 70 6f 72 74 61 | 6e 63 65 20 2d 20 6f 66 | importa|nce - of|
|000045f0| 20 77 68 69 63 68 20 69 | 73 20 69 6e 74 65 72 63 | which i|s interc|
|00004600| 68 61 6e 67 65 64 2e 20 | 00 20 00 20 00 49 6e 20 |hanged. |. . .In |
|00004610| 74 68 65 20 66 69 72 73 | 74 20 63 61 73 65 2c 20 |the firs|t case, |
|00004620| 74 68 65 20 6d 61 69 6e | 20 63 72 69 74 65 72 69 |the main| criteri|
|00004630| 6f 6e 20 69 73 20 74 68 | 65 20 63 69 74 79 2c 20 |on is th|e city, |
|00004640| 74 68 65 20 73 65 63 6f | 6e 64 61 72 79 20 63 72 |the seco|ndary cr|
|00004650| 69 74 65 72 69 6f 6e 20 | 74 68 65 20 61 63 63 6f |iterion |the acco|
|00004660| 75 6e 74 2e 20 00 20 00 | 00 53 45 4c 45 43 54 20 |unt. . .|.SELECT |
|00004670| 6e 61 6d 65 2c 20 63 69 | 74 79 2c 20 61 63 63 6f |name, ci|ty, acco|
|00004680| 75 6e 74 00 00 4f 01 00 | 00 00 01 00 00 66 cc 00 |unt..O..|.....f..|
|00004690| 00 0c 00 01 00 4f 00 00 | 00 20 6c 80 05 02 00 80 |.....O..|. l.....|
|000046a0| 00 00 10 00 e3 80 80 0d | 00 82 82 82 83 86 22 08 |........|......".|
|000046b0| 80 02 00 00 0a 00 82 80 | 0c 00 82 82 82 80 0d 00 |........|........|
|000046c0| 82 82 82 82 83 86 22 08 | 80 02 00 00 0b 00 82 80 |......".|........|
|000046d0| 0c 00 82 ff 00 20 20 20 | 20 20 20 20 46 52 4f 4d |.....   |    FROM|
|000046e0| 20 63 75 73 74 6f 6d 65 | 72 00 20 20 20 20 20 20 | custome|r.      |
|000046f0| 20 4f 52 44 45 52 20 42 | 59 20 63 69 74 79 2c 20 | ORDER B|Y city, |
|00004700| 61 63 63 6f 75 6e 74 20 | 44 45 53 43 00 20 00 00 |account |DESC. ..|
|00004710| 00 00 00 20 00 49 6e 20 | 74 68 65 20 66 6f 6c 6c |... .In |the foll|
|00004720| 6f 77 69 6e 67 20 65 78 | 61 6d 70 6c 65 2c 20 74 |owing ex|ample, t|
|00004730| 68 65 20 6d 61 69 6e 20 | 63 72 69 74 65 72 69 6f |he main |criterio|
|00004740| 6e 20 69 73 20 74 68 65 | 20 61 63 63 6f 75 6e 74 |n is the| account|
|00004750| 2c 20 74 68 65 20 73 65 | 63 6f 6e 64 61 72 79 20 |, the se|condary |
|00004760| 63 72 69 74 65 72 69 6f | 6e 20 74 68 65 20 63 69 |criterio|n the ci|
|00004770| 74 79 2e 20 00 20 00 00 | 53 45 4c 45 43 54 20 6e |ty. . ..|SELECT n|
|00004780| 61 6d 65 2c 20 63 69 74 | 79 2c 20 61 63 63 6f 75 |ame, cit|y, accou|
|00004790| 6e 74 00 20 20 20 20 20 | 20 20 46 52 4f 4d 20 63 |nt.     |  FROM c|
|000047a0| 75 73 74 6f 6d 65 72 00 | 20 20 20 20 20 20 20 4f |ustomer.|       O|
|000047b0| 52 44 45 52 20 42 59 20 | 61 63 63 6f 75 6e 74 20 |RDER BY |account |
|000047c0| 44 45 53 43 2c 20 63 69 | 74 79 00 20 00 00 00 00 |DESC, ci|ty. ....|
|000047d0| 00 20 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |. ......|........|
|000047e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000047f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004800| 85 ce 00 00 0c 00 01 00 | bb cb 00 00 4b 00 00 00 |........|....K...|
|00004810| 1a 00 00 00 85 ce 00 00 | 57 00 01 00 31 00 00 00 |........|W...1...|
|00004820| 02 c8 01 00 00 a0 89 01 | 00 5e 01 02 00 0a 00 00 |........|.^......|
|00004830| 00 57 00 01 00 97 00 01 | 00 2e 02 01 00 45 6c 69 |.W......|.....Eli|
|00004840| 6d 69 6e 61 74 69 6e 67 | a0 44 75 70 6c 69 63 61 |minating|.Duplica|
|00004850| 74 65 a0 52 6f 77 73 40 | 00 00 00 1d 00 00 00 0c |te.Rows@|........|
|00004860| 00 01 00 97 00 01 00 23 | 00 00 00 20 16 80 3a 00 |.......#|... ..:.|
|00004870| 80 00 00 00 00 80 03 00 | 82 ff 00 45 6c 69 6d 69 |........|...Elimi|
|00004880| 6e 61 74 69 6e 67 a0 44 | 75 70 6c 69 63 61 74 65 |nating.D|uplicate|
|00004890| a0 52 6f 77 73 00 00 97 | 01 00 00 3f 01 00 00 57 |.Rows...|...?...W|
|000048a0| 00 01 00 2e 02 01 00 58 | 00 00 00 20 7e 80 83 02 |.......X|... ~...|
|000048b0| 00 80 00 00 10 00 e3 80 | 80 0c 00 82 82 82 80 0d |........|........|
|000048c0| 00 82 82 82 82 83 86 22 | 08 80 02 00 00 0c 00 82 |......."|........|
|000048d0| 80 0c 00 82 82 82 82 80 | 0d 00 82 82 82 82 82 83 |........|........|
|000048e0| 86 22 08 80 02 00 00 0d | 00 82 80 0c 00 82 ff 00 |."......|........|
|000048f0| 20 00 41 6c 6c 20 63 75 | 73 74 6f 6d 65 72 20 63 | .All cu|stomer c|
|00004900| 69 74 69 65 73 20 61 72 | 65 20 74 6f 20 62 65 20 |ities ar|e to be |
|00004910| 72 65 74 72 69 65 76 65 | 64 2e 20 46 69 72 73 74 |retrieve|d. First|
|00004920| 20 61 6c 6c 20 63 69 74 | 69 65 73 20 61 72 65 20 | all cit|ies are |
|00004930| 6f 75 74 70 75 74 20 61 | 73 20 6f 66 74 65 6e 20 |output a|s often |
|00004940| 61 73 20 74 68 65 79 20 | 61 72 65 20 73 74 6f 72 |as they |are stor|
|00004950| 65 64 2e 20 00 20 00 00 | 53 45 4c 45 43 54 20 63 |ed. . ..|SELECT c|
|00004960| 69 74 79 2c 20 73 74 61 | 74 65 00 20 20 20 20 20 |ity, sta|te.     |
|00004970| 20 20 46 52 4f 4d 20 63 | 75 73 74 6f 6d 65 72 00 |  FROM c|ustomer.|
|00004980| 20 20 20 20 20 20 20 4f | 52 44 45 52 20 42 59 20 |       O|RDER BY |
|00004990| 73 74 61 74 65 00 20 00 | 00 00 00 00 20 00 20 00 |state. .|.... . .|
|000049a0| 54 68 69 73 20 72 65 64 | 75 6e 64 61 6e 63 79 20 |This red|undancy |
|000049b0| 63 61 6e 20 62 65 20 61 | 76 6f 69 64 65 64 20 62 |can be a|voided b|
|000049c0| 79 20 74 68 65 20 75 73 | 61 67 65 20 6f 66 20 44 |y the us|age of D|
|000049d0| 49 53 54 49 4e 43 54 2e | 20 00 20 00 00 20 00 53 |ISTINCT.| . .. .S|
|000049e0| 45 4c 45 43 54 20 44 49 | 53 54 49 4e 43 54 20 63 |ELECT DI|STINCT c|
|000049f0| 69 74 79 2c 20 73 74 61 | 74 65 00 20 20 20 20 20 |ity, sta|te.     |
|00004a00| 20 20 46 52 4f 4d 20 63 | 75 73 74 6f 6d 65 72 00 |  FROM c|ustomer.|
|00004a10| 20 20 20 20 20 20 20 4f | 52 44 45 52 20 42 59 20 |       O|RDER BY |
|00004a20| 63 69 74 79 00 20 00 00 | 00 00 00 20 00 00 44 00 |city. ..|... ..D.|
|00004a30| 00 00 13 00 00 00 97 00 | 01 00 72 02 01 00 31 00 |........|..r...1.|
|00004a40| 00 00 02 d6 02 00 00 00 | 00 02 00 a1 03 02 00 0b |........|........|
|00004a50| 00 00 00 72 02 01 00 ab | 02 01 00 50 05 01 00 4b |...r....|...P...K|
|00004a60| 65 65 70 69 6e 67 a0 52 | 65 73 75 6c 74 a0 53 65 |eeping.R|esult.Se|
|00004a70| 74 73 39 00 00 00 16 00 | 00 00 2e 02 01 00 ab 02 |ts9.....|........|
|00004a80| 01 00 23 00 00 00 20 16 | 80 2c 00 80 00 00 00 00 |..#... .|.,......|
|00004a90| 80 03 00 82 ff 00 4b 65 | 65 70 69 6e 67 a0 52 65 |......Ke|eping.Re|
|00004aa0| 73 75 6c 74 a0 53 65 74 | 73 00 00 0a 02 00 00 dc |sult.Set|s.......|
|00004ab0| 01 00 00 72 02 01 00 b5 | 04 01 00 2e 00 00 00 20 |...r....|....... |
|00004ac0| 2a 80 b9 03 00 80 00 00 | 10 00 e3 80 80 0c 00 82 |*.......|........|
|00004ad0| 82 82 80 0d 00 82 82 82 | ff 00 20 00 49 66 20 61 |........|.. .If a|
|00004ae0| 20 75 73 65 72 20 77 61 | 6e 74 73 20 74 6f 20 72 | user wa|nts to r|
|00004af0| 65 75 73 65 20 61 20 72 | 65 73 75 6c 74 20 74 61 |euse a r|esult ta|
|00004b00| 62 6c 65 20 69 6e 20 6f | 74 68 65 72 20 71 75 65 |ble in o|ther que|
|00004b10| 72 69 65 73 2c 20 68 65 | 20 6d 75 73 74 20 6e 61 |ries, he| must na|
|00004b20| 6d 65 20 69 74 20 61 6e | 64 20 73 70 65 63 69 66 |me it an|d specif|
|00004b30| 79 20 46 4f 52 20 52 45 | 55 53 45 20 66 6f 72 20 |y FOR RE|USE for |
|00004b40| 69 74 2e 20 54 68 65 6e | 20 74 68 65 20 74 61 62 |it. Then| the tab|
|00004b50| 6c 65 20 63 61 6e 20 62 | 65 20 61 64 64 72 65 73 |le can b|e addres|
|00004b60| 73 65 64 20 77 69 74 68 | 69 6e 20 61 20 74 72 61 |sed with|in a tra|
|00004b70| 6e 73 61 63 74 69 6f 6e | 20 62 79 20 74 68 69 73 |nsaction| by this|
|00004b80| 20 6e 61 6d 65 20 61 74 | 20 61 6e 79 20 74 69 6d | name at| any tim|
|00004b90| 65 20 69 66 20 69 74 20 | 68 61 73 20 6e 6f 74 20 |e if it |has not |
|00004ba0| 62 65 65 6e 20 65 78 70 | 6c 69 63 69 74 6c 79 20 |been exp|licitly |
|00004bb0| 64 65 6c 65 74 65 64 20 | 6f 72 20 61 6e 6f 74 68 |deleted |or anoth|
|00004bc0| 65 72 20 53 45 4c 45 43 | 54 20 73 70 65 63 69 66 |er SELEC|T specif|
|00004bd0| 79 69 6e 67 20 61 20 72 | 65 73 75 6c 74 20 74 61 |ying a r|esult ta|
|00004be0| 62 6c 65 20 77 69 74 68 | 20 74 68 65 20 73 61 6d |ble with| the sam|
|00004bf0| 65 20 6e 61 6d 65 20 68 | 61 73 20 6e 6f 74 20 62 |e name h|as not b|
|00004c00| 65 65 6e 20 70 65 72 66 | 6f 72 6d 65 64 2e 20 57 |een perf|ormed. W|
|00004c10| 68 65 6e 20 6c 65 61 76 | 69 6e 67 20 74 68 65 20 |hen leav|ing the |
|00004c20| 73 65 73 73 69 6f 6e 2c | 20 74 68 65 20 72 65 73 |session,| the res|
|00004c30| 75 6c 74 20 74 61 62 6c | 65 20 69 73 20 61 75 74 |ult tabl|e is aut|
|00004c40| 6f 6d 61 74 69 63 61 6c | 6c 79 20 64 65 6c 65 74 |omatical|ly delet|
|00004c50| 65 64 2e 20 00 20 00 00 | 53 45 4c 45 43 54 20 72 |ed. . ..|SELECT r|
|00004c60| 65 70 6f 72 74 31 20 28 | 74 69 74 6c 65 2c 20 66 |eport1 (|title, f|
|00004c70| 69 72 73 74 6e 61 6d 65 | 2c 20 6e 61 6d 65 29 00 |irstname|, name).|
|00004c80| 20 20 20 20 20 20 20 46 | 52 4f 4d 20 63 75 73 74 |       F|ROM cust|
|00004c90| 6f 6d 65 72 00 20 20 20 | 20 20 20 20 57 48 45 52 |omer.   |    WHER|
|00004ca0| 45 20 63 69 74 79 20 3d | 20 27 4e 65 77 20 59 6f |E city =| 'New Yo|
|00004cb0| 72 6b 27 00 00 9b 00 00 | 00 4f 00 00 00 ab 02 01 |rk'.....|.O......|
|00004cc0| 00 50 05 01 00 4c 00 00 | 00 20 68 80 a2 00 80 00 |.P...L..|. h.....|
|00004cd0| 00 10 00 e3 80 80 0d 00 | 82 82 83 86 22 08 80 02 |........|...."...|
|00004ce0| 00 00 0e 00 82 80 0c 00 | 82 82 80 0d 00 82 82 82 |........|........|
|00004cf0| 82 83 86 22 08 80 02 00 | 00 0f 00 82 80 0c 00 82 |..."....|........|
|00004d00| ff 00 20 20 20 20 20 20 | 20 46 4f 52 20 52 45 55 |..      | FOR REU|
|00004d10| 53 45 00 20 00 00 00 00 | 00 20 00 20 00 00 20 00 |SE. ....|. . .. .|
|00004d20| 53 45 4c 45 43 54 20 74 | 69 74 6c 65 2c 20 6e 61 |SELECT t|itle, na|
|00004d30| 6d 65 00 20 20 20 20 20 | 20 20 46 52 4f 4d 20 72 |me.     |  FROM r|
|00004d40| 65 70 6f 72 74 31 00 20 | 00 00 00 00 00 20 00 00 |eport1. |..... ..|
|00004d50| 54 00 00 00 23 00 00 00 | b5 04 01 00 a4 05 01 00 |T...#...|........|
|00004d60| 31 00 00 00 02 0b 03 00 | 00 5e 01 02 00 ff ff ff |1.......|.^......|
|00004d70| ff 0c 00 00 00 a4 05 01 | 00 ed 05 01 00 c7 08 01 |........|........|
|00004d80| 00 49 6e 74 72 6f 64 75 | 63 69 6e 67 a0 4e 65 77 |.Introdu|cing.New|
|00004d90| a0 52 65 73 75 6c 74 a0 | 43 6f 6c 75 6d 6e a0 4e |.Result.|Column.N|
|00004da0| 61 6d 65 73 49 00 00 00 | 26 00 00 00 50 05 01 00 |amesI...|&...P...|
|00004db0| ed 05 01 00 23 00 00 00 | 20 16 80 4c 00 80 00 00 |....#...| ..L....|
|00004dc0| 00 00 80 03 00 82 ff 00 | 49 6e 74 72 6f 64 75 63 |........|Introduc|
|00004dd0| 69 6e 67 a0 4e 65 77 a0 | 52 65 73 75 6c 74 a0 43 |ing.New.|Result.C|
|00004de0| 6f 6c 75 6d 6e a0 4e 61 | 6d 65 73 00 00 29 02 00 |olumn.Na|mes..)..|
|00004df0| 00 e0 01 00 00 a4 05 01 | 00 16 08 01 00 49 00 00 |........|.....I..|
|00004e00| 00 20 60 80 c3 03 00 80 | 00 00 10 00 e3 80 80 0c |. `.....|........|
|00004e10| 00 82 82 82 82 82 82 80 | 0d 00 82 82 82 82 82 83 |........|........|
|00004e20| 86 22 08 80 02 00 00 10 | 00 82 80 0c 00 82 82 82 |."......|........|
|00004e30| 82 80 0d 00 82 ff 00 20 | 00 49 6e 20 74 68 65 20 |....... |.In the |
|00004e40| 65 78 61 6d 70 6c 65 73 | 20 73 68 6f 77 6e 20 73 |examples| shown s|
|00004e50| 6f 20 66 61 72 2c 20 74 | 68 65 20 63 6f 6c 75 6d |o far, t|he colum|
|00004e60| 6e 20 6e 61 6d 65 73 20 | 6f 66 20 74 68 65 20 62 |n names |of the b|
|00004e70| 61 73 65 20 74 61 62 6c | 65 20 77 65 72 65 20 75 |ase tabl|e were u|
|00004e80| 73 65 64 20 66 6f 72 20 | 74 68 65 20 63 6f 6c 75 |sed for |the colu|
|00004e90| 6d 6e 20 6e 61 6d 65 73 | 20 6f 66 20 74 68 65 20 |mn names| of the |
|00004ea0| 72 65 73 75 6c 74 20 74 | 61 62 6c 65 2e 20 00 20 |result t|able. . |
|00004eb0| 00 20 00 49 74 20 69 73 | 20 70 6f 73 73 69 62 6c |. .It is| possibl|
|00004ec0| 65 20 74 6f 20 67 69 76 | 65 20 72 65 73 75 6c 74 |e to giv|e result|
|00004ed0| 20 63 6f 6c 75 6d 6e 73 | 20 6e 65 77 20 6e 61 6d | columns| new nam|
|00004ee0| 65 73 2e 20 00 20 00 00 | 53 45 4c 45 43 54 20 74 |es. . ..|SELECT t|
|00004ef0| 69 74 6c 65 20 6d 72 6d | 72 73 2c 20 66 69 72 73 |itle mrm|rs, firs|
|00004f00| 74 6e 61 6d 65 20 63 68 | 72 69 73 74 69 61 6e 6e |tname ch|ristiann|
|00004f10| 61 6d 65 00 20 20 20 20 | 20 20 20 6e 61 6d 65 20 |ame.    |   name |
|00004f20| 73 75 72 6e 61 6d 65 2c | 20 63 69 74 79 20 61 64 |surname,| city ad|
|00004f30| 64 72 65 73 73 00 20 20 | 20 20 20 20 20 46 52 4f |dress.  |     FRO|
|00004f40| 4d 20 63 75 73 74 6f 6d | 65 72 00 20 20 20 20 20 |M custom|er.     |
|00004f50| 20 20 57 48 45 52 45 20 | 63 69 74 79 20 3d 20 27 |  WHERE |city = '|
|00004f60| 4e 65 77 20 59 6f 72 6b | 27 00 20 00 00 00 00 00 |New York|'. .....|
|00004f70| 20 00 20 00 4f 66 20 63 | 6f 75 72 73 65 2c 20 74 | . .Of c|ourse, t|
|00004f80| 68 65 73 65 20 74 77 6f | 20 66 6f 72 6d 73 20 6f |hese two| forms o|
|00004f90| 66 20 72 65 6e 61 6d 69 | 6e 67 20 72 65 73 75 6c |f renami|ng resul|
|00004fa0| 74 20 73 65 74 73 20 61 | 6e 64 20 72 65 73 75 6c |t sets a|nd resul|
|00004fb0| 74 20 63 6f 6c 75 6d 6e | 73 20 63 61 6e 20 62 65 |t column|s can be|
|00004fc0| 20 63 6f 6d 62 69 6e 65 | 64 20 69 6e 20 61 20 73 | combine|d in a s|
|00004fd0| 74 61 74 65 6d 65 6e 74 | 2e 20 00 20 00 00 53 45 |tatement|. . ..SE|
|00004fe0| 4c 45 43 54 20 72 65 70 | 6f 72 74 32 20 28 6e 61 |LECT rep|ort2 (na|
|00004ff0| 6d 65 20 63 75 73 74 6f | 6d 65 72 2c 20 63 69 74 |me custo|mer, cit|
|00005000| 79 20 64 69 73 70 61 74 | 63 68 2c 20 61 63 63 6f |y dispat|ch, acco|
|00005010| 75 6e 74 29 00 00 82 00 | 00 00 4b 00 00 00 ed 05 |unt)....|..K.....|
|00005020| 01 00 98 08 01 00 37 00 | 00 00 20 3e 80 98 00 80 |......7.|.. >....|
|00005030| 00 00 10 00 e3 80 80 0d | 00 82 82 82 82 83 86 22 |........|......."|
|00005040| 08 80 02 00 00 11 00 82 | 80 0c 00 82 ff 00 20 20 |........|......  |
|00005050| 20 20 20 20 20 46 52 4f | 4d 20 63 75 73 74 6f 6d |     FRO|M custom|
|00005060| 65 72 00 20 20 20 20 20 | 20 20 57 48 45 52 45 20 |er.     |  WHERE |
|00005070| 61 63 63 6f 75 6e 74 20 | 3d 20 30 2e 30 00 20 20 |account |= 0.0.  |
|00005080| 20 20 20 20 20 46 4f 52 | 20 52 45 55 53 45 00 20 |     FOR| REUSE. |
|00005090| 00 00 00 00 00 20 00 00 | 2f 00 00 00 09 00 00 00 |..... ..|/.......|
|000050a0| 16 08 01 00 c7 08 01 00 | 26 00 00 00 20 1c 80 12 |........|&... ...|
|000050b0| 00 80 00 00 00 00 80 04 | 00 82 82 82 82 ff 00 20 |........|....... |
|000050c0| 00 20 00 20 00 00 00 5e | 00 00 00 2d 00 00 00 98 |. . ...^|...-....|
|000050d0| 08 01 00 25 09 01 00 31 | 00 00 00 02 6a 04 00 00 |...%...1|....j...|
|000050e0| ff ff ff ff 4e 09 02 00 | 0d 00 00 00 25 09 01 00 |....N...|....%...|
|000050f0| 60 09 01 00 99 0d 01 00 | 43 6f 6e 64 69 74 69 6f |`.......|Conditio|
|00005100| 6e 61 6c a0 53 65 6c 65 | 63 74 69 6f 6e 20 2d 20 |nal.Sele|ction - |
|00005110| 43 6f 6e 64 69 74 69 6f | 6e 61 6c a0 53 65 6c 65 |Conditio|nal.Sele|
|00005120| 63 74 69 6f 6e 3b 00 00 | 00 18 00 00 00 c7 08 01 |ction;..|........|
|00005130| 00 60 09 01 00 23 00 00 | 00 20 16 80 30 00 80 00 |.`...#..|. ..0...|
|00005140| 00 00 00 80 03 00 82 ff | 00 43 6f 6e 64 69 74 69 |........|.Conditi|
|00005150| 6f 6e 61 6c a0 53 65 6c | 65 63 74 69 6f 6e 00 00 |onal.Sel|ection..|
|00005160| ac 00 00 00 81 00 00 00 | 25 09 01 00 0c 0a 01 00 |........|%.......|
|00005170| 2b 00 00 00 20 24 80 03 | 01 00 80 00 00 10 00 e3 |+... $..|........|
|00005180| 80 80 0c 00 82 82 82 82 | 82 82 ff 00 20 00 54 68 |........|.... .Th|
|00005190| 65 20 6e 65 78 74 20 70 | 61 67 65 73 20 73 68 6f |e next p|ages sho|
|000051a0| 77 20 76 61 72 69 6f 75 | 73 20 63 6f 6e 64 69 74 |w variou|s condit|
|000051b0| 69 6f 6e 73 20 74 68 61 | 74 20 63 61 6e 20 62 65 |ions tha|t can be|
|000051c0| 20 77 72 69 74 74 65 6e | 20 61 66 74 65 72 20 57 | written| after W|
|000051d0| 48 45 52 45 2e 20 00 20 | 00 20 00 41 70 61 72 74 |HERE. . |. .Apart|
|000051e0| 20 66 72 6f 6d 20 45 51 | 55 41 4c 20 54 4f 20 28 | from EQ|UAL TO (|
|000051f0| 77 72 69 74 74 65 6e 20 | 27 3d 27 29 20 74 68 65 |written |'=') the|
|00005200| 72 65 20 61 72 65 3a 20 | 00 20 00 00 22 02 00 00 |re are: |. .."...|
|00005210| cd 01 00 00 60 09 01 00 | 2e 0c 01 00 55 00 00 00 |....`...|....U...|
|00005220| 20 78 80 9b 03 00 80 00 | 00 50 02 fd 83 e9 7c 82 | x......|.P....|.|
|00005230| fd 03 80 0c 00 83 82 83 | 82 82 83 82 83 82 82 83 |........|........|
|00005240| 82 82 83 82 83 82 82 83 | 82 83 82 82 83 82 83 82 |........|........|
|00005250| 83 82 83 82 83 82 82 82 | 83 82 82 83 82 82 83 82 |........|........|
|00005260| ff 00 4c 45 53 53 20 54 | 48 41 4e 00 3c 00 4c 45 |..LESS T|HAN.<.LE|
|00005270| 53 53 20 54 48 41 4e 20 | 4f 52 20 45 51 55 41 4c |SS THAN |OR EQUAL|
|00005280| 20 54 4f 00 3c 3d 00 20 | 00 47 52 45 41 54 45 52 | TO.<=. |.GREATER|
|00005290| 20 54 48 41 4e 00 3e 00 | 47 52 45 41 54 45 52 20 | THAN.>.|GREATER |
|000052a0| 54 48 41 4e 20 4f 52 20 | 45 51 55 41 4c 20 54 4f |THAN OR |EQUAL TO|
|000052b0| 00 3e 3d 00 20 00 4e 4f | 54 20 45 51 55 41 4c 20 |.>=. .NO|T EQUAL |
|000052c0| 54 4f 00 3c 3e 00 20 00 | 46 6f 72 20 73 65 76 65 |TO.<>. .|For seve|
|000052d0| 72 61 6c 20 63 6f 6e 64 | 69 74 69 6f 6e 73 00 41 |ral cond|itions.A|
|000052e0| 4e 44 2c 20 4f 52 00 46 | 6f 72 20 6e 65 67 61 74 |ND, OR.F|or negat|
|000052f0| 69 76 65 20 63 6f 6e 64 | 69 74 69 6f 6e 73 00 4e |ive cond|itions.N|
|00005300| 4f 54 00 20 00 46 6f 72 | 20 76 61 6c 75 65 73 20 |OT. .For| values |
|00005310| 69 6e 20 61 20 72 61 6e | 67 65 00 42 45 54 57 45 |in a ran|ge.BETWE|
|00005320| 45 4e 20 78 20 41 4e 44 | 20 79 00 46 6f 72 20 76 |EN x AND| y.For v|
|00005330| 61 6c 75 65 73 20 69 6e | 20 61 20 73 65 74 00 49 |alues in| a set.I|
|00005340| 4e 20 28 78 2c 79 2c 7a | 29 00 20 00 46 6f 72 20 |N (x,y,z|). .For |
|00005350| 63 6f 6d 70 61 72 69 6e | 67 20 70 61 72 74 69 61 |comparin|g partia|
|00005360| 6c 20 76 61 6c 75 65 73 | 00 4c 49 4b 45 20 27 25 |l values|.LIKE '%|
|00005370| 61 62 63 25 27 2c 00 00 | 4c 49 4b 45 20 27 2a 61 |abc%',..|LIKE '*a|
|00005380| 62 63 2a 27 00 00 4c 49 | 4b 45 20 27 5f 61 5f 27 |bc*'..LI|KE '_a_'|
|00005390| 2c 00 00 4c 49 4b 45 20 | 27 3f 61 3f 27 00 00 4c |,..LIKE |'?a?'..L|
|000053a0| 49 4b 45 20 27 2a 40 3f | 27 20 45 53 43 41 50 45 |IKE '*@?|' ESCAPE|
|000053b0| 20 27 40 27 00 20 00 46 | 6f 72 20 63 6f 6d 70 61 | '@'. .F|or compa|
|000053c0| 72 69 6e 67 20 73 69 6d | 69 6c 61 72 6c 79 00 73 |ring sim|ilarly.s|
|000053d0| 6f 75 6e 64 69 6e 67 20 | 76 61 6c 75 65 73 00 53 |ounding |values.S|
|000053e0| 4f 55 4e 44 53 00 20 00 | 51 75 65 72 79 20 66 6f |OUNDS. .|Query fo|
|000053f0| 72 20 74 68 65 20 4e 55 | 4c 4c 20 76 61 6c 75 65 |r the NU|LL value|
|00005400| 00 49 53 20 4e 55 4c 4c | 00 20 00 51 75 65 72 79 |.IS NULL|. .Query|
|00005410| 20 66 6f 72 20 61 20 42 | 6f 6f 6c 65 61 6e 20 76 | for a B|oolean v|
|00005420| 61 6c 75 65 00 49 53 20 | 54 52 55 45 00 00 37 00 |alue.IS |TRUE..7.|
|00005430| 00 00 0c 00 00 00 0c 0a | 01 00 65 0c 01 00 2b 00 |........|..e...+.|
|00005440| 00 00 20 26 80 18 00 80 | 00 00 50 02 fd 83 e9 7c |.. &....|..P....||
|00005450| 82 fd 03 80 0c 00 83 82 | ff 00 00 49 53 20 46 41 |........|...IS FA|
|00005460| 4c 53 45 00 00 34 01 00 | 00 dd 00 00 00 2e 0c 01 |LSE..4..|........|
|00005470| 00 99 0d 01 00 57 00 00 | 00 20 7c 80 bf 01 00 80 |.....W..|. |.....|
|00005480| 00 00 10 00 e3 80 80 0c | 00 82 82 82 80 0d 00 82 |........|........|
|00005490| 82 82 83 86 22 08 80 02 | 00 00 12 00 82 80 0c 00 |...."...|........|
|000054a0| 82 82 82 82 82 80 0d 00 | 82 82 82 82 83 86 22 08 |........|......".|
|000054b0| 80 02 00 00 13 00 82 80 | 0c 00 82 ff 00 20 00 53 |........|..... .S|
|000054c0| 65 6c 65 63 74 69 6f 6e | 20 77 69 74 68 6f 75 74 |election| without|
|000054d0| 20 63 6f 6e 64 69 74 69 | 6f 6e 3a 20 00 20 00 00 | conditi|on: . ..|
|000054e0| 53 45 4c 45 43 54 20 63 | 69 74 79 2c 20 6e 61 6d |SELECT c|ity, nam|
|000054f0| 65 2c 20 66 69 72 73 74 | 6e 61 6d 65 00 20 20 20 |e, first|name.   |
|00005500| 20 20 20 20 46 52 4f 4d | 20 63 75 73 74 6f 6d 65 |    FROM| custome|
|00005510| 72 00 20 00 00 00 00 00 | 20 00 20 00 20 00 53 65 |r. .....| . . .Se|
|00005520| 6c 65 63 74 69 6f 6e 20 | 77 69 74 68 20 63 6f 6e |lection |with con|
|00005530| 64 69 74 69 6f 6e 3a 20 | 00 20 00 00 53 45 4c 45 |dition: |. ..SELE|
|00005540| 43 54 20 63 69 74 79 2c | 20 6e 61 6d 65 2c 20 66 |CT city,| name, f|
|00005550| 69 72 73 74 6e 61 6d 65 | 00 20 20 20 20 20 20 20 |irstname|.       |
|00005560| 46 52 4f 4d 20 63 75 73 | 74 6f 6d 65 72 00 20 20 |FROM cus|tomer.  |
|00005570| 20 20 20 20 20 57 48 45 | 52 45 20 63 69 74 79 20 |     WHE|RE city |
|00005580| 3d 20 27 4c 6f 73 20 41 | 6e 67 65 6c 65 73 27 00 |= 'Los A|ngeles'.|
|00005590| 20 00 00 00 00 00 20 00 | 00 46 00 00 00 15 00 00 | ..... .|.F......|
|000055a0| 00 65 0c 01 00 df 0d 01 | 00 31 00 00 00 02 42 05 |.e......|.1....B.|
|000055b0| 00 00 fd 05 02 00 5d 80 | 02 00 0e 00 00 00 df 0d |......].|........|
|000055c0| 01 00 1a 0e 01 00 1b 42 | 01 00 43 6f 6d 70 61 72 |.......B|..Compar|
|000055d0| 69 73 6f 6e a0 4f 70 65 | 72 61 74 69 6f 6e 73 3b |ison.Ope|rations;|
|000055e0| 00 00 00 18 00 00 00 99 | 0d 01 00 1a 0e 01 00 23 |........|.......#|
|000055f0| 00 00 00 20 16 80 30 00 | 80 00 00 00 00 80 03 00 |... ..0.|........|
|00005600| 82 ff 00 43 6f 6d 70 61 | 72 69 73 6f 6e a0 4f 70 |...Compa|rison.Op|
|00005610| 65 72 61 74 69 6f 6e 73 | 00 00 70 00 00 00 49 00 |erations|..p...I.|
|00005620| 00 00 df 0d 01 00 8a 0e | 01 00 27 00 00 00 20 1e |........|..'... .|
|00005630| 80 92 00 80 00 00 10 00 | e3 80 80 0c 00 82 82 82 |........|........|
|00005640| ff 00 20 00 43 6f 6d 70 | 61 72 69 73 6f 6e 20 63 |.. .Comp|arison c|
|00005650| 6f 6e 64 69 74 69 6f 6e | 73 20 61 72 65 20 66 6f |ondition|s are fo|
|00005660| 72 6d 75 6c 61 74 65 64 | 20 75 73 69 6e 67 20 74 |rmulated| using t|
|00005670| 68 65 20 66 6f 6c 6c 6f | 77 69 6e 67 20 73 79 6d |he follo|wing sym|
|00005680| 62 6f 6c 73 3a 20 00 20 | 00 00 b0 00 00 00 73 00 |bols: . |......s.|
|00005690| 00 00 1a 0e 01 00 3a 0f | 01 00 3d 00 00 00 20 4a |......:.|..=... J|
|000056a0| 80 e6 00 80 00 00 50 02 | 39 82 af 7e 84 01 01 39 |......P.|9..~...9|
|000056b0| 02 80 0c 00 83 83 82 83 | 83 82 83 83 82 83 83 82 |........|........|
|000056c0| 83 83 82 83 83 82 ff 00 | 00 3d 00 65 71 75 61 6c |........|.=.equal|
|000056d0| 20 74 6f 00 00 3c 3e 00 | 6e 6f 74 20 65 71 75 61 | to..<>.|not equa|
|000056e0| 6c 20 74 6f 00 00 3e 00 | 67 72 65 61 74 65 72 20 |l to..>.|greater |
|000056f0| 74 68 61 6e 00 00 3e 3d | 00 67 72 65 61 74 65 72 |than..>=|.greater|
|00005700| 20 74 68 61 6e 20 6f 72 | 20 65 71 75 61 6c 20 74 | than or| equal t|
|00005710| 6f 00 00 3c 00 6c 65 73 | 73 20 74 68 61 6e 00 00 |o..<.les|s than..|
|00005720| 3c 3d 00 6c 65 73 73 20 | 74 68 61 6e 20 6f 72 20 |<=.less |than or |
|00005730| 65 71 75 61 6c 20 74 6f | 00 00 3e 02 00 00 cb 01 |equal to|..>.....|
|00005740| 00 00 8a 0e 01 00 84 41 | 01 00 73 00 00 00 20 b4 |.......A|..s... .|
|00005750| 80 9d 03 00 80 00 00 10 | 00 e3 80 80 0c 00 82 82 |........|........|
|00005760| 82 82 80 0d 00 82 82 82 | 82 83 86 22 08 80 02 00 |........|..."....|
|00005770| 00 14 00 82 80 0c 00 82 | 82 82 82 80 0d 00 82 82 |........|........|
|00005780| 82 82 83 86 22 08 80 02 | 00 00 15 00 82 80 0c 00 |...."...|........|
|00005790| 82 82 82 82 80 0d 00 82 | 82 82 82 83 86 22 08 80 |........|....."..|
|000057a0| 02 00 00 16 00 82 80 0c | 00 82 82 82 ff 00 20 00 |........|...... .|
|000057b0| 20 00 57 68 69 63 68 20 | 63 75 73 74 6f 6d 65 72 | .Which |customer|
|000057c0| 20 68 61 73 20 61 6e 20 | 65 6d 70 74 79 20 6f 72 | has an |empty or|
|000057d0| 20 61 20 70 6f 73 69 74 | 69 76 65 20 61 63 63 6f | a posit|ive acco|
|000057e0| 75 6e 74 3f 20 00 20 00 | 00 53 45 4c 45 43 54 20 |unt? . .|.SELECT |
|000057f0| 74 69 74 6c 65 2c 20 6e | 61 6d 65 2c 20 61 63 63 |title, n|ame, acc|
|00005800| 3a 0f 01 00 84 41 01 00 | 99 0d 01 00 6f 75 6e 74 |:....A..|....ount|
|00005810| 00 20 20 20 20 20 20 20 | 46 52 4f 4d 20 63 75 73 |.       |FROM cus|
|00005820| 74 6f 6d 65 72 00 20 20 | 20 20 20 20 20 57 48 45 |tomer.  |     WHE|
|00005830| 52 45 20 61 63 63 6f 75 | 6e 74 20 3e 3d 20 30 00 |RE accou|nt >= 0.|
|00005840| 20 00 00 00 00 00 20 00 | 20 00 57 68 69 63 68 20 | ..... .| .Which |
|00005850| 63 75 73 74 6f 6d 65 72 | 20 68 61 73 20 61 20 70 |customer| has a p|
|00005860| 6f 73 69 74 69 76 65 20 | 61 63 63 6f 75 6e 74 3f |ositive |account?|
|00005870| 20 00 20 00 00 53 45 4c | 45 43 54 20 74 69 74 6c | . ..SEL|ECT titl|
|00005880| 65 2c 20 6e 61 6d 65 2c | 20 61 63 63 6f 75 6e 74 |e, name,| account|
|00005890| 00 20 20 20 20 20 20 20 | 46 52 4f 4d 20 63 75 73 |.       |FROM cus|
|000058a0| 74 6f 6d 65 72 00 20 20 | 20 20 20 20 20 57 48 45 |tomer.  |     WHE|
|000058b0| 52 45 20 61 63 63 6f 75 | 6e 74 20 3e 20 30 00 20 |RE accou|nt > 0. |
|000058c0| 00 00 00 00 00 20 00 20 | 00 57 68 69 63 68 20 63 |..... . |.Which c|
|000058d0| 75 73 74 6f 6d 65 72 73 | 20 61 72 65 20 63 6f 6d |ustomers| are com|
|000058e0| 70 61 6e 69 65 73 3f 20 | 00 20 00 00 53 45 4c 45 |panies? |. ..SELE|
|000058f0| 43 54 20 74 69 74 6c 65 | 2c 20 6e 61 6d 65 00 20 |CT title|, name. |
|00005900| 20 20 20 20 20 20 46 52 | 4f 4d 20 63 75 73 74 6f |      FR|OM custo|
|00005910| 6d 65 72 00 20 20 20 20 | 20 20 20 57 48 45 52 45 |mer.    |   WHERE|
|00005920| 20 74 69 74 6c 65 20 3d | 20 27 43 6f 6d 70 27 00 | title =| 'Comp'.|
|00005930| 20 00 00 00 00 00 20 00 | 20 00 53 65 6c 65 63 74 | ..... .| .Select|
|00005940| 69 6f 6e 20 6f 66 20 61 | 6c 6c 20 63 75 73 74 6f |ion of a|ll custo|
|00005950| 6d 65 72 73 20 77 68 6f | 2c 20 69 6e 20 61 6c 70 |mers who|, in alp|
|00005960| 68 61 62 65 74 69 63 61 | 6c 20 6f 72 64 65 72 2c |habetica|l order,|
|00005970| 20 66 6f 6c 6c 6f 77 20 | 27 50 65 74 65 72 73 27 | follow |'Peters'|
|00005980| 3a 20 00 00 97 00 00 00 | 5c 00 00 00 3a 0f 01 00 |: ......|\...:...|
|00005990| 1b 42 01 00 3b 00 00 00 | 20 46 80 ba 00 80 00 00 |.B..;...| F......|
|000059a0| 10 00 e3 80 80 0c 00 82 | 80 0d 00 82 82 82 82 83 |........|........|
|000059b0| 86 22 08 80 02 00 00 17 | 00 82 80 0c 00 82 ff 00 |."......|........|
|000059c0| 20 00 00 53 45 4c 45 43 | 54 20 66 69 72 73 74 6e | ..SELEC|T firstn|
|000059d0| 61 6d 65 2c 20 6e 61 6d | 65 2c 20 63 69 74 79 00 |ame, nam|e, city.|
|000059e0| 20 20 20 20 20 20 20 46 | 52 4f 4d 20 63 75 73 74 |       F|ROM cust|
|000059f0| 6f 6d 65 72 00 20 20 20 | 20 20 20 20 57 48 45 52 |omer.   |    WHER|
|00005a00| 45 20 6e 61 6d 65 20 3e | 20 27 50 65 74 65 72 73 |E name >| 'Peters|
|00005a10| 27 00 20 00 00 00 00 00 | 20 00 00 4d 00 00 00 1c |'. .....| ..M....|
|00005a20| 00 00 00 84 41 01 00 68 | 42 01 00 31 00 00 00 02 |....A..h|B..1....|
|00005a30| 2d 03 00 00 4e 09 02 00 | a8 82 02 00 0f 00 00 00 |-...N...|........|
|00005a40| 68 42 01 00 aa 42 01 00 | a6 45 01 00 4d 75 6c 74 |hB...B..|.E..Mult|
|00005a50| 69 70 6c 65 a0 43 6f 6e | 64 69 74 69 6f 6e 73 3a |iple.Con|ditions:|
|00005a60| a0 41 4e 44 2c a0 4f 52 | 42 00 00 00 1f 00 00 00 |.AND,.OR|B.......|
|00005a70| 1b 42 01 00 aa 42 01 00 | 23 00 00 00 20 16 80 3e |.B...B..|#... ..>|
|00005a80| 00 80 00 00 00 00 80 03 | 00 82 ff 00 4d 75 6c 74 |........|....Mult|
|00005a90| 69 70 6c 65 a0 43 6f 6e | 64 69 74 69 6f 6e 73 3a |iple.Con|ditions:|
|00005aa0| a0 41 4e 44 2c a0 4f 52 | 00 00 0f 02 00 00 c5 01 |.AND,.OR|........|
|00005ab0| 00 00 68 42 01 00 b9 44 | 01 00 4a 00 00 00 20 62 |..hB...D|..J... b|
|00005ac0| 80 8d 03 00 80 00 00 10 | 00 e3 80 80 0c 00 82 82 |........|........|
|00005ad0| 82 82 82 82 80 0d 00 82 | 82 82 82 83 86 22 08 80 |........|....."..|
|00005ae0| 02 00 00 18 00 82 80 0c | 00 82 82 82 82 82 80 0d |........|........|
|00005af0| 00 82 82 ff 00 20 00 49 | 74 20 69 73 20 70 6f 73 |..... .I|t is pos|
|00005b00| 73 69 62 6c 65 20 74 6f | 20 72 65 74 72 69 65 76 |sible to| retriev|
|00005b10| 65 20 72 6f 77 73 20 77 | 68 69 63 68 20 73 61 74 |e rows w|hich sat|
|00005b20| 69 73 66 79 20 73 65 76 | 65 72 61 6c 20 63 6f 6e |isfy sev|eral con|
|00005b30| 64 69 74 69 6f 6e 73 20 | 63 6f 6d 62 69 6e 65 64 |ditions |combined|
|00005b40| 20 62 79 20 41 4e 44 20 | 6f 72 20 4f 52 2e 20 00 | by AND |or OR. .|
|00005b50| 20 00 20 00 54 68 65 20 | 66 69 72 73 74 20 65 78 | . .The |first ex|
|00005b60| 61 6d 70 6c 65 20 73 68 | 6f 77 73 20 63 75 73 74 |ample sh|ows cust|
|00005b70| 6f 6d 65 72 73 20 77 68 | 6f 20 6c 69 76 65 20 69 |omers wh|o live i|
|00005b80| 6e 20 4e 65 77 20 59 6f | 72 6b 20 6f 72 20 68 61 |n New Yo|rk or ha|
|00005b90| 76 65 20 61 20 70 6f 73 | 69 74 69 76 65 20 61 63 |ve a pos|itive ac|
|00005ba0| 63 6f 75 6e 74 2e 20 00 | 20 00 00 53 45 4c 45 43 |count. .| ..SELEC|
|00005bb0| 54 20 66 69 72 73 74 6e | 61 6d 65 2c 20 6e 61 6d |T firstn|ame, nam|
|00005bc0| 65 2c 20 63 69 74 79 2c | 20 61 63 63 6f 75 6e 74 |e, city,| account|
|00005bd0| 00 20 20 20 20 20 20 20 | 46 52 4f 4d 20 63 75 73 |.       |FROM cus|
|00005be0| 74 6f 6d 65 72 00 20 20 | 20 20 20 20 20 57 48 45 |tomer.  |     WHE|
|00005bf0| 52 45 20 63 69 74 79 20 | 3d 20 27 4e 65 77 20 59 |RE city |= 'New Y|
|00005c00| 6f 72 6b 27 20 4f 52 20 | 61 63 63 6f 75 6e 74 20 |ork' OR |account |
|00005c10| 3e 20 30 00 20 00 00 00 | 00 00 20 00 20 00 20 00 |> 0. ...|.. . . .|
|00005c20| 54 68 65 20 73 65 63 6f | 6e 64 20 65 78 61 6d 70 |The seco|nd examp|
|00005c30| 6c 65 20 6f 6e 6c 79 20 | 73 68 6f 77 73 20 74 68 |le only |shows th|
|00005c40| 6f 73 65 20 63 75 73 74 | 6f 6d 65 72 73 20 66 72 |ose cust|omers fr|
|00005c50| 6f 6d 20 4e 65 77 20 59 | 6f 72 6b 20 77 68 6f 20 |om New Y|ork who |
|00005c60| 68 61 76 65 20 61 20 70 | 6f 73 69 74 69 76 65 20 |have a p|ositive |
|00005c70| 61 63 63 6f 75 6e 74 2e | 20 00 20 00 00 53 45 4c |account.| . ..SEL|
|00005c80| 45 43 54 20 66 69 72 73 | 74 6e 61 6d 65 2c 20 6e |ECT firs|tname, n|
|00005c90| 61 6d 65 2c 20 63 69 74 | 79 2c 20 61 63 63 6f 75 |ame, cit|y, accou|
|00005ca0| 6e 74 00 20 20 20 20 20 | 20 20 46 52 4f 4d 20 63 |nt.     |  FROM c|
|00005cb0| 75 73 74 6f 6d 65 72 00 | 00 6e 00 00 00 39 00 00 |ustomer.|.n...9..|
|00005cc0| 00 aa 42 01 00 27 45 01 | 00 35 00 00 00 20 3a 80 |..B..'E.|.5... :.|
|00005cd0| 74 00 80 00 00 10 00 e3 | 80 80 0d 00 82 82 83 86 |t.......|........|
|00005ce0| 22 08 80 02 00 00 19 00 | 82 80 0c 00 82 ff 00 20 |".......|....... |
|00005cf0| 20 20 20 20 20 20 57 48 | 45 52 45 20 63 69 74 79 |      WH|ERE city|
|00005d00| 20 3d 20 27 4e 65 77 20 | 59 6f 72 6b 27 20 41 4e | = 'New |York' AN|
|00005d10| 44 20 61 63 63 6f 75 6e | 74 20 3e 20 30 00 20 00 |D accoun|t > 0. .|
|00005d20| 00 00 00 00 20 00 00 30 | 00 00 00 0b 00 00 00 b9 |.... ..0|........|
|00005d30| 44 01 00 57 45 01 00 25 | 00 00 00 20 1a 80 16 00 |D..WE..%|... ....|
|00005d40| 80 00 00 06 00 a4 98 80 | 05 00 82 ff 00 53 65 65 |........|.....See|
|00005d50| 20 61 6c 73 6f 00 00 4f | 00 00 00 21 00 00 00 27 | also..O|...!...'|
|00005d60| 45 01 00 a6 45 01 00 2e | 00 00 00 20 2c 80 42 00 |E...E...|... ,.B.|
|00005d70| 80 00 00 0c 00 8c b8 e3 | fb e4 68 86 80 04 00 89 |........|..h.....|
|00005d80| 80 0f 00 82 ff 00 00 50 | 61 72 65 6e 74 68 65 73 |.......P|arenthes|
|00005d90| 65 73 a0 77 69 74 68 a0 | 41 4e 44 a0 61 6e 64 a0 |es.with.|AND.and.|
|00005da0| 4f 52 00 00 00 00 4c 00 | 00 00 1b 00 00 00 57 45 |OR....L.|......WE|
|00005db0| 01 00 f2 45 01 00 31 00 | 00 00 02 9f 04 00 00 5d |...E..1.|.......]|
|00005dc0| 80 02 00 c0 86 02 00 10 | 00 00 00 f2 45 01 00 33 |........|....E..3|
|00005dd0| 46 01 00 a1 4a 01 00 50 | 61 72 65 6e 74 68 65 73 |F...J..P|arenthes|
|00005de0| 65 73 a0 77 69 74 68 a0 | 41 4e 44 a0 61 6e 64 a0 |es.with.|AND.and.|
|00005df0| 4f 52 41 00 00 00 1e 00 | 00 00 a6 45 01 00 33 46 |ORA.....|...E..3F|
|00005e00| 01 00 23 00 00 00 20 16 | 80 3c 00 80 00 00 00 00 |..#... .|.<......|
|00005e10| 80 03 00 82 ff 00 50 61 | 72 65 6e 74 68 65 73 65 |......Pa|renthese|
|00005e20| 73 a0 77 69 74 68 a0 41 | 4e 44 a0 61 6e 64 a0 4f |s.with.A|ND.and.O|
|00005e30| 52 00 00 81 02 00 00 42 | 02 00 00 f2 45 01 00 b4 |R......B|....E...|
|00005e40| 48 01 00 3f 00 00 00 20 | 4c 80 85 04 00 80 00 00 |H..?... |L.......|
|00005e50| 10 00 e3 80 80 0c 00 82 | 82 82 82 82 82 80 0d 00 |........|........|
|00005e60| 82 80 0c 00 82 82 82 82 | 80 0d 00 82 80 0c 00 82 |........|........|
|00005e70| 82 ff 00 20 00 57 68 65 | 6e 65 76 65 72 20 41 4e |... .Whe|never AN|
|00005e80| 44 20 61 6e 64 20 4f 52 | 20 61 72 65 20 75 73 65 |D and OR| are use|
|00005e90| 64 20 74 6f 67 65 74 68 | 65 72 2c 20 69 74 20 69 |d togeth|er, it i|
|00005ea0| 73 20 72 65 63 6f 6d 6d | 65 6e 64 65 64 20 74 6f |s recomm|ended to|
|00005eb0| 20 75 73 65 20 70 61 72 | 65 6e 74 68 65 73 65 73 | use par|entheses|
|00005ec0| 20 69 6e 20 6f 72 64 65 | 72 20 74 6f 20 63 6c 61 | in orde|r to cla|
|00005ed0| 72 69 66 79 20 74 68 65 | 20 69 6e 73 74 72 75 63 |rify the| instruc|
|00005ee0| 74 69 6f 6e 2e 20 00 20 | 00 20 00 45 78 61 6d 70 |tion. . |. .Examp|
|00005ef0| 6c 65 20 6f 66 20 61 20 | 57 48 45 52 45 20 63 6f |le of a |WHERE co|
|00005f00| 6e 64 69 74 69 6f 6e 3a | 20 00 20 00 00 20 20 20 |ndition:| . ..   |
|00005f10| 20 20 74 69 74 6c 65 20 | 3d 20 27 43 6f 6d 70 27 |  title |= 'Comp'|
|00005f20| 20 41 4e 44 20 73 74 61 | 74 65 20 3d 20 27 54 58 | AND sta|te = 'TX|
|00005f30| 27 20 4f 52 20 61 63 63 | 6f 75 6e 74 20 3e 20 30 |' OR acc|ount > 0|
|00005f40| 2e 30 00 00 20 00 20 00 | 49 66 20 74 68 65 20 70 |.0.. . .|If the p|
|00005f50| 61 72 65 6e 74 68 65 73 | 65 73 20 61 72 65 20 61 |arenthes|es are a|
|00005f60| 70 70 6c 69 65 64 20 69 | 6e 20 74 68 69 73 20 77 |pplied i|n this w|
|00005f70| 61 79 3a 20 00 20 00 00 | 20 20 20 20 20 28 74 69 |ay: . ..|     (ti|
|00005f80| 74 6c 65 20 3d 20 27 43 | 6f 6d 70 27 20 41 4e 44 |tle = 'C|omp' AND|
|00005f90| 20 73 74 61 74 65 20 3d | 20 27 54 58 27 29 20 4f | state =| 'TX') O|
|00005fa0| 52 20 28 61 63 63 6f 75 | 6e 74 20 3e 20 30 2e 30 |R (accou|nt > 0.0|
|00005fb0| 29 00 00 20 00 74 68 65 | 20 72 65 73 75 6c 74 20 |).. .the| result |
|00005fc0| 63 6f 6e 73 69 73 74 73 | 20 6f 66 20 61 6c 6c 20 |consists| of all |
|00005fd0| 63 75 73 74 6f 6d 65 72 | 73 20 77 68 6f 20 61 72 |customer|s who ar|
|00005fe0| 65 20 54 65 78 61 6e 20 | 63 6f 6d 70 61 6e 69 65 |e Texan |companie|
|00005ff0| 73 2c 20 69 72 72 65 73 | 70 65 63 74 69 76 65 20 |s, irres|pective |
|00006000| 6f 66 20 74 68 65 69 72 | 20 61 63 63 6f 75 6e 74 |of their| account|
|00006010| 73 2c 20 70 6c 75 73 20 | 61 6c 6c 20 63 75 73 74 |s, plus |all cust|
|00006020| 6f 6d 65 72 73 20 77 68 | 6f 20 68 61 76 65 20 70 |omers wh|o have p|
|00006030| 6f 73 69 74 69 76 65 20 | 61 63 63 6f 75 6e 74 73 |ositive |accounts|
|00006040| 2e 20 54 68 65 20 72 65 | 73 75 6c 74 20 6f 66 20 |. The re|sult of |
|00006050| 74 68 69 73 20 71 75 65 | 72 79 20 69 73 20 69 64 |this que|ry is id|
|00006060| 65 6e 74 69 63 61 6c 20 | 74 6f 20 74 68 61 74 20 |entical |to that |
|00006070| 77 69 74 68 6f 75 74 20 | 70 61 72 65 6e 74 68 65 |without |parenthe|
|00006080| 73 65 73 2c 20 62 65 63 | 61 75 73 65 20 41 4e 44 |ses, bec|ause AND|
|00006090| 20 68 61 73 20 61 20 68 | 69 67 68 65 72 20 70 72 | has a h|igher pr|
|000060a0| 65 63 65 64 65 6e 63 65 | 20 74 68 61 6e 20 4f 52 |ecedence| than OR|
|000060b0| 2e 20 00 00 ed 01 00 00 | b8 01 00 00 33 46 01 00 |. ......|....3F..|
|000060c0| a1 4a 01 00 35 00 00 00 | 20 38 80 71 03 00 80 00 |.J..5...| 8.q....|
|000060d0| 00 10 00 e3 80 80 0c 00 | 82 82 82 82 80 0d 00 82 |........|........|
|000060e0| 80 0c 00 82 82 82 82 82 | ff 00 20 00 20 00 49 66 |........|.. . .If|
|000060f0| 20 74 68 65 20 70 61 72 | 65 6e 74 68 65 73 65 73 | the par|entheses|
|00006100| 20 61 72 65 20 73 65 74 | 20 64 69 66 66 65 72 65 | are set| differe|
|00006110| 6e 74 6c 79 3a 20 00 20 | 00 00 20 20 20 20 20 28 |ntly: . |..     (|
|00006120| 74 69 74 6c 65 20 3d 20 | 27 43 6f 6d 70 27 29 20 |title = |'Comp') |
|00006130| 41 4e 44 20 28 73 74 61 | 74 65 20 3d 20 27 54 58 |AND (sta|te = 'TX|
|00006140| 27 20 4f 52 20 61 63 63 | 6f 75 6e 74 20 3e 20 30 |' OR acc|ount > 0|
|00006150| 2e 30 29 00 00 20 00 74 | 68 65 6e 20 6f 6e 6c 79 |.0).. .t|hen only|
|00006160| 20 27 63 6f 6d 70 61 6e | 79 27 20 63 75 73 74 6f | 'compan|y' custo|
|00006170| 6d 65 72 73 20 61 72 65 | 20 66 6f 75 6e 64 20 77 |mers are| found w|
|00006180| 68 6f 20 61 72 65 20 65 | 69 74 68 65 72 20 6c 6f |ho are e|ither lo|
|00006190| 63 61 74 65 64 20 69 6e | 20 54 65 78 61 73 20 6f |cated in| Texas o|
|000061a0| 72 20 77 68 6f 20 68 61 | 76 65 20 61 20 70 6f 73 |r who ha|ve a pos|
|000061b0| 69 74 69 76 65 20 61 63 | 63 6f 75 6e 74 2e 20 4f |itive ac|count. O|
|000061c0| 66 20 63 6f 75 72 73 65 | 2c 20 63 75 73 74 6f 6d |f course|, custom|
|000061d0| 65 72 73 20 77 68 6f 20 | 73 61 74 69 73 66 79 20 |ers who |satisfy |
|000061e0| 62 6f 74 68 20 63 6f 6e | 64 69 74 69 6f 6e 73 20 |both con|ditions |
|000061f0| 2d 20 74 68 69 73 20 69 | 73 2c 20 54 65 78 61 6e |- this i|s, Texan|
|00006200| 20 63 6f 6d 70 61 6e 69 | 65 73 20 77 69 74 68 20 | compani|es with |
|00006210| 61 20 70 6f 73 69 74 69 | 76 65 20 61 63 63 6f 75 |a positi|ve accou|
|00006220| 6e 74 20 2d 20 61 72 65 | 20 6f 75 74 70 75 74 20 |nt - are| output |
|00006230| 61 73 20 77 65 6c 6c 2e | 20 00 20 00 20 00 4e 65 |as well.| . . .Ne|
|00006240| 73 74 69 6e 67 20 6f 66 | 20 70 61 72 65 6e 74 68 |sting of| parenth|
|00006250| 65 73 65 73 20 69 73 20 | 70 6f 73 73 69 62 6c 65 |eses is |possible|
|00006260| 2e 20 54 68 65 20 63 6f | 6e 74 65 6e 74 20 6f 66 |. The co|ntent of|
|00006270| 20 74 68 65 20 69 6e 6e | 65 72 6d 6f 73 74 20 70 | the inn|ermost p|
|00006280| 61 72 65 6e 74 68 65 73 | 65 73 20 69 73 20 65 76 |arenthes|es is ev|
|00006290| 61 6c 75 61 74 65 64 20 | 66 69 72 73 74 2e 20 00 |aluated |first. .|
|000062a0| 00 52 00 00 00 21 00 00 | 00 b4 48 01 00 f3 4a 01 |.R...!..|..H...J.|
|000062b0| 00 31 00 00 00 02 39 04 | 00 00 a8 82 02 00 49 8a |.1....9.|......I.|
|000062c0| 02 00 11 00 00 00 f3 4a | 01 00 3a 4b 01 00 42 4f |.......J|..:K..BO|
|000062d0| 01 00 52 61 6e 67 65 73 | a0 6f 66 a0 56 61 6c 75 |..Ranges|.of.Valu|
|000062e0| 65 73 3a a0 42 45 54 57 | 45 45 4e a0 78 a0 41 4e |es:.BETW|EEN.x.AN|
|000062f0| 44 a0 79 47 00 00 00 24 | 00 00 00 a1 4a 01 00 3a |D.yG...$|....J..:|
|00006300| 4b 01 00 23 00 00 00 20 | 16 80 48 00 80 00 00 00 |K..#... |..H.....|
|00006310| 00 80 03 00 82 ff 00 52 | 61 6e 67 65 73 a0 6f 66 |.......R|anges.of|
|00006320| a0 56 61 6c 75 65 73 3a | a0 42 45 54 57 45 45 4e |.Values:|.BETWEEN|
|00006330| a0 78 a0 41 4e 44 a0 79 | 00 00 38 02 00 00 e9 01 |.x.AND.y|..8.....|
|00006340| 00 00 f3 4a 01 00 72 4d | 01 00 4f 00 00 00 20 6c |...J..rM|..O... l|
|00006350| 80 d5 03 00 80 00 00 10 | 00 e3 80 80 0c 00 82 82 |........|........|
|00006360| 82 82 80 0d 00 82 80 0c | 00 82 82 82 82 80 0d 00 |........|........|
|00006370| 82 82 82 82 82 82 82 83 | 86 22 08 80 02 00 00 1a |........|."......|
|00006380| 00 82 80 0c 00 82 82 82 | ff 00 20 00 41 6c 6c 20 |........|.. .All |
|00006390| 72 6f 77 73 20 63 61 6e | 20 62 65 20 73 65 61 72 |rows can| be sear|
|000063a0| 63 68 65 64 20 77 68 69 | 63 68 20 68 61 76 65 20 |ched whi|ch have |
|000063b0| 61 20 76 61 6c 75 65 20 | 77 69 74 68 69 6e 20 61 |a value |within a|
|000063c0| 20 73 70 65 63 69 66 69 | 65 64 20 72 61 6e 67 65 | specifi|ed range|
|000063d0| 2e 20 00 20 00 20 00 00 | 20 20 20 20 20 61 63 63 |. . . ..|     acc|
|000063e0| 6f 75 6e 74 20 42 45 54 | 57 45 45 4e 20 2d 34 32 |ount BET|WEEN -42|
|000063f0| 30 20 41 4e 44 20 30 00 | 00 20 00 6d 65 61 6e 73 |0 AND 0.|. .means|
+--------+-------------------------+-------------------------+--------+--------+