home *** CD-ROM | disk | FTP | other *** search
open in: 
MacOS 8.1
|
Win98
|
DOS
view JSON data
|
view as text
This file was processed as: DiskDupe Disk Image
(archive/diskDupeDiskImage).
You can browse this item here: 39.ddi
hex view+--------+-------------------------+-------------------------+--------+--------+
|00000000| 49 4d 00 00 00 00 00 00 | 00 00 02 00 00 00 00 00 |IM......|........|
|00000010| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000020| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000030| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000040| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000050| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000060| 00 00 00 00 01 01 00 00 | 00 01 01 02 00 00 00 01 |........|........|
|00000070| 01 03 00 00 00 01 01 04 | 00 00 00 01 01 05 00 00 |........|........|
|00000080| 00 01 01 06 00 00 00 01 | 01 07 00 00 00 01 01 08 |........|........|
|00000090| 00 00 00 01 01 09 00 00 | 00 01 01 0a 00 00 00 01 |........|........|
|000000a0| 01 0b 00 00 00 01 01 0c | 00 00 00 01 01 0d 00 00 |........|........|
|000000b0| 00 01 01 0e 00 00 00 01 | 01 0f 00 00 00 01 01 10 |........|........|
|000000c0| 00 00 00 01 01 11 00 00 | 00 01 01 12 00 00 00 01 |........|........|
|000000d0| 01 13 00 00 00 01 01 14 | 00 00 00 01 01 15 00 00 |........|........|
|000000e0| 00 01 01 16 00 00 00 01 | 01 17 00 00 00 01 01 18 |........|........|
|000000f0| 00 00 00 01 01 19 00 00 | 00 01 01 1a 00 00 00 01 |........|........|
|00000100| 01 1b 00 00 00 01 01 1c | 00 00 00 01 01 1d 00 00 |........|........|
|00000110| 00 01 01 1e 00 00 00 01 | 01 1f 00 00 00 01 01 20 |........|....... |
|00000120| 00 00 00 01 01 21 00 00 | 00 01 01 22 00 00 00 01 |.....!..|..."....|
|00000130| 01 23 00 00 00 01 01 24 | 00 00 00 01 01 25 00 00 |.#.....$|.....%..|
|00000140| 00 01 01 26 00 00 00 01 | 01 27 00 00 00 01 01 28 |...&....|.'.....(|
|00000150| 00 00 00 01 01 29 00 00 | 00 01 01 2a 00 00 00 01 |.....)..|...*....|
|00000160| 01 2b 00 00 00 01 01 2c | 00 00 00 01 01 2d 00 00 |.+.....,|.....-..|
|00000170| 00 01 01 2e 00 00 00 01 | 01 2f 00 00 00 01 01 30 |........|./.....0|
|00000180| 00 00 00 01 01 31 00 00 | 00 01 01 32 00 00 00 01 |.....1..|...2....|
|00000190| 01 33 00 00 00 01 01 34 | 00 00 00 01 01 35 00 00 |.3.....4|.....5..|
|000001a0| 00 01 01 36 00 00 00 01 | 01 37 00 00 00 01 01 38 |...6....|.7.....8|
|000001b0| 00 00 00 01 01 39 00 00 | 00 01 01 3a 00 00 00 01 |.....9..|...:....|
|000001c0| 01 3b 00 00 00 01 01 3c | 00 00 00 01 01 3d 00 00 |.;.....<|.....=..|
|000001d0| 00 01 01 3e 00 00 00 01 | 01 3f 00 00 00 01 01 40 |...>....|.?.....@|
|000001e0| 00 00 00 01 01 41 00 00 | 00 01 01 42 00 00 00 01 |.....A..|...B....|
|000001f0| 01 43 00 00 00 01 01 44 | 00 00 00 01 01 45 00 00 |.C.....D|.....E..|
|00000200| 00 01 01 46 00 00 00 01 | 01 47 00 00 00 01 01 48 |...F....|.G.....H|
|00000210| 00 00 00 01 01 49 00 00 | 00 01 01 4a 00 00 00 01 |.....I..|...J....|
|00000220| 01 4b 00 00 00 01 01 4c | 00 00 00 01 01 4d 00 00 |.K.....L|.....M..|
|00000230| 00 01 01 4e 00 00 00 01 | 01 4f 00 00 00 01 01 50 |...N....|.O.....P|
|00000240| 00 00 00 01 01 51 00 00 | 00 01 01 52 00 00 00 01 |.....Q..|...R....|
|00000250| 01 53 00 00 00 01 01 54 | 00 00 00 01 01 55 00 00 |.S.....T|.....U..|
|00000260| 00 01 01 56 00 00 00 01 | 01 57 00 00 00 01 01 58 |...V....|.W.....X|
|00000270| 00 00 00 01 01 59 00 00 | 00 01 01 5a 00 00 00 01 |.....Y..|...Z....|
|00000280| 01 5b 00 00 00 01 01 5c | 00 00 00 01 01 5d 00 00 |.[.....\|.....]..|
|00000290| 00 01 01 5e 00 00 00 01 | 01 5f 00 00 00 01 01 60 |...^....|._.....`|
|000002a0| 00 00 00 01 01 61 00 00 | 00 01 01 62 00 00 00 01 |.....a..|...b....|
|000002b0| 01 63 00 00 00 01 01 64 | 00 00 00 01 01 65 00 00 |.c.....d|.....e..|
|000002c0| 00 01 01 66 00 00 00 01 | 01 67 00 00 00 01 01 68 |...f....|.g.....h|
|000002d0| 00 00 00 01 01 69 00 00 | 00 01 01 6a 00 00 00 01 |.....i..|...j....|
|000002e0| 01 6b 00 00 00 01 01 6c | 00 00 00 01 01 6d 00 00 |.k.....l|.....m..|
|000002f0| 00 01 01 6e 00 00 00 01 | 01 6f 00 00 00 01 01 70 |...n....|.o.....p|
|00000300| 00 00 00 01 01 71 00 00 | 00 01 01 72 00 00 00 01 |.....q..|...r....|
|00000310| 01 73 00 00 00 01 01 74 | 00 00 00 01 01 75 00 00 |.s.....t|.....u..|
|00000320| 00 01 01 76 00 00 00 01 | 01 77 00 00 00 01 01 78 |...v....|.w.....x|
|00000330| 00 00 00 01 01 79 00 00 | 00 01 01 7a 00 00 00 01 |.....y..|...z....|
|00000340| 01 7b 00 00 00 01 01 7c | 00 00 00 01 01 7d 00 00 |.{.....||.....}..|
|00000350| 00 01 01 7e 00 00 00 01 | 01 7f 00 00 00 01 01 80 |...~....|........|
|00000360| 00 00 00 01 01 81 00 00 | 00 01 01 82 00 00 00 01 |........|........|
|00000370| 01 83 00 00 00 01 01 84 | 00 00 00 01 01 85 00 00 |........|........|
|00000380| 00 01 01 86 00 00 00 01 | 01 87 00 00 00 01 01 88 |........|........|
|00000390| 00 00 00 01 01 89 00 00 | 00 01 01 8a 00 00 00 01 |........|........|
|000003a0| 01 8b 00 00 00 01 01 8c | 00 00 00 01 01 8d 00 00 |........|........|
|000003b0| 00 01 01 8e 00 00 00 01 | 01 8f 00 00 00 01 01 90 |........|........|
|000003c0| 00 00 00 01 01 91 00 00 | 00 01 01 92 00 00 00 01 |........|........|
|000003d0| 01 93 00 00 00 01 01 94 | 00 00 00 01 01 95 00 00 |........|........|
|000003e0| 00 01 01 96 00 00 00 01 | 01 97 00 00 00 01 01 98 |........|........|
|000003f0| 00 00 00 01 01 99 00 00 | 00 01 01 9a 00 00 00 01 |........|........|
|00000400| 01 9b 00 00 00 01 01 9c | 00 00 00 01 01 9d 00 00 |........|........|
|00000410| 00 01 01 9e 00 00 00 01 | 01 9f 00 00 00 01 01 a0 |........|........|
|00000420| 00 00 00 01 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000430| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000440| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000450| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000460| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000470| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000480| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000490| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000004a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000004b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000004c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000004d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000004e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000004f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000500| 00 00 00 00 00 00 00 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 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000800| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000810| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000820| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000830| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000840| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000850| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000860| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000870| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000880| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000890| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000008a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000008b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000008c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000008d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000008e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000008f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000900| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000910| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000920| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000930| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000940| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000950| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000960| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000970| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000980| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000990| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000009a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000009b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000009c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000009d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000009e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000009f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000a00| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000a10| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000a20| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000a30| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000a40| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000a50| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000a60| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000a70| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000a80| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000a90| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000aa0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000ab0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000ac0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000ad0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000ae0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000af0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000b00| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000b10| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000b20| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000b30| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000b40| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000b50| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000b60| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000b70| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000b80| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000b90| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000ba0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000bb0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000bc0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000bd0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000be0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000bf0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000c00| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000c10| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000c20| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000c30| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000c40| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000c50| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000c60| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000c70| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000c80| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000c90| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000ca0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000cb0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000cc0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000cd0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000ce0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000cf0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000d00| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000d10| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000d20| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000d30| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000d40| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000d50| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000d60| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000d70| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000d80| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000d90| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000da0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000db0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000dc0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000dd0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000de0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000df0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000e00| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000e10| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000e20| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000e30| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000e40| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000e50| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000e60| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000e70| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000e80| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000e90| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000ea0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000eb0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000ec0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000ed0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000ee0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000ef0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000f00| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000f10| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000f20| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000f30| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000f40| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000f50| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000f60| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000f70| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000f80| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000f90| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000fa0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000fb0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000fc0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000fd0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000fe0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000ff0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001000| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001010| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001020| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001030| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001040| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001050| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001060| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001070| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001080| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001090| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000010a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000010b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000010c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000010d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000010e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000010f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001100| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001110| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001120| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001130| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001140| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001150| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001160| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001170| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001180| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001190| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000011a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000011b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000011c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000011d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000011e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000011f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001200| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001210| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001220| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001230| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001240| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001250| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001260| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001270| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001280| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001290| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000012a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000012b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000012c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000012d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000012e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000012f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001300| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001310| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001320| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001330| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001340| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001350| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001360| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001370| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001380| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001390| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000013a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000013b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000013c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000013d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000013e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000013f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001400| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001410| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001420| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001430| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001440| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001450| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001460| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001470| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001480| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001490| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000014a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000014b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000014c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000014d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000014e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000014f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001500| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001510| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001520| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001530| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001540| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001550| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001560| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001570| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001580| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001590| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000015a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000015b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000015c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000015d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000015e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000015f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001600| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001610| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001620| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001630| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001640| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001650| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001660| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001670| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001680| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001690| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000016a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000016b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000016c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000016d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000016e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000016f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001700| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001710| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001720| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001730| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001740| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001750| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001760| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001770| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001780| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001790| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000017a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000017b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000017c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000017d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000017e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000017f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001800| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001810| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001820| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001830| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001840| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001850| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001860| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001870| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001880| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001890| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000018a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000018b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000018c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000018d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000018e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000018f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001900| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001910| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001920| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001930| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001940| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001950| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001960| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001970| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001980| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001990| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000019a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000019b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000019c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000019d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000019e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000019f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001a00| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001a10| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001a20| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001a30| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001a40| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001a50| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001a60| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001a70| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001a80| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001a90| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001aa0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001ab0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001ac0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001ad0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001ae0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001af0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001b00| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001b10| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001b20| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001b30| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001b40| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001b50| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001b60| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001b70| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001b80| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001b90| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001ba0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001bb0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001bc0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001bd0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001be0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001bf0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001c00| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001c10| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001c20| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001c30| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001c40| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001c50| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001c60| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001c70| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001c80| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001c90| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001ca0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001cb0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001cc0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001cd0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001ce0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001cf0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001d00| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001d10| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001d20| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001d30| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001d40| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001d50| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001d60| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001d70| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001d80| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001d90| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001da0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001db0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001dc0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001dd0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001de0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001df0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001e00| 30 37 30 37 30 37 30 30 | 30 34 35 30 30 30 37 37 |07070700|04500077|
|00001e10| 34 32 30 34 30 37 37 37 | 30 30 30 33 31 31 30 30 |42040777|00031100|
|00001e20| 30 30 36 32 30 30 30 30 | 30 36 30 30 30 30 30 30 |00620000|06000000|
|00001e30| 30 34 37 36 34 35 37 34 | 30 35 32 30 30 30 30 30 |04764574|05200000|
|00001e40| 32 30 30 30 30 30 30 30 | 30 30 30 30 2e 00 30 37 |20000000|0000..07|
|00001e50| 30 37 30 37 30 30 30 34 | 35 30 30 30 37 37 34 33 |07070004|50007743|
|00001e60| 30 34 30 37 35 35 30 30 | 30 33 31 31 30 30 30 30 |04075500|03110000|
|00001e70| 36 32 30 30 30 30 30 32 | 30 30 30 30 30 30 30 34 |62000002|00000004|
|00001e80| 37 36 34 35 37 34 30 34 | 30 30 30 30 30 30 35 30 |76457404|00000050|
|00001e90| 30 30 30 30 30 30 30 30 | 30 30 64 65 6d 6f 00 30 |00000000|00demo.0|
|00001ea0| 37 30 37 30 37 30 30 30 | 34 35 30 30 30 37 37 34 |70707000|45000774|
|00001eb0| 34 31 30 30 36 34 34 30 | 30 30 33 31 31 30 30 30 |41006440|00311000|
|00001ec0| 30 36 32 30 30 30 30 30 | 31 30 30 30 30 30 30 30 |06200000|10000000|
|00001ed0| 34 37 36 34 35 37 34 30 | 34 30 30 30 30 30 31 36 |47645740|40000016|
|00001ee0| 30 30 30 30 30 30 30 31 | 33 33 34 64 65 6d 6f 2f |00000001|334demo/|
|00001ef0| 63 61 73 65 2e 73 71 6c | 00 72 65 6d 20 0a 72 65 |case.sql|.rem .re|
|00001f00| 6d 20 24 48 65 61 64 65 | 72 3a 20 63 61 73 65 2e |m $Heade|r: case.|
|00001f10| 73 71 6c 2c 76 20 36 2e | 31 20 38 38 2f 30 37 2f |sql,v 6.|1 88/07/|
|00001f20| 31 34 20 31 34 3a 30 32 | 3a 34 31 20 6d 68 6f 20 |14 14:02|:41 mho |
|00001f30| 45 78 70 20 24 20 63 61 | 73 65 2e 73 71 6c 20 0a |Exp $ ca|se.sql .|
|00001f40| 72 65 6d 20 0a 72 65 6d | 0a 72 65 6d 20 20 20 20 |rem .rem|.rem |
|00001f50| 53 51 4c 2a 4c 6f 61 64 | 65 72 20 44 65 6d 6f 20 |SQL*Load|er Demo |
|00001f60| 3a 0a 72 65 6d 20 20 20 | 20 20 20 20 42 75 69 6c |:.rem | Buil|
|00001f70| 64 20 45 4d 50 20 61 6e | 64 20 44 45 50 54 20 74 |d EMP an|d DEPT t|
|00001f80| 61 62 6c 65 73 20 66 6f | 72 20 43 61 73 65 20 31 |ables fo|r Case 1|
|00001f90| 20 2d 20 43 61 73 65 20 | 35 0a 72 65 6d 0a 0a 67 | - Case |5.rem..g|
|00001fa0| 72 61 6e 74 20 63 6f 6e | 6e 65 63 74 2c 72 65 73 |rant con|nect,res|
|00001fb0| 6f 75 72 63 65 20 74 6f | 20 73 63 6f 74 74 20 69 |ource to| scott i|
|00001fc0| 64 65 6e 74 69 66 69 65 | 64 20 62 79 20 74 69 67 |dentifie|d by tig|
|00001fd0| 65 72 3b 0a 63 6f 6e 6e | 65 63 74 20 73 63 6f 74 |er;.conn|ect scot|
|00001fe0| 74 2f 74 69 67 65 72 0a | 0a 23 44 4f 43 0a 20 20 |t/tiger.|.#DOC. |
|00001ff0| 20 20 20 20 44 72 6f 70 | 20 65 78 69 73 74 69 6e | Drop| existin|
|00002000| 67 20 45 4d 50 20 61 6e | 64 20 63 72 65 61 74 65 |g EMP an|d create|
|00002010| 20 61 20 6e 65 77 20 6f | 6e 65 20 74 6f 20 73 74 | a new o|ne to st|
|00002020| 61 72 74 20 66 72 6f 6d | 20 73 63 72 61 74 63 68 |art from| scratch|
|00002030| 2e 0a 23 0a 64 72 6f 70 | 20 74 61 62 6c 65 20 65 |..#.drop| table e|
|00002040| 6d 70 3b 0a 63 72 65 61 | 74 65 20 74 61 62 6c 65 |mp;.crea|te table|
|00002050| 20 65 6d 70 0a 20 20 20 | 28 65 6d 70 6e 6f 20 20 | emp. |(empno |
|00002060| 20 20 6e 75 6d 62 65 72 | 28 34 29 20 6e 6f 74 20 | number|(4) not |
|00002070| 6e 75 6c 6c 2c 0a 20 20 | 20 20 65 6e 61 6d 65 20 |null,. | ename |
|00002080| 20 20 20 63 68 61 72 28 | 31 30 29 2c 0a 20 20 20 | char(|10),. |
|00002090| 20 6a 6f 62 20 20 20 20 | 20 20 63 68 61 72 28 39 | job | char(9|
|000020a0| 29 2c 0a 20 20 20 20 6d | 67 72 20 20 20 20 20 20 |),. m|gr |
|000020b0| 6e 75 6d 62 65 72 28 34 | 29 2c 0a 20 20 20 20 68 |number(4|),. h|
|000020c0| 69 72 65 64 61 74 65 20 | 64 61 74 65 2c 0a 20 20 |iredate |date,. |
|000020d0| 20 20 73 61 6c 20 20 20 | 20 20 20 6e 75 6d 62 65 | sal | numbe|
|000020e0| 72 28 37 2c 32 29 2c 0a | 20 20 20 20 63 6f 6d 6d |r(7,2),.| comm|
|000020f0| 20 20 20 20 20 6e 75 6d | 62 65 72 28 37 2c 32 29 | num|ber(7,2)|
|00002100| 2c 0a 20 20 20 20 64 65 | 70 74 6e 6f 20 20 20 6e |,. de|ptno n|
|00002110| 75 6d 62 65 72 28 32 29 | 29 3b 20 0a 0a 23 44 4f |umber(2)|); ..#DO|
|00002120| 43 0a 20 20 20 20 20 20 | 44 72 6f 70 20 65 78 69 |C. |Drop exi|
|00002130| 73 74 69 6e 67 20 44 45 | 50 54 20 61 6e 64 20 63 |sting DE|PT and c|
|00002140| 72 65 61 74 65 20 61 20 | 6e 65 77 20 6f 6e 65 20 |reate a |new one |
|00002150| 74 6f 20 73 74 61 72 74 | 20 66 72 6f 6d 20 73 63 |to start| from sc|
|00002160| 72 61 74 63 68 2e 0a 23 | 0a 64 72 6f 70 20 74 61 |ratch..#|.drop ta|
|00002170| 62 6c 65 20 64 65 70 74 | 3b 0a 63 72 65 61 74 65 |ble dept|;.create|
|00002180| 20 74 61 62 6c 65 20 64 | 65 70 74 0a 20 20 20 28 | table d|ept. (|
|00002190| 64 65 70 74 6e 6f 20 20 | 20 6e 75 6d 62 65 72 28 |deptno | number(|
|000021a0| 32 29 2c 0a 20 20 20 20 | 64 6e 61 6d 65 20 20 20 |2),. |dname |
|000021b0| 20 63 68 61 72 28 31 34 | 29 2c 0a 20 20 20 20 6c | char(14|),. l|
|000021c0| 6f 63 20 20 20 20 20 20 | 63 68 61 72 28 31 33 29 |oc |char(13)|
|000021d0| 29 3b 0a 0a 0a 30 37 30 | 37 30 37 30 30 30 34 35 |);...070|70700045|
|000021e0| 30 30 30 37 37 34 35 31 | 30 30 36 34 34 30 30 30 |00077451|00644000|
|000021f0| 33 31 31 30 30 30 30 36 | 32 30 30 30 30 30 31 30 |31100006|20000010|
|00002200| 30 30 30 30 30 30 34 37 | 36 34 35 37 34 30 34 30 |00000047|64574040|
|00002210| 30 30 30 30 31 37 30 30 | 30 30 30 30 30 30 35 33 |00001700|00000053|
|00002220| 33 64 65 6d 6f 2f 63 61 | 73 65 31 2e 63 74 6c 00 |3demo/ca|se1.ctl.|
|00002230| 2d 2d 20 0a 2d 2d 20 24 | 48 65 61 64 65 72 3a 20 |-- .-- $|Header: |
|00002240| 63 61 73 65 31 2e 63 74 | 6c 2c 76 20 31 30 30 31 |case1.ct|l,v 1001|
|00002250| 30 2e 35 20 38 38 2f 30 | 31 2f 31 34 20 31 34 3a |0.5 88/0|1/14 14:|
|00002260| 34 30 3a 30 31 20 68 64 | 61 69 20 45 78 70 20 24 |40:01 hd|ai Exp $|
|00002270| 20 63 61 73 65 31 2e 63 | 74 6c 20 0a 2d 2d 20 0a | case1.c|tl .-- .|
|00002280| 4c 4f 41 44 20 44 41 54 | 41 0a 49 4e 46 49 4c 45 |LOAD DAT|A.INFILE|
|00002290| 20 2a 20 0a 49 4e 54 4f | 20 54 41 42 4c 45 20 44 | * .INTO| TABLE D|
|000022a0| 45 50 54 09 0a 46 49 45 | 4c 44 53 20 54 45 52 4d |EPT..FIE|LDS TERM|
|000022b0| 49 4e 41 54 45 44 20 42 | 59 20 27 2c 27 20 4f 50 |INATED B|Y ',' OP|
|000022c0| 54 49 4f 4e 41 4c 4c 59 | 20 45 4e 43 4c 4f 53 45 |TIONALLY| ENCLOSE|
|000022d0| 44 20 42 59 20 27 22 27 | 0a 28 44 45 50 54 4e 4f |D BY '"'|.(DEPTNO|
|000022e0| 2c 20 44 4e 41 4d 45 2c | 20 4c 4f 43 29 0a 42 45 |, DNAME,| LOC).BE|
|000022f0| 47 49 4e 44 41 54 41 0a | 31 32 2c 52 45 53 45 41 |GINDATA.|12,RESEA|
|00002300| 52 43 48 2c 22 53 41 52 | 41 54 4f 47 41 22 20 09 |RCH,"SAR|ATOGA" .|
|00002310| 0a 31 30 2c 22 41 43 43 | 4f 55 4e 54 49 4e 47 22 |.10,"ACC|OUNTING"|
|00002320| 2c 43 4c 45 56 45 4c 41 | 4e 44 0a 31 31 2c 22 41 |,CLEVELA|ND.11,"A|
|00002330| 52 54 22 2c 53 41 4c 45 | 4d 0a 31 33 2c 46 49 4e |RT",SALE|M.13,FIN|
|00002340| 41 4e 43 45 2c 22 42 4f | 53 54 4f 4e 22 0a 32 31 |ANCE,"BO|STON".21|
|00002350| 2c 22 53 41 4c 45 53 22 | 2c 50 48 49 4c 41 2e 0a |,"SALES"|,PHILA..|
|00002360| 32 32 2c 22 53 41 4c 45 | 53 22 2c 52 4f 43 48 45 |22,"SALE|S",ROCHE|
|00002370| 53 54 45 52 0a 34 32 2c | 22 49 4e 54 27 4c 22 2c |STER.42,|"INT'L",|
|00002380| 22 53 41 4e 20 46 52 41 | 4e 22 0a 30 37 30 37 30 |"SAN FRA|N".07070|
|00002390| 37 30 30 30 34 35 30 30 | 30 37 37 34 36 31 30 30 |70004500|07746100|
|000023a0| 36 34 34 30 30 30 33 31 | 31 30 30 30 30 36 32 30 |64400031|10000620|
|000023b0| 30 30 30 30 31 30 30 30 | 30 30 30 30 34 37 36 34 |00001000|00004764|
|000023c0| 35 37 34 30 34 30 30 30 | 30 30 31 37 30 30 30 30 |57404000|00170000|
|000023d0| 30 30 30 32 30 34 34 64 | 65 6d 6f 2f 63 61 73 65 |0002044d|emo/case|
|000023e0| 31 2e 64 61 74 00 37 37 | 38 32 20 43 4c 41 52 4b |1.dat.77|82 CLARK|
|000023f0| 20 20 20 20 20 20 4d 41 | 4e 41 47 45 52 20 20 20 | MA|NAGER |
|00002400| 37 38 33 39 20 20 32 35 | 37 32 2e 35 30 20 20 20 |7839 25|72.50 |
|00002410| 20 20 20 20 20 20 20 31 | 30 20 0a 37 38 33 39 20 | 1|0 .7839 |
|00002420| 4b 49 4e 47 20 20 20 20 | 20 20 20 50 52 45 53 49 |KING | PRESI|
|00002430| 44 45 4e 54 20 20 20 20 | 20 20 20 35 35 30 30 2e |DENT | 5500.|
|00002440| 30 30 20 20 20 20 20 20 | 20 20 20 20 31 30 20 0a |00 | 10 .|
|00002450| 37 39 33 34 20 4d 49 4c | 4c 45 52 20 20 20 20 20 |7934 MIL|LER |
|00002460| 43 4c 45 52 4b 20 20 20 | 20 20 37 37 38 32 20 20 |CLERK | 7782 |
|00002470| 20 39 32 30 2e 30 30 20 | 20 20 20 20 20 20 20 20 | 920.00 | |
|00002480| 20 31 30 20 0a 37 35 36 | 36 20 4a 4f 4e 45 53 20 | 10 .756|6 JONES |
|00002490| 20 20 20 20 20 4d 41 4e | 41 47 45 52 20 20 20 37 | MAN|AGER 7|
|000024a0| 38 33 39 20 20 33 31 32 | 33 2e 37 35 20 20 20 20 |839 312|3.75 |
|000024b0| 20 20 20 20 20 20 32 30 | 20 0a 37 34 39 39 20 41 | 20| .7499 A|
|000024c0| 4c 4c 45 4e 20 20 20 20 | 20 20 53 41 4c 45 53 4d |LLEN | SALESM|
|000024d0| 41 4e 20 20 37 36 39 38 | 20 20 31 36 30 30 2e 30 |AN 7698| 1600.0|
|000024e0| 30 20 20 20 33 30 30 2e | 30 30 20 33 30 20 0a 37 |0 300.|00 30 .7|
|000024f0| 36 35 34 20 4d 41 52 54 | 49 4e 20 20 20 20 20 53 |654 MART|IN S|
|00002500| 41 4c 45 53 4d 41 4e 20 | 20 37 36 39 38 20 20 31 |ALESMAN | 7698 1|
|00002510| 33 31 32 2e 35 30 20 20 | 31 34 30 30 2e 30 30 20 |312.50 |1400.00 |
|00002520| 33 30 20 0a 37 36 35 38 | 20 43 48 41 4e 20 20 20 |30 .7658| CHAN |
|00002530| 20 20 20 20 41 4e 41 4c | 59 53 54 20 20 20 37 35 | ANAL|YST 75|
|00002540| 36 36 20 20 33 34 35 30 | 2e 30 30 20 20 20 20 20 |66 3450|.00 |
|00002550| 20 20 20 20 20 32 30 20 | 0a 37 39 39 39 20 42 52 | 20 |.7999 BR|
|00002560| 4f 57 4e 20 20 20 20 20 | 20 43 4c 45 52 4b 20 20 |OWN | CLERK |
|00002570| 20 20 20 37 39 30 32 20 | 20 20 38 30 30 2e 30 30 | 7902 | 800.00|
|00002580| 20 20 20 20 20 20 20 20 | 20 20 31 30 20 0a 37 33 | | 10 .73|
|00002590| 36 39 20 53 4d 49 54 48 | 20 20 20 20 20 20 43 4c |69 SMITH| CL|
|000025a0| 45 52 4b 20 20 20 20 20 | 37 39 30 32 20 20 20 39 |ERK |7902 9|
|000025b0| 32 30 2e 30 30 20 20 20 | 20 20 20 20 20 20 20 31 |20.00 | 1|
|000025c0| 30 20 0a 37 37 38 38 20 | 53 43 4f 54 54 20 20 20 |0 .7788 |SCOTT |
|000025d0| 20 20 20 41 4e 41 4c 59 | 53 54 20 20 20 37 35 36 | ANALY|ST 756|
|000025e0| 36 20 20 33 37 39 35 2e | 30 30 20 20 20 20 20 20 |6 3795.|00 |
|000025f0| 20 20 20 20 32 30 20 0a | 37 38 37 36 20 41 44 41 | 20 .|7876 ADA|
|00002600| 4d 53 20 20 20 20 20 20 | 43 4c 45 52 4b 20 20 20 |MS |CLERK |
|00002610| 20 20 37 37 38 38 20 20 | 20 39 32 30 2e 30 30 20 | 7788 | 920.00 |
|00002620| 20 20 20 20 20 20 20 20 | 20 32 30 20 0a 37 39 30 | | 20 .790|
|00002630| 32 20 46 4f 52 44 20 20 | 20 20 20 20 20 41 4e 41 |2 FORD | ANA|
|00002640| 4c 59 53 54 20 20 20 37 | 35 36 36 20 20 33 34 35 |LYST 7|566 345|
|00002650| 30 2e 30 30 20 20 20 20 | 20 20 20 20 20 20 32 30 |0.00 | 20|
|00002660| 20 0a 37 36 35 37 20 4d | 41 53 4f 4e 20 20 20 20 | .7657 M|ASON |
|00002670| 20 20 41 4e 41 4c 59 53 | 54 20 20 20 37 35 36 36 | ANALYS|T 7566|
|00002680| 20 20 33 39 31 30 2e 30 | 30 20 20 20 20 20 20 20 | 3910.0|0 |
|00002690| 20 20 20 32 30 20 0a 37 | 36 35 39 20 46 4f 58 20 | 20 .7|659 FOX |
|000026a0| 20 20 20 20 20 20 20 41 | 4e 41 4c 59 53 54 20 20 | A|NALYST |
|000026b0| 20 37 35 36 36 20 20 33 | 33 33 35 2e 30 30 20 20 | 7566 3|335.00 |
|000026c0| 20 20 20 20 20 20 20 20 | 32 30 20 0a 37 35 30 31 | |20 .7501|
|000026d0| 20 57 41 52 44 20 20 20 | 20 20 20 20 53 41 4c 45 | WARD | SALE|
|000026e0| 53 4d 41 4e 20 20 37 36 | 39 38 20 20 31 33 31 32 |SMAN 76|98 1312|
|000026f0| 2e 35 30 20 20 20 35 30 | 30 2e 30 30 20 33 30 20 |.50 50|0.00 30 |
|00002700| 0a 37 36 39 38 20 42 4c | 41 4b 45 20 20 20 20 20 |.7698 BL|AKE |
|00002710| 20 4d 41 4e 41 47 45 52 | 20 20 20 37 38 33 39 20 | MANAGER| 7839 |
|00002720| 20 32 39 39 32 2e 35 30 | 20 20 20 20 20 20 20 20 | 2992.50| |
|00002730| 20 20 33 30 20 0a 37 38 | 34 34 20 54 55 52 4e 45 | 30 .78|44 TURNE|
|00002740| 52 20 20 20 20 20 53 41 | 4c 45 53 4d 41 4e 20 20 |R SA|LESMAN |
|00002750| 37 36 39 38 20 20 31 35 | 30 30 2e 30 30 20 20 20 |7698 15|00.00 |
|00002760| 20 20 30 2e 30 30 20 33 | 30 20 0a 37 39 30 30 20 | 0.00 3|0 .7900 |
|00002770| 4a 41 4d 45 53 20 20 20 | 20 20 20 43 4c 45 52 4b |JAMES | CLERK|
|00002780| 20 20 20 20 20 37 36 39 | 38 20 20 20 39 32 30 2e | 769|8 920.|
|00002790| 30 30 20 20 20 20 20 20 | 20 20 20 20 33 30 20 0a |00 | 30 .|
|000027a0| 37 39 35 34 20 43 41 52 | 54 45 52 20 20 20 20 20 |7954 CAR|TER |
|000027b0| 43 4c 45 52 4b 20 20 20 | 20 20 37 36 39 38 20 20 |CLERK | 7698 |
|000027c0| 20 39 32 30 2e 30 30 20 | 20 20 20 20 20 20 20 20 | 920.00 | |
|000027d0| 20 33 30 20 0a 37 39 35 | 35 20 57 49 4c 53 4f 4e | 30 .795|5 WILSON|
|000027e0| 20 20 20 20 20 53 41 4c | 45 53 4d 41 4e 20 20 20 | SAL|ESMAN |
|000027f0| 20 20 20 20 20 32 30 30 | 30 2e 30 30 20 20 20 35 | 200|0.00 5|
|00002800| 30 30 2e 30 30 20 33 30 | 20 0a 30 37 30 37 30 37 |00.00 30| .070707|
|00002810| 30 30 30 34 35 30 30 30 | 37 37 34 37 31 30 30 36 |00045000|77471006|
|00002820| 34 34 30 30 30 33 31 31 | 30 30 30 30 36 32 30 30 |44000311|00006200|
|00002830| 30 30 30 31 30 30 30 30 | 30 30 30 34 37 36 34 35 |00010000|00047645|
|00002840| 37 34 30 34 30 30 30 30 | 30 31 37 30 30 30 30 30 |74040000|01700000|
|00002850| 30 30 30 36 34 30 64 65 | 6d 6f 2f 63 61 73 65 32 |000640de|mo/case2|
|00002860| 2e 63 74 6c 00 2d 2d 20 | 0a 2d 2d 20 24 48 65 61 |.ctl.-- |.-- $Hea|
|00002870| 64 65 72 3a 20 63 61 73 | 65 32 2e 63 74 6c 2c 76 |der: cas|e2.ctl,v|
|00002880| 20 31 30 30 31 30 2e 36 | 20 38 38 2f 30 31 2f 31 | 10010.6| 88/01/1|
|00002890| 34 20 31 34 3a 34 30 3a | 30 38 20 68 64 61 69 20 |4 14:40:|08 hdai |
|000028a0| 45 78 70 20 24 20 63 61 | 73 65 32 2e 63 74 6c 20 |Exp $ ca|se2.ctl |
|000028b0| 0a 2d 2d 20 0a 4c 4f 41 | 44 20 44 41 54 41 0a 49 |.-- .LOA|D DATA.I|
|000028c0| 4e 46 49 4c 45 20 63 61 | 73 65 32 2e 64 61 74 0a |NFILE ca|se2.dat.|
|000028d0| 49 4e 54 4f 20 54 41 42 | 4c 45 20 45 4d 50 20 0a |INTO TAB|LE EMP .|
|000028e0| 0a 28 20 45 4d 50 4e 4f | 20 20 20 20 50 4f 53 49 |.( EMPNO| POSI|
|000028f0| 54 49 4f 4e 28 30 31 3a | 30 34 29 20 49 4e 54 45 |TION(01:|04) INTE|
|00002900| 47 45 52 20 45 58 54 45 | 52 4e 41 4c 2c 0a 20 20 |GER EXTE|RNAL,. |
|00002910| 45 4e 41 4d 45 20 20 20 | 20 50 4f 53 49 54 49 4f |ENAME | POSITIO|
|00002920| 4e 28 30 36 3a 31 35 29 | 20 43 48 41 52 2c 0a 20 |N(06:15)| CHAR,. |
|00002930| 20 4a 4f 42 20 20 20 20 | 20 20 50 4f 53 49 54 49 | JOB | POSITI|
|00002940| 4f 4e 28 31 37 3a 32 35 | 29 20 43 48 41 52 2c 0a |ON(17:25|) CHAR,.|
|00002950| 20 20 4d 47 52 20 20 20 | 20 20 20 50 4f 53 49 54 | MGR | POSIT|
|00002960| 49 4f 4e 28 32 37 3a 33 | 30 29 20 49 4e 54 45 47 |ION(27:3|0) INTEG|
|00002970| 45 52 20 45 58 54 45 52 | 4e 41 4c 2c 0a 20 20 53 |ER EXTER|NAL,. S|
|00002980| 41 4c 20 20 20 20 20 20 | 50 4f 53 49 54 49 4f 4e |AL |POSITION|
|00002990| 28 33 32 3a 33 39 29 20 | 44 45 43 49 4d 41 4c 20 |(32:39) |DECIMAL |
|000029a0| 45 58 54 45 52 4e 41 4c | 2c 0a 20 20 43 4f 4d 4d |EXTERNAL|,. COMM|
|000029b0| 20 20 20 20 20 50 4f 53 | 49 54 49 4f 4e 28 34 31 | POS|ITION(41|
|000029c0| 3a 34 38 29 20 44 45 43 | 49 4d 41 4c 20 45 58 54 |:48) DEC|IMAL EXT|
|000029d0| 45 52 4e 41 4c 2c 0a 20 | 20 44 45 50 54 4e 4f 20 |ERNAL,. | DEPTNO |
|000029e0| 20 20 50 4f 53 49 54 49 | 4f 4e 28 35 30 3a 35 31 | POSITI|ON(50:51|
|000029f0| 29 20 49 4e 54 45 47 45 | 52 20 45 58 54 45 52 4e |) INTEGE|R EXTERN|
|00002a00| 41 4c 29 0a 0a 30 37 30 | 37 30 37 30 30 30 34 35 |AL)..070|70700045|
|00002a10| 30 30 30 37 37 35 30 31 | 30 30 36 34 34 30 30 30 |00077501|00644000|
|00002a20| 33 31 31 30 30 30 30 36 | 32 30 30 30 30 30 31 30 |31100006|20000010|
|00002a30| 30 30 30 30 30 30 34 37 | 36 34 35 37 34 30 34 30 |00000047|64574040|
|00002a40| 30 30 30 30 31 37 30 30 | 30 30 30 30 30 32 30 34 |00001700|00000204|
|00002a50| 34 64 65 6d 6f 2f 63 61 | 73 65 32 2e 64 61 74 00 |4demo/ca|se2.dat.|
|00002a60| 37 37 38 32 20 43 4c 41 | 52 4b 20 20 20 20 20 20 |7782 CLA|RK |
|00002a70| 4d 41 4e 41 47 45 52 20 | 20 20 37 38 33 39 20 20 |MANAGER | 7839 |
|00002a80| 32 35 37 32 2e 35 30 20 | 20 20 20 20 20 20 20 20 |2572.50 | |
|00002a90| 20 31 30 20 0a 37 38 33 | 39 20 4b 49 4e 47 20 20 | 10 .783|9 KING |
|00002aa0| 20 20 20 20 20 50 52 45 | 53 49 44 45 4e 54 20 20 | PRE|SIDENT |
|00002ab0| 20 20 20 20 20 35 35 30 | 30 2e 30 30 20 20 20 20 | 550|0.00 |
|00002ac0| 20 20 20 20 20 20 31 30 | 20 0a 37 39 33 34 20 4d | 10| .7934 M|
|00002ad0| 49 4c 4c 45 52 20 20 20 | 20 20 43 4c 45 52 4b 20 |ILLER | CLERK |
|00002ae0| 20 20 20 20 37 37 38 32 | 20 20 20 39 32 30 2e 30 | 7782| 920.0|
|00002af0| 30 20 20 20 20 20 20 20 | 20 20 20 31 30 20 0a 37 |0 | 10 .7|
|00002b00| 35 36 36 20 4a 4f 4e 45 | 53 20 20 20 20 20 20 4d |566 JONE|S M|
|00002b10| 41 4e 41 47 45 52 20 20 | 20 37 38 33 39 20 20 33 |ANAGER | 7839 3|
|00002b20| 31 32 33 2e 37 35 20 20 | 20 20 20 20 20 20 20 20 |123.75 | |
|00002b30| 32 30 20 0a 37 34 39 39 | 20 41 4c 4c 45 4e 20 20 |20 .7499| ALLEN |
|00002b40| 20 20 20 20 53 41 4c 45 | 53 4d 41 4e 20 20 37 36 | SALE|SMAN 76|
|00002b50| 39 38 20 20 31 36 30 30 | 2e 30 30 20 20 20 33 30 |98 1600|.00 30|
|00002b60| 30 2e 30 30 20 33 30 20 | 0a 37 36 35 34 20 4d 41 |0.00 30 |.7654 MA|
|00002b70| 52 54 49 4e 20 20 20 20 | 20 53 41 4c 45 53 4d 41 |RTIN | SALESMA|
|00002b80| 4e 20 20 37 36 39 38 20 | 20 31 33 31 32 2e 35 30 |N 7698 | 1312.50|
|00002b90| 20 20 31 34 30 30 2e 30 | 30 20 33 30 20 0a 37 36 | 1400.0|0 30 .76|
|00002ba0| 35 38 20 43 48 41 4e 20 | 20 20 20 20 20 20 41 4e |58 CHAN | AN|
|00002bb0| 41 4c 59 53 54 20 20 20 | 37 35 36 36 20 20 33 34 |ALYST |7566 34|
|00002bc0| 35 30 2e 30 30 20 20 20 | 20 20 20 20 20 20 20 32 |50.00 | 2|
|00002bd0| 30 20 0a 37 39 39 39 20 | 42 52 4f 57 4e 20 20 20 |0 .7999 |BROWN |
|00002be0| 20 20 20 43 4c 45 52 4b | 20 20 20 20 20 37 39 30 | CLERK| 790|
|00002bf0| 32 20 20 20 38 30 30 2e | 30 30 20 20 20 20 20 20 |2 800.|00 |
|00002c00| 20 20 20 20 31 30 20 0a | 37 33 36 39 20 53 4d 49 | 10 .|7369 SMI|
|00002c10| 54 48 20 20 20 20 20 20 | 43 4c 45 52 4b 20 20 20 |TH |CLERK |
|00002c20| 20 20 37 39 30 32 20 20 | 20 39 32 30 2e 30 30 20 | 7902 | 920.00 |
|00002c30| 20 20 20 20 20 20 20 20 | 20 31 30 20 0a 37 37 38 | | 10 .778|
|00002c40| 38 20 53 43 4f 54 54 20 | 20 20 20 20 20 41 4e 41 |8 SCOTT | ANA|
|00002c50| 4c 59 53 54 20 20 20 37 | 35 36 36 20 20 33 37 39 |LYST 7|566 379|
|00002c60| 35 2e 30 30 20 20 20 20 | 20 20 20 20 20 20 32 30 |5.00 | 20|
|00002c70| 20 0a 37 38 37 36 20 41 | 44 41 4d 53 20 20 20 20 | .7876 A|DAMS |
|00002c80| 20 20 43 4c 45 52 4b 20 | 20 20 20 20 37 37 38 38 | CLERK | 7788|
|00002c90| 20 20 20 39 32 30 2e 30 | 30 20 20 20 20 20 20 20 | 920.0|0 |
|00002ca0| 20 20 20 32 30 20 0a 37 | 39 30 32 20 46 4f 52 44 | 20 .7|902 FORD|
|00002cb0| 20 20 20 20 20 20 20 41 | 4e 41 4c 59 53 54 20 20 | A|NALYST |
|00002cc0| 20 37 35 36 36 20 20 33 | 34 35 30 2e 30 30 20 20 | 7566 3|450.00 |
|00002cd0| 20 20 20 20 20 20 20 20 | 32 30 20 0a 37 36 35 37 | |20 .7657|
|00002ce0| 20 4d 41 53 4f 4e 20 20 | 20 20 20 20 41 4e 41 4c | MASON | ANAL|
|00002cf0| 59 53 54 20 20 20 37 35 | 36 36 20 20 33 39 31 30 |YST 75|66 3910|
|00002d00| 2e 30 30 20 20 20 20 20 | 20 20 20 20 20 32 30 20 |.00 | 20 |
|00002d10| 0a 37 36 35 39 20 46 4f | 58 20 20 20 20 20 20 20 |.7659 FO|X |
|00002d20| 20 41 4e 41 4c 59 53 54 | 20 20 20 37 35 36 36 20 | ANALYST| 7566 |
|00002d30| 20 33 33 33 35 2e 30 30 | 20 20 20 20 20 20 20 20 | 3335.00| |
|00002d40| 20 20 32 30 20 0a 37 35 | 30 31 20 57 41 52 44 20 | 20 .75|01 WARD |
|00002d50| 20 20 20 20 20 20 53 41 | 4c 45 53 4d 41 4e 20 20 | SA|LESMAN |
|00002d60| 37 36 39 38 20 20 31 33 | 31 32 2e 35 30 20 20 20 |7698 13|12.50 |
|00002d70| 35 30 30 2e 30 30 20 33 | 30 20 0a 37 36 39 38 20 |500.00 3|0 .7698 |
|00002d80| 42 4c 41 4b 45 20 20 20 | 20 20 20 4d 41 4e 41 47 |BLAKE | MANAG|
|00002d90| 45 52 20 20 20 37 38 33 | 39 20 20 32 39 39 32 2e |ER 783|9 2992.|
|00002da0| 35 30 20 20 20 20 20 20 | 20 20 20 20 33 30 20 0a |50 | 30 .|
|00002db0| 37 38 34 34 20 54 55 52 | 4e 45 52 20 20 20 20 20 |7844 TUR|NER |
|00002dc0| 53 41 4c 45 53 4d 41 4e | 20 20 37 36 39 38 20 20 |SALESMAN| 7698 |
|00002dd0| 31 35 30 30 2e 30 30 20 | 20 20 20 20 30 2e 30 30 |1500.00 | 0.00|
|00002de0| 20 33 30 20 0a 37 39 30 | 30 20 4a 41 4d 45 53 20 | 30 .790|0 JAMES |
|00002df0| 20 20 20 20 20 43 4c 45 | 52 4b 20 20 20 20 20 37 | CLE|RK 7|
|00002e00| 36 39 38 20 20 20 39 32 | 30 2e 30 30 20 20 20 20 |698 92|0.00 |
|00002e10| 20 20 20 20 20 20 33 30 | 20 0a 37 39 35 34 20 43 | 30| .7954 C|
|00002e20| 41 52 54 45 52 20 20 20 | 20 20 43 4c 45 52 4b 20 |ARTER | CLERK |
|00002e30| 20 20 20 20 37 36 39 38 | 20 20 20 39 32 30 2e 30 | 7698| 920.0|
|00002e40| 30 20 20 20 20 20 20 20 | 20 20 20 33 30 20 0a 37 |0 | 30 .7|
|00002e50| 39 35 35 20 57 49 4c 53 | 4f 4e 20 20 20 20 20 53 |955 WILS|ON S|
|00002e60| 41 4c 45 53 4d 41 4e 20 | 20 20 20 20 20 20 20 32 |ALESMAN | 2|
|00002e70| 30 30 30 2e 30 30 20 20 | 20 35 30 30 2e 30 30 20 |000.00 | 500.00 |
|00002e80| 33 30 20 0a 30 37 30 37 | 30 37 30 30 30 34 35 30 |30 .0707|07000450|
|00002e90| 30 30 37 37 35 31 31 30 | 30 36 34 34 30 30 30 33 |00775110|06440003|
|00002ea0| 31 31 30 30 30 30 36 32 | 30 30 30 30 30 31 30 30 |11000062|00000100|
|00002eb0| 30 30 30 30 30 34 37 36 | 34 35 37 34 30 34 30 30 |00000476|45740400|
|00002ec0| 30 30 30 31 37 30 30 30 | 30 30 30 30 31 35 31 36 |00017000|00001516|
|00002ed0| 64 65 6d 6f 2f 63 61 73 | 65 33 2e 63 74 6c 00 2d |demo/cas|e3.ctl.-|
|00002ee0| 2d 20 0a 2d 2d 20 24 48 | 65 61 64 65 72 3a 20 63 |- .-- $H|eader: c|
|00002ef0| 61 73 65 33 2e 63 74 6c | 2c 76 20 31 30 30 31 30 |ase3.ctl|,v 10010|
|00002f00| 2e 33 20 38 38 2f 30 31 | 2f 31 34 20 31 34 3a 34 |.3 88/01|/14 14:4|
|00002f10| 30 3a 31 37 20 68 64 61 | 69 20 45 78 70 20 24 20 |0:17 hda|i Exp $ |
|00002f20| 63 61 73 65 33 2e 63 74 | 6c 20 0a 2d 2d 20 0a 2d |case3.ct|l .-- .-|
|00002f30| 2d 20 56 61 72 69 61 62 | 6c 65 20 6c 65 6e 67 74 |- Variab|le lengt|
|00002f40| 68 2c 20 64 65 6c 69 6d | 69 74 65 64 20 61 6e 64 |h, delim|ited and|
|00002f50| 20 65 6e 63 6c 6f 73 65 | 64 20 64 61 74 61 20 66 | enclose|d data f|
|00002f60| 6f 72 6d 61 74 0a 0a 4c | 4f 41 44 20 44 41 54 41 |ormat..L|OAD DATA|
|00002f70| 20 0a 49 4e 46 49 4c 45 | 20 2a 0a 41 50 50 45 4e | .INFILE| *.APPEN|
|00002f80| 44 0a 0a 49 4e 54 4f 20 | 54 41 42 4c 45 20 45 4d |D..INTO |TABLE EM|
|00002f90| 50 0a 46 49 45 4c 44 53 | 20 54 45 52 4d 49 4e 41 |P.FIELDS| TERMINA|
|00002fa0| 54 45 44 20 42 59 20 22 | 2c 22 20 4f 50 54 49 4f |TED BY "|," OPTIO|
|00002fb0| 4e 41 4c 4c 59 20 45 4e | 43 4c 4f 53 45 44 20 42 |NALLY EN|CLOSED B|
|00002fc0| 59 20 27 22 27 09 0a 28 | 65 6d 70 6e 6f 2c 20 65 |Y '"'..(|empno, e|
|00002fd0| 6e 61 6d 65 2c 20 6a 6f | 62 2c 20 6d 67 72 2c 0a |name, jo|b, mgr,.|
|00002fe0| 20 68 69 72 65 64 61 74 | 65 20 44 41 54 45 28 32 | hiredat|e DATE(2|
|00002ff0| 30 29 20 22 44 44 2d 4d | 6f 6e 74 68 2d 59 59 59 |0) "DD-M|onth-YYY|
|00003000| 59 22 2c 0a 20 73 61 6c | 2c 20 63 6f 6d 6d 2c 0a |Y",. sal|, comm,.|
|00003010| 20 64 65 70 74 6e 6f 20 | 20 20 43 48 41 52 20 54 | deptno | CHAR T|
|00003020| 45 52 4d 49 4e 41 54 45 | 44 20 42 59 20 27 3a 27 |ERMINATE|D BY ':'|
|00003030| 2c 0a 20 6c 6f 61 64 73 | 65 71 20 20 53 45 51 55 |,. loads|eq SEQU|
|00003040| 45 4e 43 45 28 4d 41 58 | 2c 31 29 20 29 09 09 0a |ENCE(MAX|,1) )...|
|00003050| 0a 42 45 47 49 4e 44 41 | 54 41 0a 37 37 38 32 2c |.BEGINDA|TA.7782,|
|00003060| 20 22 43 6c 61 72 6b 22 | 2c 20 22 4d 61 6e 61 67 | "Clark"|, "Manag|
|00003070| 65 72 22 2c 20 37 38 33 | 39 2c 20 30 39 2d 4a 75 |er", 783|9, 09-Ju|
|00003080| 6e 65 2d 31 39 38 31 2c | 20 32 35 37 32 2e 35 30 |ne-1981,| 2572.50|
|00003090| 2c 2c 20 31 30 3a 31 30 | 31 0a 37 38 33 39 2c 20 |,, 10:10|1.7839, |
|000030a0| 22 4b 69 6e 67 22 2c 20 | 22 50 72 65 73 69 64 65 |"King", |"Preside|
|000030b0| 6e 74 22 2c 20 2c 20 31 | 37 2d 4e 6f 76 65 6d 62 |nt", , 1|7-Novemb|
|000030c0| 65 72 2d 31 39 38 31 2c | 20 35 35 30 30 2e 30 30 |er-1981,| 5500.00|
|000030d0| 2c 2c 20 31 30 3a 31 30 | 32 0a 37 39 33 34 2c 20 |,, 10:10|2.7934, |
|000030e0| 22 4d 69 6c 6c 65 72 22 | 2c 20 22 43 6c 65 72 6b |"Miller"|, "Clerk|
|000030f0| 22 2c 20 37 37 38 32 2c | 20 32 33 2d 4a 61 6e 75 |", 7782,| 23-Janu|
|00003100| 61 72 79 2d 31 39 38 32 | 2c 20 39 32 30 2e 30 30 |ary-1982|, 920.00|
|00003110| 2c 2c 20 31 30 3a 31 30 | 32 0a 37 35 36 36 2c 20 |,, 10:10|2.7566, |
|00003120| 22 4a 6f 6e 65 73 22 2c | 20 22 4d 61 6e 61 67 65 |"Jones",| "Manage|
|00003130| 72 22 2c 20 37 38 33 39 | 2c 20 30 32 2d 41 70 72 |r", 7839|, 02-Apr|
|00003140| 69 6c 2d 31 39 38 31 2c | 20 33 31 32 33 2e 37 35 |il-1981,| 3123.75|
|00003150| 2c 2c 20 32 30 3a 31 30 | 31 0a 37 34 39 39 2c 20 |,, 20:10|1.7499, |
|00003160| 22 41 6c 6c 65 6e 22 2c | 20 22 53 61 6c 65 73 6d |"Allen",| "Salesm|
|00003170| 61 6e 22 2c 20 37 36 39 | 38 2c 20 32 30 2d 46 65 |an", 769|8, 20-Fe|
|00003180| 62 72 75 61 72 79 2d 31 | 39 38 31 2c 20 31 36 30 |bruary-1|981, 160|
|00003190| 30 2e 30 30 2c 20 33 30 | 30 2e 30 30 2c 20 33 30 |0.00, 30|0.00, 30|
|000031a0| 3a 31 30 33 0a 37 36 35 | 34 2c 20 22 4d 61 72 74 |:103.765|4, "Mart|
|000031b0| 69 6e 22 2c 20 22 53 61 | 6c 65 73 6d 61 6e 22 2c |in", "Sa|lesman",|
|000031c0| 20 37 36 39 38 2c 20 32 | 38 2d 53 65 70 74 65 6d | 7698, 2|8-Septem|
|000031d0| 62 65 72 2d 31 39 38 31 | 2c 20 31 33 31 32 2e 35 |ber-1981|, 1312.5|
|000031e0| 30 2c 20 31 34 30 30 2e | 30 30 2c 20 33 30 3a 31 |0, 1400.|00, 30:1|
|000031f0| 30 33 0a 37 36 35 38 2c | 20 22 43 68 61 6e 22 2c |03.7658,| "Chan",|
|00003200| 20 22 41 6e 61 6c 79 73 | 74 22 2c 20 37 35 36 36 | "Analys|t", 7566|
|00003210| 2c 20 30 33 2d 4d 61 79 | 2d 31 39 38 32 2c 20 33 |, 03-May|-1982, 3|
|00003220| 34 35 30 2c 2c 20 32 30 | 3a 31 30 31 0a 30 37 30 |450,, 20|:101.070|
|00003230| 37 30 37 30 30 30 34 35 | 30 30 30 37 37 35 32 31 |70700045|00077521|
|00003240| 30 30 36 34 34 30 30 30 | 33 31 31 30 30 30 30 36 |00644000|31100006|
|00003250| 32 30 30 30 30 30 31 30 | 30 30 30 30 30 30 34 37 |20000010|00000047|
|00003260| 36 34 35 37 34 30 34 30 | 30 30 30 30 31 37 30 30 |64574040|00001700|
|00003270| 30 30 30 30 30 31 31 30 | 30 64 65 6d 6f 2f 63 61 |00000110|0demo/ca|
|00003280| 73 65 33 2e 64 61 74 00 | 2a 37 37 38 32 20 43 4c |se3.dat.|*7782 CL|
|00003290| 41 52 4b 20 20 20 20 20 | 20 4d 41 0a 20 4e 41 47 |ARK | MA. NAG|
|000032a0| 45 52 20 20 20 37 38 33 | 39 20 20 32 35 37 32 2e |ER 783|9 2572.|
|000032b0| 35 30 20 20 20 2d 31 30 | 20 20 20 20 32 35 31 32 |50 -10| 2512|
|000032c0| 2d 4e 4f 56 2d 38 35 0a | 2a 37 38 33 39 20 4b 49 |-NOV-85.|*7839 KI|
|000032d0| 4e 47 20 20 20 20 20 20 | 20 50 52 0a 20 45 53 49 |NG | PR. ESI|
|000032e0| 44 45 4e 54 20 20 20 20 | 20 20 20 35 35 30 30 2e |DENT | 5500.|
|000032f0| 30 30 20 20 20 20 20 20 | 20 20 20 20 32 35 30 35 |00 | 2505|
|00003300| 2d 41 50 52 2d 38 33 0a | 2a 37 39 33 34 20 4d 49 |-APR-83.|*7934 MI|
|00003310| 4c 4c 45 52 20 20 20 20 | 20 43 4c 0a 20 45 52 4b |LLER | CL. ERK|
|00003320| 20 20 20 20 20 37 37 38 | 32 20 20 20 39 32 30 2e | 778|2 920.|
|00003330| 30 30 20 20 20 20 20 20 | 20 20 20 20 32 35 30 38 |00 | 2508|
|00003340| 2d 4d 41 59 2d 38 30 0a | 2a 37 35 36 36 20 4a 4f |-MAY-80.|*7566 JO|
|00003350| 4e 45 53 20 20 20 20 20 | 20 4d 41 0a 20 4e 41 47 |NES | MA. NAG|
|00003360| 45 52 20 20 20 37 38 33 | 39 20 20 33 31 32 33 2e |ER 783|9 3123.|
|00003370| 37 35 20 20 20 20 20 20 | 20 20 20 20 32 35 31 37 |75 | 2517|
|00003380| 2d 4a 55 4c 2d 38 35 0a | 2a 37 34 39 39 20 41 4c |-JUL-85.|*7499 AL|
|00003390| 4c 45 4e 20 20 20 20 20 | 20 53 41 0a 20 4c 45 53 |LEN | SA. LES|
|000033a0| 4d 41 4e 20 20 37 36 39 | 38 20 20 31 36 30 30 2e |MAN 769|8 1600.|
|000033b0| 30 30 20 20 20 33 30 30 | 2e 30 30 20 32 35 20 33 |00 300|.00 25 3|
|000033c0| 2d 4a 55 4e 2d 38 34 0a | 2a 37 36 35 34 20 4d 41 |-JUN-84.|*7654 MA|
|000033d0| 52 54 49 4e 20 20 20 20 | 20 53 41 0a 20 4c 45 53 |RTIN | SA. LES|
|000033e0| 4d 41 4e 20 20 37 36 39 | 38 20 20 31 33 31 32 2e |MAN 769|8 1312.|
|000033f0| 35 30 20 20 31 34 30 30 | 2e 30 30 20 32 35 32 31 |50 1400|.00 2521|
|00003400| 2d 44 45 43 2d 38 35 0a | 2a 37 36 35 38 20 43 48 |-DEC-85.|*7658 CH|
|00003410| 41 4e 20 20 20 20 20 20 | 20 41 4e 0a 20 41 4c 59 |AN | AN. ALY|
|00003420| 53 54 20 20 20 37 35 36 | 36 20 20 33 34 35 30 2e |ST 756|6 3450.|
|00003430| 30 30 20 20 20 20 20 20 | 20 20 20 20 32 35 31 36 |00 | 2516|
|00003440| 2d 46 45 42 2d 38 34 0a | 2a 20 20 20 20 20 43 48 |-FEB-84.|* CH|
|00003450| 45 4e 20 20 20 20 20 20 | 20 41 4e 0a 20 41 4c 59 |EN | AN. ALY|
|00003460| 53 54 20 20 20 37 35 36 | 36 20 20 33 34 35 30 2e |ST 756|6 3450.|
|00003470| 30 30 20 20 20 20 20 20 | 20 20 20 20 32 35 31 36 |00 | 2516|
|00003480| 2d 46 45 42 2d 38 34 0a | 2a 37 36 35 38 20 43 48 |-FEB-84.|*7658 CH|
|00003490| 49 4e 20 20 20 20 20 20 | 20 41 4e 0a 20 41 4c 59 |IN | AN. ALY|
|000034a0| 53 54 20 20 20 37 35 36 | 36 20 20 33 34 35 30 2e |ST 756|6 3450.|
|000034b0| 30 30 20 20 20 20 20 20 | 20 20 20 20 32 35 31 36 |00 | 2516|
|000034c0| 2d 46 45 42 2d 38 34 0a | 30 37 30 37 30 37 30 30 |-FEB-84.|07070700|
|000034d0| 30 34 35 30 30 30 37 37 | 35 33 31 30 30 36 34 34 |04500077|53100644|
|000034e0| 30 30 30 33 31 31 30 30 | 30 30 36 32 30 30 30 30 |00031100|00620000|
|000034f0| 30 31 30 30 30 30 30 30 | 30 34 37 36 34 35 37 34 |01000000|04764574|
|00003500| 30 34 30 30 30 30 30 31 | 37 30 30 30 30 30 30 30 |04000001|70000000|
|00003510| 31 30 32 30 64 65 6d 6f | 2f 63 61 73 65 34 2e 63 |1020demo|/case4.c|
|00003520| 74 6c 00 2d 2d 20 0a 2d | 2d 20 24 48 65 61 64 65 |tl.-- .-|- $Heade|
|00003530| 72 3a 20 63 61 73 65 34 | 2e 63 74 6c 2c 76 20 31 |r: case4|.ctl,v 1|
|00003540| 30 30 31 30 2e 33 20 38 | 38 2f 30 31 2f 31 34 20 |0010.3 8|8/01/14 |
|00003550| 31 34 3a 34 30 3a 31 39 | 20 68 64 61 69 20 45 78 |14:40:19| hdai Ex|
|00003560| 70 20 24 20 63 61 73 65 | 34 2e 63 74 6c 20 0a 2d |p $ case|4.ctl .-|
|00003570| 2d 20 0a 4c 4f 41 44 20 | 44 41 54 41 0a 49 4e 46 |- .LOAD |DATA.INF|
|00003580| 49 4c 45 20 63 61 73 65 | 34 2e 64 61 74 0a 44 49 |ILE case|4.dat.DI|
|00003590| 53 43 41 52 44 46 49 4c | 45 20 63 61 73 65 34 2e |SCARDFIL|E case4.|
|000035a0| 64 69 73 09 0a 44 49 53 | 43 41 52 44 4d 41 58 20 |dis..DIS|CARDMAX |
|000035b0| 39 39 39 09 0a 52 45 50 | 4c 41 43 45 0a 43 4f 4e |999..REP|LACE.CON|
|000035c0| 54 49 4e 55 45 49 46 20 | 28 31 29 20 3d 20 27 2a |TINUEIF |(1) = '*|
|000035d0| 27 0a 49 4e 54 4f 20 54 | 41 42 4c 45 20 45 4d 50 |'.INTO T|ABLE EMP|
|000035e0| 20 0a 0a 28 20 45 4d 50 | 4e 4f 20 20 20 20 50 4f | ..( EMP|NO PO|
|000035f0| 53 49 54 49 4f 4e 28 30 | 32 3a 30 35 29 20 49 4e |SITION(0|2:05) IN|
|00003600| 54 45 47 45 52 20 45 58 | 54 45 52 4e 41 4c 2c 0a |TEGER EX|TERNAL,.|
|00003610| 20 20 45 4e 41 4d 45 20 | 20 20 20 50 4f 53 49 54 | ENAME | POSIT|
|00003620| 49 4f 4e 28 30 37 3a 31 | 36 29 20 43 48 41 52 2c |ION(07:1|6) CHAR,|
|00003630| 0a 20 20 4a 4f 42 20 20 | 20 20 20 20 50 4f 53 49 |. JOB | POSI|
|00003640| 54 49 4f 4e 28 31 38 3a | 32 36 29 20 43 48 41 52 |TION(18:|26) CHAR|
|00003650| 2c 0a 20 20 4d 47 52 20 | 20 20 20 20 20 50 4f 53 |,. MGR | POS|
|00003660| 49 54 49 4f 4e 28 32 38 | 3a 33 31 29 20 49 4e 54 |ITION(28|:31) INT|
|00003670| 45 47 45 52 20 45 58 54 | 45 52 4e 41 4c 2c 0a 20 |EGER EXT|ERNAL,. |
|00003680| 20 53 41 4c 20 20 20 20 | 20 20 50 4f 53 49 54 49 | SAL | POSITI|
|00003690| 4f 4e 28 33 33 3a 34 30 | 29 20 44 45 43 49 4d 41 |ON(33:40|) DECIMA|
|000036a0| 4c 20 45 58 54 45 52 4e | 41 4c 2c 0a 20 20 43 4f |L EXTERN|AL,. CO|
|000036b0| 4d 4d 20 20 20 20 20 50 | 4f 53 49 54 49 4f 4e 28 |MM P|OSITION(|
|000036c0| 34 32 3a 34 39 29 20 44 | 45 43 49 4d 41 4c 20 45 |42:49) D|ECIMAL E|
|000036d0| 58 54 45 52 4e 41 4c 2c | 0a 20 20 44 45 50 54 4e |XTERNAL,|. DEPTN|
|000036e0| 4f 20 20 20 50 4f 53 49 | 54 49 4f 4e 28 35 31 3a |O POSI|TION(51:|
|000036f0| 35 32 29 20 49 4e 54 45 | 47 45 52 20 45 58 54 45 |52) INTE|GER EXTE|
|00003700| 52 4e 41 4c 2c 0a 20 20 | 48 49 52 45 44 41 54 45 |RNAL,. |HIREDATE|
|00003710| 20 50 4f 53 49 54 49 4f | 4e 28 35 33 3a 36 31 29 | POSITIO|N(53:61)|
|00003720| 20 49 4e 54 45 47 45 52 | 20 45 58 54 45 52 4e 41 | INTEGER| EXTERNA|
|00003730| 4c 29 0a 30 37 30 37 30 | 37 30 30 30 34 35 30 30 |L).07070|70004500|
|00003740| 30 37 37 35 34 31 30 30 | 36 34 34 30 30 30 33 31 |07754100|64400031|
|00003750| 31 30 30 30 30 36 32 30 | 30 30 30 30 31 30 30 30 |10000620|00001000|
|00003760| 30 30 30 30 34 37 36 34 | 35 37 34 30 34 30 30 30 |00004764|57404000|
|00003770| 30 30 31 37 30 30 30 30 | 30 30 30 31 31 31 31 64 |00170000|0001111d|
|00003780| 65 6d 6f 2f 63 61 73 65 | 34 2e 64 61 74 00 2a 20 |emo/case|4.dat.* |
|00003790| 37 37 38 32 20 43 4c 41 | 52 4b 20 20 20 20 20 20 |7782 CLA|RK |
|000037a0| 4d 41 0a 20 4e 41 47 45 | 52 20 20 20 37 38 33 39 |MA. NAGE|R 7839|
|000037b0| 20 20 32 35 37 32 2e 35 | 30 20 20 20 2d 31 30 20 | 2572.5|0 -10 |
|000037c0| 20 20 20 32 35 31 32 2d | 4e 4f 56 2d 38 35 0a 2a | 2512-|NOV-85.*|
|000037d0| 20 37 38 33 39 20 4b 49 | 4e 47 20 20 20 20 20 20 | 7839 KI|NG |
|000037e0| 20 50 52 0a 20 45 53 49 | 44 45 4e 54 20 20 20 20 | PR. ESI|DENT |
|000037f0| 20 20 20 35 35 30 30 2e | 30 30 20 20 20 20 20 20 | 5500.|00 |
|00003800| 20 20 20 20 32 35 30 35 | 2d 41 50 52 2d 38 33 0a | 2505|-APR-83.|
|00003810| 2a 20 37 39 33 34 20 4d | 49 4c 4c 45 52 20 20 20 |* 7934 M|ILLER |
|00003820| 20 20 43 4c 0a 20 45 52 | 4b 20 20 20 20 20 37 37 | CL. ER|K 77|
|00003830| 38 32 20 20 20 39 32 30 | 2e 30 30 20 20 20 20 20 |82 920|.00 |
|00003840| 20 20 20 20 20 32 35 30 | 38 2d 4d 41 59 2d 38 30 | 250|8-MAY-80|
|00003850| 0a 2a 20 37 35 36 36 20 | 4a 4f 4e 45 53 20 20 20 |.* 7566 |JONES |
|00003860| 20 20 20 4d 41 0a 20 4e | 41 47 45 52 20 20 20 37 | MA. N|AGER 7|
|00003870| 38 33 39 20 20 33 31 32 | 33 2e 37 35 20 20 20 20 |839 312|3.75 |
|00003880| 20 20 20 20 20 20 32 35 | 31 37 2d 4a 55 4c 2d 38 | 25|17-JUL-8|
|00003890| 35 0a 2a 20 37 34 39 39 | 20 41 4c 4c 45 4e 20 20 |5.* 7499| ALLEN |
|000038a0| 20 20 20 20 53 41 0a 20 | 4c 45 53 4d 41 4e 20 20 | SA. |LESMAN |
|000038b0| 37 36 39 38 20 20 31 36 | 30 30 2e 30 30 20 20 20 |7698 16|00.00 |
|000038c0| 33 30 30 2e 30 30 20 32 | 35 20 33 2d 4a 55 4e 2d |300.00 2|5 3-JUN-|
|000038d0| 38 34 0a 2a 20 37 36 35 | 34 20 4d 41 52 54 49 4e |84.* 765|4 MARTIN|
|000038e0| 20 20 20 20 20 53 41 0a | 20 4c 45 53 4d 41 4e 20 | SA.| LESMAN |
|000038f0| 20 37 36 39 38 20 20 31 | 33 31 32 2e 35 30 20 20 | 7698 1|312.50 |
|00003900| 31 34 30 30 2e 30 30 20 | 32 35 32 31 2d 44 45 43 |1400.00 |2521-DEC|
|00003910| 2d 38 35 0a 2a 20 37 36 | 35 38 20 43 48 41 4e 20 |-85.* 76|58 CHAN |
|00003920| 20 20 20 20 20 20 41 4e | 0a 20 41 4c 59 53 54 20 | AN|. ALYST |
|00003930| 20 20 37 35 36 36 20 20 | 33 34 35 30 2e 30 30 20 | 7566 |3450.00 |
|00003940| 20 20 20 20 20 20 20 20 | 20 32 35 31 36 2d 46 45 | | 2516-FE|
|00003950| 42 2d 38 34 0a 2a 20 20 | 20 20 20 20 43 48 45 4e |B-84.* | CHEN|
|00003960| 20 20 20 20 20 20 20 41 | 4e 0a 20 41 4c 59 53 54 | A|N. ALYST|
|00003970| 20 20 20 37 35 36 36 20 | 20 33 34 35 30 2e 30 30 | 7566 | 3450.00|
|00003980| 20 20 20 20 20 20 20 20 | 20 20 32 35 31 36 2d 46 | | 2516-F|
|00003990| 45 42 2d 38 34 0a 2a 20 | 37 36 35 38 20 43 48 49 |EB-84.* |7658 CHI|
|000039a0| 4e 20 20 20 20 20 20 20 | 41 4e 0a 20 41 4c 59 53 |N |AN. ALYS|
|000039b0| 54 20 20 20 37 35 36 36 | 20 20 33 34 35 30 2e 30 |T 7566| 3450.0|
|000039c0| 30 20 20 20 20 20 20 20 | 20 20 20 32 35 31 36 2d |0 | 2516-|
|000039d0| 46 45 42 2d 38 34 0a 30 | 37 30 37 30 37 30 30 30 |FEB-84.0|70707000|
|000039e0| 34 35 30 30 30 37 37 35 | 35 31 30 30 36 34 34 30 |45000775|51006440|
|000039f0| 30 30 33 31 31 30 30 30 | 30 36 32 30 30 30 30 30 |00311000|06200000|
|00003a00| 31 30 30 30 30 30 30 30 | 34 37 36 34 35 37 34 30 |10000000|47645740|
|00003a10| 34 30 30 30 30 30 31 37 | 30 30 30 30 30 30 30 31 |40000017|00000001|
|00003a20| 36 36 31 64 65 6d 6f 2f | 63 61 73 65 35 2e 63 74 |661demo/|case5.ct|
|00003a30| 6c 00 2d 2d 20 0a 2d 2d | 20 24 48 65 61 64 65 72 |l.-- .--| $Header|
|00003a40| 3a 20 63 61 73 65 35 2e | 63 74 6c 2c 76 20 31 30 |: case5.|ctl,v 10|
|00003a50| 30 31 30 2e 34 20 38 38 | 2f 30 31 2f 31 34 20 31 |010.4 88|/01/14 1|
|00003a60| 34 3a 34 30 3a 32 31 20 | 68 64 61 69 20 45 78 70 |4:40:21 |hdai Exp|
|00003a70| 20 24 20 63 61 73 65 35 | 2e 63 74 6c 20 0a 2d 2d | $ case5|.ctl .--|
|00003a80| 20 0a 2d 2d 20 4c 6f 61 | 64 73 20 45 4d 50 20 72 | .-- Loa|ds EMP r|
|00003a90| 65 63 6f 72 64 73 20 66 | 72 6f 6d 20 66 69 72 73 |ecords f|rom firs|
|00003aa0| 74 20 32 33 20 63 68 61 | 72 61 63 74 65 72 73 0a |t 23 cha|racters.|
|00003ab0| 2d 2d 20 43 72 65 61 74 | 65 73 20 61 6e 64 20 6c |-- Creat|es and l|
|00003ac0| 6f 61 64 73 20 50 52 4f | 4a 20 72 65 63 6f 72 64 |oads PRO|J record|
|00003ad0| 73 20 66 6f 72 20 65 61 | 63 68 20 50 52 4f 4a 4f |s for ea|ch PROJO|
|00003ae0| 20 6c 69 73 74 65 64 0a | 2d 2d 20 66 6f 72 20 65 | listed.|-- for e|
|00003af0| 61 63 68 20 65 6d 70 6c | 6f 79 65 65 0a 0a 4c 4f |ach empl|oyee..LO|
|00003b00| 41 44 20 44 41 54 41 0a | 49 4e 46 49 4c 45 20 63 |AD DATA.|INFILE c|
|00003b10| 61 73 65 35 2e 64 61 74 | 0a 42 41 44 46 49 4c 45 |ase5.dat|.BADFILE|
|00003b20| 20 63 61 73 65 35 2e 62 | 61 64 0a 44 49 53 43 41 | case5.b|ad.DISCA|
|00003b30| 52 44 46 49 4c 45 20 63 | 61 73 65 35 2e 64 69 73 |RDFILE c|ase5.dis|
|00003b40| 0a 52 45 50 4c 41 43 45 | 0a 0a 49 4e 54 4f 20 54 |.REPLACE|..INTO T|
|00003b50| 41 42 4c 45 20 45 4d 50 | 0a 20 20 28 45 4d 50 4e |ABLE EMP|. (EMPN|
|00003b60| 4f 20 20 20 20 50 4f 53 | 49 54 49 4f 4e 28 31 3a |O POS|ITION(1:|
|00003b70| 34 29 20 20 20 49 4e 54 | 45 47 45 52 20 45 58 54 |4) INT|EGER EXT|
|00003b80| 45 52 4e 41 4c 2c 0a 20 | 20 20 45 4e 41 4d 45 20 |ERNAL,. | ENAME |
|00003b90| 20 20 20 50 4f 53 49 54 | 49 4f 4e 28 36 3a 31 35 | POSIT|ION(6:15|
|00003ba0| 29 20 20 43 48 41 52 2c | 0a 20 20 20 44 45 50 54 |) CHAR,|. DEPT|
|00003bb0| 4e 4f 20 20 20 50 4f 53 | 49 54 49 4f 4e 28 31 37 |NO POS|ITION(17|
|00003bc0| 3a 31 38 29 20 43 48 41 | 52 2c 0a 20 20 20 4d 47 |:18) CHA|R,. MG|
|00003bd0| 52 20 20 20 20 20 20 50 | 4f 53 49 54 49 4f 4e 28 |R P|OSITION(|
|00003be0| 32 30 3a 32 33 29 20 49 | 4e 54 45 47 45 52 20 45 |20:23) I|NTEGER E|
|00003bf0| 58 54 45 52 4e 41 4c 29 | 0a 0a 49 4e 54 4f 20 54 |XTERNAL)|..INTO T|
|00003c00| 41 42 4c 45 20 50 52 4f | 4a 0a 2d 2d 20 50 52 4f |ABLE PRO|J.-- PRO|
|00003c10| 4a 20 68 61 73 20 74 77 | 6f 20 63 6f 6c 75 6d 6e |J has tw|o column|
|00003c20| 73 2c 20 62 6f 74 68 20 | 6e 6f 74 20 6e 75 6c 6c |s, both |not null|
|00003c30| 3a 20 45 4d 50 4e 4f 20 | 61 6e 64 20 50 52 4f 4a |: EMPNO |and PROJ|
|00003c40| 4e 4f 0a 57 48 45 4e 20 | 50 52 4f 4a 4e 4f 20 21 |NO.WHEN |PROJNO !|
|00003c50| 3d 20 27 20 20 20 27 0a | 20 20 28 45 4d 50 4e 4f |= ' '.| (EMPNO|
|00003c60| 20 20 20 20 50 4f 53 49 | 54 49 4f 4e 28 31 3a 34 | POSI|TION(1:4|
|00003c70| 29 20 20 20 49 4e 54 45 | 47 45 52 20 45 58 54 45 |) INTE|GER EXTE|
|00003c80| 52 4e 41 4c 2c 0a 20 20 | 20 50 52 4f 4a 4e 4f 20 |RNAL,. | PROJNO |
|00003c90| 20 20 50 4f 53 49 54 49 | 4f 4e 28 32 35 3a 32 37 | POSITI|ON(25:27|
|00003ca0| 29 20 49 4e 54 45 47 45 | 52 20 45 58 54 45 52 4e |) INTEGE|R EXTERN|
|00003cb0| 41 4c 29 20 20 20 2d 2d | 20 31 73 74 20 70 72 6f |AL) --| 1st pro|
|00003cc0| 6a 0a 0a 49 4e 54 4f 20 | 54 41 42 4c 45 20 50 52 |j..INTO |TABLE PR|
|00003cd0| 4f 4a 0a 57 48 45 4e 20 | 50 52 4f 4a 4e 4f 20 21 |OJ.WHEN |PROJNO !|
|00003ce0| 3d 20 27 20 20 20 27 0a | 20 20 28 45 4d 50 4e 4f |= ' '.| (EMPNO|
|00003cf0| 20 20 20 20 50 4f 53 49 | 54 49 4f 4e 28 31 3a 34 | POSI|TION(1:4|
|00003d00| 29 20 20 20 49 4e 54 45 | 47 45 52 20 45 58 54 45 |) INTE|GER EXTE|
|00003d10| 52 4e 41 4c 2c 0a 20 20 | 20 50 52 4f 4a 4e 4f 20 |RNAL,. | PROJNO |
|00003d20| 20 20 50 4f 53 49 54 49 | 4f 4e 28 32 39 3a 33 31 | POSITI|ON(29:31|
|00003d30| 29 20 49 4e 54 45 47 45 | 52 20 45 58 54 45 52 4e |) INTEGE|R EXTERN|
|00003d40| 41 4c 29 20 20 20 2d 2d | 20 32 6e 64 20 70 72 6f |AL) --| 2nd pro|
|00003d50| 6a 0a 0a 49 4e 54 4f 20 | 54 41 42 4c 45 20 50 52 |j..INTO |TABLE PR|
|00003d60| 4f 4a 0a 57 48 45 4e 20 | 50 52 4f 4a 4e 4f 20 21 |OJ.WHEN |PROJNO !|
|00003d70| 3d 20 27 20 20 20 27 0a | 20 20 28 45 4d 50 4e 4f |= ' '.| (EMPNO|
|00003d80| 20 20 20 20 50 4f 53 49 | 54 49 4f 4e 28 31 3a 34 | POSI|TION(1:4|
|00003d90| 29 20 20 20 49 4e 54 45 | 47 45 52 20 45 58 54 45 |) INTE|GER EXTE|
|00003da0| 52 4e 41 4c 2c 0a 20 20 | 20 50 52 4f 4a 4e 4f 20 |RNAL,. | PROJNO |
|00003db0| 20 20 50 4f 53 49 54 49 | 4f 4e 28 33 33 3a 33 35 | POSITI|ON(33:35|
|00003dc0| 29 20 49 4e 54 45 47 45 | 52 20 45 58 54 45 52 4e |) INTEGE|R EXTERN|
|00003dd0| 41 4c 29 20 20 20 2d 2d | 20 33 72 64 20 70 72 6f |AL) --| 3rd pro|
|00003de0| 6a 09 0a 30 37 30 37 30 | 37 30 30 30 34 35 30 30 |j..07070|70004500|
|00003df0| 30 37 37 35 36 31 30 30 | 36 34 34 30 30 30 33 31 |07756100|64400031|
|00003e00| 31 30 30 30 30 36 32 30 | 30 30 30 30 31 30 30 30 |10000620|00001000|
|00003e10| 30 30 30 30 34 37 36 34 | 35 37 34 30 34 30 30 30 |00004764|57404000|
|00003e20| 30 30 31 37 30 30 30 30 | 30 30 30 30 36 34 32 64 |00170000|0000642d|
|00003e30| 65 6d 6f 2f 63 61 73 65 | 35 2e 64 61 74 00 31 32 |emo/case|5.dat.12|
|00003e40| 33 34 20 42 41 4b 45 52 | 20 20 20 20 20 20 31 30 |34 BAKER| 10|
|00003e50| 20 39 39 39 39 20 31 30 | 31 20 31 30 32 20 31 30 | 9999 10|1 102 10|
|00003e60| 33 0a 31 32 33 34 20 4a | 4f 4b 45 52 20 20 20 20 |3.1234 J|OKER |
|00003e70| 20 20 31 30 20 39 39 39 | 39 20 37 37 37 20 38 38 | 10 999|9 777 88|
|00003e80| 38 20 39 39 39 0a 32 36 | 36 34 20 59 4f 55 4e 47 |8 999.26|64 YOUNG|
|00003e90| 20 20 20 20 20 20 32 30 | 20 32 38 39 33 20 34 32 | 20| 2893 42|
|00003ea0| 35 20 61 62 63 20 31 30 | 32 0a 35 33 32 31 20 4f |5 abc 10|2.5321 O|
|00003eb0| 54 4f 4f 4c 45 20 20 20 | 20 20 31 30 20 39 39 39 |TOOLE | 10 999|
|00003ec0| 39 20 33 32 31 20 20 35 | 35 20 20 34 30 0a 32 31 |9 321 5|5 40.21|
|00003ed0| 33 34 20 46 41 52 4d 45 | 52 20 20 20 20 20 32 30 |34 FARME|R 20|
|00003ee0| 20 34 35 35 35 20 32 33 | 36 20 34 35 36 0a 32 34 | 4555 23|6 456.24|
|00003ef0| 31 34 20 4c 49 54 54 4c | 45 20 20 20 20 20 32 30 |14 LITTL|E 20|
|00003f00| 20 35 36 33 34 20 32 33 | 36 20 34 35 36 20 20 34 | 5634 23|6 456 4|
|00003f10| 30 0a 36 35 34 32 20 4c | 45 45 20 20 20 20 20 20 |0.6542 L|EE |
|00003f20| 20 20 31 30 20 34 35 33 | 32 20 31 30 32 20 33 32 | 10 453|2 102 32|
|00003f30| 31 20 20 31 34 0a 32 38 | 34 39 20 45 44 44 53 20 |1 14.28|49 EDDS |
|00003f40| 20 20 20 20 20 20 78 78 | 20 34 35 35 35 20 20 20 | xx| 4555 |
|00003f50| 20 20 32 39 34 20 20 34 | 30 0a 34 35 33 32 20 50 | 294 4|0.4532 P|
|00003f60| 45 52 4b 49 4e 53 20 20 | 20 20 31 30 20 39 39 39 |ERKINS | 10 999|
|00003f70| 39 20 20 34 30 0a 31 32 | 34 34 20 48 55 4e 54 20 |9 40.12|44 HUNT |
|00003f80| 20 20 20 20 20 20 31 31 | 20 33 34 35 32 20 36 36 | 11| 3452 66|
|00003f90| 35 20 31 33 33 20 34 35 | 36 0a 20 31 32 33 20 44 |5 133 45|6. 123 D|
|00003fa0| 4f 4f 4c 49 54 54 4c 45 | 20 20 31 32 20 39 39 34 |OOLITTLE| 12 994|
|00003fb0| 30 20 20 20 20 20 20 20 | 20 20 31 33 32 0a 31 34 |0 | 132.14|
|00003fc0| 35 33 20 4d 41 43 44 4f | 4e 41 4c 44 20 20 32 35 |53 MACDO|NALD 25|
|00003fd0| 20 35 35 33 32 20 20 20 | 20 20 32 30 30 20 20 0a | 5532 | 200 .|
|00003fe0| 30 37 30 37 30 37 30 30 | 30 34 35 30 30 30 37 37 |07070700|04500077|
|00003ff0| 35 37 31 30 30 36 34 34 | 30 30 30 33 31 31 30 30 |57100644|00031100|
|00004000| 30 30 36 32 30 30 30 30 | 30 31 30 30 30 30 30 30 |00620000|01000000|
|00004010| 30 34 37 36 34 35 37 34 | 30 34 30 30 30 30 30 31 |04764574|04000001|
|00004020| 37 30 30 30 30 30 30 30 | 33 31 30 34 64 65 6d 6f |70000000|3104demo|
|00004030| 2f 63 61 73 65 31 2e 6c | 6f 67 00 0a 53 51 4c 2a |/case1.l|og..SQL*|
|00004040| 4c 6f 61 64 65 72 3a 20 | 56 65 72 73 69 6f 6e 20 |Loader: |Version |
|00004050| 31 2e 30 2e 31 38 20 2d | 20 50 72 6f 64 75 63 74 |1.0.18 -| Product|
|00004060| 69 6f 6e 20 6f 6e 20 53 | 61 74 20 44 65 63 20 31 |ion on S|at Dec 1|
|00004070| 35 20 30 36 3a 32 32 3a | 31 34 20 31 39 39 30 0a |5 06:22:|14 1990.|
|00004080| 0a 43 6f 70 79 72 69 67 | 68 74 20 28 63 29 20 4f |.Copyrig|ht (c) O|
|00004090| 72 61 63 6c 65 20 43 6f | 72 70 6f 72 61 74 69 6f |racle Co|rporatio|
|000040a0| 6e 20 31 39 37 39 2c 20 | 31 39 38 39 2e 20 20 41 |n 1979, |1989. A|
|000040b0| 6c 6c 20 72 69 67 68 74 | 73 20 72 65 73 65 72 76 |ll right|s reserv|
|000040c0| 65 64 2e 0a 0a 43 6f 6e | 74 72 6f 6c 20 46 69 6c |ed...Con|trol Fil|
|000040d0| 65 3a 20 20 20 63 61 73 | 65 31 2e 63 74 6c 0a 44 |e: cas|e1.ctl.D|
|000040e0| 61 74 61 20 46 69 6c 65 | 3a 20 20 20 20 20 20 2a |ata File|: *|
|000040f0| 0a 20 20 52 65 61 64 20 | 4d 6f 64 65 3a 20 20 20 |. Read |Mode: |
|00004100| 20 53 79 73 74 65 6d 20 | 52 65 63 6f 72 64 0a 20 | System |Record. |
|00004110| 20 42 61 64 20 46 69 6c | 65 3a 20 20 20 20 20 63 | Bad Fil|e: c|
|00004120| 61 73 65 31 2e 62 61 64 | 0a 20 20 44 69 73 63 61 |ase1.bad|. Disca|
|00004130| 72 64 20 46 69 6c 65 3a | 20 20 6e 6f 6e 65 20 73 |rd File:| none s|
|00004140| 70 65 63 69 66 69 65 64 | 0a 0a 4e 75 6d 62 65 72 |pecified|..Number|
|00004150| 20 74 6f 20 6c 6f 61 64 | 3a 20 41 4c 4c 0a 4e 75 | to load|: ALL.Nu|
|00004160| 6d 62 65 72 20 74 6f 20 | 73 6b 69 70 3a 20 30 0a |mber to |skip: 0.|
|00004170| 45 72 72 6f 72 73 20 61 | 6c 6c 6f 77 65 64 3a 20 |Errors a|llowed: |
|00004180| 35 30 0a 42 69 6e 64 20 | 61 72 72 61 79 3a 20 20 |50.Bind |array: |
|00004190| 20 20 20 36 34 20 72 6f | 77 73 2c 20 6d 61 78 69 | 64 ro|ws, maxi|
|000041a0| 6d 75 6d 20 6f 66 20 36 | 35 33 33 36 20 62 79 74 |mum of 6|5336 byt|
|000041b0| 65 73 0a 52 65 63 6f 72 | 64 20 4c 65 6e 67 74 68 |es.Recor|d Length|
|000041c0| 3a 20 20 37 33 30 20 28 | 42 75 66 66 65 72 20 73 |: 730 (|Buffer s|
|000041d0| 69 7a 65 20 61 6c 6c 6f | 63 61 74 65 64 20 70 65 |ize allo|cated pe|
|000041e0| 72 20 6c 6f 67 69 63 61 | 6c 20 72 65 63 6f 72 64 |r logica|l record|
|000041f0| 29 0a 43 6f 6e 74 69 6e | 75 61 74 69 6f 6e 3a 20 |).Contin|uation: |
|00004200| 20 20 20 6e 6f 6e 65 20 | 73 70 65 63 69 66 69 65 | none |specifie|
|00004210| 64 0a 0a 54 61 62 6c 65 | 20 44 45 50 54 2c 20 6c |d..Table| DEPT, l|
|00004220| 6f 61 64 65 64 20 66 72 | 6f 6d 20 65 76 65 72 79 |oaded fr|om every|
|00004230| 20 6c 6f 67 69 63 61 6c | 20 72 65 63 6f 72 64 2e | logical| record.|
|00004240| 0a 49 6e 73 65 72 74 20 | 6f 70 74 69 6f 6e 20 69 |.Insert |option i|
|00004250| 6e 20 65 66 66 65 63 74 | 20 66 6f 72 20 74 68 69 |n effect| for thi|
|00004260| 73 20 74 61 62 6c 65 3a | 20 49 4e 53 45 52 54 0a |s table:| INSERT.|
|00004270| 0a 20 20 20 43 6f 6c 75 | 6d 6e 20 4e 61 6d 65 20 |. Colu|mn Name |
|00004280| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00004290| 20 50 6f 73 69 74 69 6f | 6e 20 20 20 4c 65 6e 20 | Positio|n Len |
|000042a0| 20 54 65 72 6d 20 45 6e | 63 6c 20 44 61 74 61 74 | Term En|cl Datat|
|000042b0| 79 70 65 0a 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |ype.----|--------|
|000042c0| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|000042d0| 2d 2d 20 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 20 2d 2d |-- -----|----- --|
|000042e0| 2d 2d 2d 20 2d 2d 2d 2d | 20 2d 2d 2d 2d 20 2d 2d |--- ----| ---- --|
|000042f0| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|00004300| 2d 2d 2d 0a 44 45 50 54 | 4e 4f 20 20 20 20 20 20 |---.DEPT|NO |
|00004310| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00004320| 20 20 20 20 20 20 20 20 | 46 49 52 53 54 20 20 20 | |FIRST |
|00004330| 20 20 2a 20 20 20 2c 20 | 20 4f 28 22 29 20 43 48 | * , | O(") CH|
|00004340| 41 52 41 43 54 45 52 20 | 20 20 20 20 20 20 20 20 |ARACTER | |
|00004350| 20 20 20 0a 44 4e 41 4d | 45 20 20 20 20 20 20 20 | .DNAM|E |
|00004360| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00004370| 20 20 20 20 20 20 20 20 | 20 4e 45 58 54 20 20 20 | | NEXT |
|00004380| 20 20 2a 20 20 20 2c 20 | 20 4f 28 22 29 20 43 48 | * , | O(") CH|
|00004390| 41 52 41 43 54 45 52 20 | 20 20 20 20 20 20 20 20 |ARACTER | |
|000043a0| 20 20 20 0a 4c 4f 43 20 | 20 20 20 20 20 20 20 20 | .LOC | |
|000043b0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|000043c0| 20 20 20 20 20 20 20 20 | 20 4e 45 58 54 20 20 20 | | NEXT |
|000043d0| 20 20 2a 20 20 57 48 54 | 20 4f 28 22 29 20 43 48 | * WHT| O(") CH|
|000043e0| 41 52 41 43 54 45 52 20 | 20 20 20 20 20 20 20 20 |ARACTER | |
|000043f0| 20 20 20 0a 0a 0a 54 61 | 62 6c 65 20 44 45 50 54 | ...Ta|ble DEPT|
|00004400| 3a 0a 20 20 37 20 52 6f | 77 73 20 73 75 63 63 65 |:. 7 Ro|ws succe|
|00004410| 73 73 66 75 6c 6c 79 20 | 6c 6f 61 64 65 64 2e 0a |ssfully |loaded..|
|00004420| 20 20 30 20 52 6f 77 73 | 20 6e 6f 74 20 6c 6f 61 | 0 Rows| not loa|
|00004430| 64 65 64 20 64 75 65 20 | 74 6f 20 64 61 74 61 20 |ded due |to data |
|00004440| 65 72 72 6f 72 73 2e 0a | 20 20 30 20 52 6f 77 73 |errors..| 0 Rows|
|00004450| 20 6e 6f 74 20 6c 6f 61 | 64 65 64 20 62 65 63 61 | not loa|ded beca|
|00004460| 75 73 65 20 61 6c 6c 20 | 57 48 45 4e 20 63 6c 61 |use all |WHEN cla|
|00004470| 75 73 65 73 20 77 65 72 | 65 20 66 61 69 6c 65 64 |uses wer|e failed|
|00004480| 2e 0a 20 20 30 20 52 6f | 77 73 20 6e 6f 74 20 6c |.. 0 Ro|ws not l|
|00004490| 6f 61 64 65 64 20 62 65 | 63 61 75 73 65 20 61 6c |oaded be|cause al|
|000044a0| 6c 20 66 69 65 6c 64 73 | 20 77 65 72 65 20 6e 75 |l fields| were nu|
|000044b0| 6c 6c 2e 0a 0a 53 70 61 | 63 65 20 61 6c 6c 6f 63 |ll...Spa|ce alloc|
|000044c0| 61 74 65 64 20 66 6f 72 | 20 62 69 6e 64 20 61 72 |ated for| bind ar|
|000044d0| 72 61 79 3a 20 20 20 20 | 34 36 38 34 38 20 6c 62 |ray: |46848 lb|
|000044e0| 79 74 65 73 20 28 36 34 | 20 72 6f 77 73 29 0a 53 |ytes (64| rows).S|
|000044f0| 70 61 63 65 20 6f 74 68 | 65 72 77 69 73 65 20 61 |pace oth|erwise a|
|00004500| 6c 6c 6f 63 61 74 65 64 | 3a 20 20 20 20 20 20 20 |llocated|: |
|00004510| 20 20 34 38 33 34 30 20 | 62 79 74 65 73 0a 0a 54 | 48340 |bytes..T|
|00004520| 6f 74 61 6c 20 6c 6f 67 | 69 63 61 6c 20 72 65 63 |otal log|ical rec|
|00004530| 6f 72 64 73 20 73 6b 69 | 70 70 65 64 3a 20 20 20 |ords ski|pped: |
|00004540| 20 20 20 20 20 20 20 30 | 0a 54 6f 74 61 6c 20 6c | 0|.Total l|
|00004550| 6f 67 69 63 61 6c 20 72 | 65 63 6f 72 64 73 20 72 |ogical r|ecords r|
|00004560| 65 61 64 3a 20 20 20 20 | 20 20 20 20 20 20 20 20 |ead: | |
|00004570| 20 37 0a 54 6f 74 61 6c | 20 6c 6f 67 69 63 61 6c | 7.Total| logical|
|00004580| 20 72 65 63 6f 72 64 73 | 20 72 65 6a 65 63 74 65 | records| rejecte|
|00004590| 64 3a 20 20 20 20 20 20 | 20 20 20 30 0a 54 6f 74 |d: | 0.Tot|
|000045a0| 61 6c 20 6c 6f 67 69 63 | 61 6c 20 72 65 63 6f 72 |al logic|al recor|
|000045b0| 64 73 20 64 69 73 63 61 | 72 64 65 64 3a 20 20 20 |ds disca|rded: |
|000045c0| 20 20 20 20 20 30 0a 0a | 52 75 6e 20 62 65 67 61 | 0..|Run bega|
|000045d0| 6e 20 6f 6e 20 53 61 74 | 20 44 65 63 20 31 35 20 |n on Sat| Dec 15 |
|000045e0| 30 36 3a 32 32 3a 31 34 | 20 31 39 39 30 0a 52 75 |06:22:14| 1990.Ru|
|000045f0| 6e 20 65 6e 64 65 64 20 | 6f 6e 20 53 61 74 20 44 |n ended |on Sat D|
|00004600| 65 63 20 31 35 20 30 36 | 3a 32 32 3a 31 36 20 31 |ec 15 06|:22:16 1|
|00004610| 39 39 30 0a 0a 45 6c 61 | 70 73 65 64 20 74 69 6d |990..Ela|psed tim|
|00004620| 65 20 77 61 73 3a 20 20 | 20 20 20 30 30 3a 30 30 |e was: | 00:00|
|00004630| 3a 30 31 2e 33 38 0a 43 | 50 55 20 74 69 6d 65 20 |:01.38.C|PU time |
|00004640| 77 61 73 3a 20 20 20 20 | 20 20 20 20 20 30 30 3a |was: | 00:|
|00004650| 30 30 3a 30 30 2e 31 36 | 20 20 20 20 20 28 4d 61 |00:00.16| (Ma|
|00004660| 79 20 6e 6f 74 20 69 6e | 63 6c 75 64 65 20 4f 72 |y not in|clude Or|
|00004670| 61 63 6c 65 20 43 50 55 | 20 74 69 6d 65 29 0a 30 |acle CPU| time).0|
|00004680| 37 30 37 30 37 30 30 30 | 34 35 30 30 30 37 37 36 |70707000|45000776|
|00004690| 30 31 30 30 36 34 34 30 | 30 30 33 31 31 30 30 30 |01006440|00311000|
|000046a0| 30 36 32 30 30 30 30 30 | 31 30 30 30 30 30 30 30 |06200000|10000000|
|000046b0| 34 37 36 34 35 37 34 30 | 34 30 30 30 30 30 31 37 |47645740|40000017|
|000046c0| 30 30 30 30 30 30 30 30 | 30 30 30 64 65 6d 6f 2f |00000000|000demo/|
|000046d0| 63 61 73 65 31 2e 62 61 | 64 00 30 37 30 37 30 37 |case1.ba|d.070707|
|000046e0| 30 30 30 34 35 30 30 30 | 37 37 36 31 31 30 30 36 |00045000|77611006|
|000046f0| 34 34 30 30 30 33 31 31 | 30 30 30 30 36 32 30 30 |44000311|00006200|
|00004700| 30 30 30 31 30 30 30 30 | 30 30 30 34 37 36 34 35 |00010000|00047645|
|00004710| 37 34 30 34 30 30 30 30 | 30 31 37 30 30 30 30 30 |74040000|01700000|
|00004720| 30 30 31 34 33 37 64 65 | 6d 6f 2f 63 61 73 65 31 |001437de|mo/case1|
|00004730| 2e 6f 75 74 00 53 51 4c | 3e 20 73 65 74 20 65 63 |.out.SQL|> set ec|
|00004740| 68 6f 20 6f 6e 0a 53 51 | 4c 3e 20 73 65 6c 65 63 |ho on.SQ|L> selec|
|00004750| 74 20 2a 20 66 72 6f 6d | 20 64 65 70 74 3b 0a 0a |t * from| dept;..|
|00004760| 20 20 20 20 44 45 50 54 | 4e 4f 20 44 4e 41 4d 45 | DEPT|NO DNAME|
|00004770| 20 20 20 20 20 20 20 20 | 20 20 4c 4f 43 20 20 20 | | LOC |
|00004780| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00004790| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|000047a0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|000047b0| 0a 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 20 2d 2d 2d 2d |.-------|--- ----|
|000047c0| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 20 2d 2d 2d 2d 2d |--------|-- -----|
|000047d0| 2d 2d 2d 2d 2d 2d 2d 2d | 20 20 20 20 20 20 20 20 |--------| |
|000047e0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|000047f0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00004800| 20 0a 20 20 20 20 20 20 | 20 20 31 32 20 52 45 53 | . | 12 RES|
|00004810| 45 41 52 43 48 20 20 20 | 20 20 20 20 53 41 52 41 |EARCH | SARA|
|00004820| 54 4f 47 41 20 20 20 20 | 20 20 20 20 20 20 20 20 |TOGA | |
|00004830| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00004840| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00004850| 20 20 0a 20 20 20 20 20 | 20 20 20 31 30 20 41 43 | . | 10 AC|
|00004860| 43 4f 55 4e 54 49 4e 47 | 20 20 20 20 20 43 4c 45 |COUNTING| CLE|
|00004870| 56 45 4c 41 4e 44 20 20 | 20 20 20 20 20 20 20 20 |VELAND | |
|00004880| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00004890| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|000048a0| 20 20 20 0a 20 20 20 20 | 20 20 20 20 31 31 20 41 | . | 11 A|
|000048b0| 52 54 20 20 20 20 20 20 | 20 20 20 20 20 20 53 41 |RT | SA|
|000048c0| 4c 45 4d 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |LEM | |
|000048d0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|000048e0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|000048f0| 20 20 20 20 0a 20 20 20 | 20 20 20 20 20 31 33 20 | . | 13 |
|00004900| 46 49 4e 41 4e 43 45 20 | 20 20 20 20 20 20 20 42 |FINANCE | B|
|00004910| 4f 53 54 4f 4e 20 20 20 | 20 20 20 20 20 20 20 20 |OSTON | |
|00004920| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00004930| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00004940| 20 20 20 20 20 0a 20 20 | 20 20 20 20 20 20 32 31 | . | 21|
|00004950| 20 53 41 4c 45 53 20 20 | 20 20 20 20 20 20 20 20 | SALES | |
|00004960| 50 48 49 4c 41 2e 20 20 | 20 20 20 20 20 20 20 20 |PHILA. | |
|00004970| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00004980| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00004990| 20 20 20 20 20 20 0a 20 | 20 20 20 20 20 20 20 32 | . | 2|
|000049a0| 32 20 53 41 4c 45 53 20 | 20 20 20 20 20 20 20 20 |2 SALES | |
|000049b0| 20 52 4f 43 48 45 53 54 | 45 52 20 20 20 20 20 20 | ROCHEST|ER |
|000049c0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|000049d0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|000049e0| 20 20 20 20 20 20 20 0a | 20 20 20 20 20 20 20 20 | .| |
|000049f0| 34 32 20 49 4e 54 27 4c | 20 20 20 20 20 20 20 20 |42 INT'L| |
|00004a00| 20 20 53 41 4e 20 46 52 | 41 4e 20 20 20 20 20 20 | SAN FR|AN |
|00004a10| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00004a20| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00004a30| 20 20 20 20 20 20 20 20 | 0a 0a 37 20 72 65 63 6f | |..7 reco|
|00004a40| 72 64 73 20 73 65 6c 65 | 63 74 65 64 2e 0a 0a 53 |rds sele|cted...S|
|00004a50| 51 4c 3e 20 30 37 30 37 | 30 37 30 30 30 34 35 30 |QL> 0707|07000450|
|00004a60| 30 30 37 37 36 32 30 34 | 30 37 37 37 30 30 30 33 |00776204|07770003|
|00004a70| 31 31 30 30 30 30 36 32 | 30 30 30 30 30 32 30 30 |11000062|00000200|
|00004a80| 30 30 30 30 30 34 37 36 | 34 35 37 34 30 34 34 30 |00000476|45740440|
|00004a90| 30 30 30 31 30 30 30 30 | 30 30 30 30 30 30 30 30 |00010000|00000000|
|00004aa0| 69 6e 73 74 61 6c 6c 00 | 30 37 30 37 30 37 30 30 |install.|07070700|
|00004ab0| 30 34 35 30 30 30 37 37 | 36 35 31 30 30 35 35 34 |04500077|65100554|
|00004ac0| 30 30 30 33 31 31 30 30 | 30 30 36 32 30 30 30 30 |00031100|00620000|
|00004ad0| 30 31 30 30 30 30 30 30 | 30 34 37 36 34 35 37 34 |01000000|04764574|
|00004ae0| 30 34 31 30 30 30 30 32 | 34 30 30 30 30 30 30 30 |04100002|40000000|
|00004af0| 30 37 33 32 69 6e 73 74 | 61 6c 6c 2f 4c 4f 41 44 |0732inst|all/LOAD|
|00004b00| 45 52 2e 44 49 53 54 00 | 0a 2e 2f 6c 6f 61 64 65 |ER.DIST.|../loade|
|00004b10| 72 2f 64 65 6d 6f 2f 63 | 61 73 65 2e 73 71 6c 0a |r/demo/c|ase.sql.|
|00004b20| 2e 2f 6c 6f 61 64 65 72 | 2f 64 65 6d 6f 2f 63 61 |./loader|/demo/ca|
|00004b30| 73 65 31 2e 63 74 6c 0a | 2e 2f 6c 6f 61 64 65 72 |se1.ctl.|./loader|
|00004b40| 2f 64 65 6d 6f 2f 63 61 | 73 65 31 2e 64 61 74 0a |/demo/ca|se1.dat.|
|00004b50| 2e 2f 6c 6f 61 64 65 72 | 2f 64 65 6d 6f 2f 63 61 |./loader|/demo/ca|
|00004b60| 73 65 32 2e 63 74 6c 0a | 2e 2f 6c 6f 61 64 65 72 |se2.ctl.|./loader|
|00004b70| 2f 64 65 6d 6f 2f 63 61 | 73 65 32 2e 64 61 74 0a |/demo/ca|se2.dat.|
|00004b80| 2e 2f 6c 6f 61 64 65 72 | 2f 64 65 6d 6f 2f 63 61 |./loader|/demo/ca|
|00004b90| 73 65 33 2e 63 74 6c 0a | 2e 2f 6c 6f 61 64 65 72 |se3.ctl.|./loader|
|00004ba0| 2f 64 65 6d 6f 2f 63 61 | 73 65 33 2e 64 61 74 0a |/demo/ca|se3.dat.|
|00004bb0| 2e 2f 6c 6f 61 64 65 72 | 2f 64 65 6d 6f 2f 63 61 |./loader|/demo/ca|
|00004bc0| 73 65 34 2e 63 74 6c 0a | 2e 2f 6c 6f 61 64 65 72 |se4.ctl.|./loader|
|00004bd0| 2f 64 65 6d 6f 2f 63 61 | 73 65 34 2e 64 61 74 0a |/demo/ca|se4.dat.|
|00004be0| 2e 2f 6c 6f 61 64 65 72 | 2f 64 65 6d 6f 2f 63 61 |./loader|/demo/ca|
|00004bf0| 73 65 35 2e 63 74 6c 0a | 2e 2f 6c 6f 61 64 65 72 |se5.ctl.|./loader|
|00004c00| 2f 64 65 6d 6f 2f 63 61 | 73 65 35 2e 64 61 74 0a |/demo/ca|se5.dat.|
|00004c10| 2e 2f 6c 6f 61 64 65 72 | 2f 69 6e 73 74 61 6c 6c |./loader|/install|
|00004c20| 2f 4c 4f 41 44 45 52 2e | 44 49 53 54 0a 2e 2f 6c |/LOADER.|DIST../l|
|00004c30| 6f 61 64 65 72 2f 69 6e | 73 74 61 6c 6c 2f 6c 6f |oader/in|stall/lo|
|00004c40| 61 64 65 72 2e 69 6e 73 | 74 61 6c 6c 0a 2e 2f 6c |ader.ins|tall../l|
|00004c50| 6f 61 64 65 72 2f 69 6e | 73 74 61 6c 6c 2f 6c 6f |oader/in|stall/lo|
|00004c60| 61 64 65 72 2e 6b 65 79 | 0a 2e 2f 6c 6f 61 64 65 |ader.key|../loade|
|00004c70| 72 2f 69 6e 73 74 61 6c | 6c 2f 6c 6f 61 64 65 72 |r/instal|l/loader|
|00004c80| 2e 76 65 72 69 66 79 0a | 2e 2f 6c 6f 61 64 65 72 |.verify.|./loader|
|00004c90| 2f 6d 61 6e 2f 73 71 6c | 6c 6f 61 64 2e 6c 0a 0a |/man/sql|load.l..|
|00004ca0| 2e 2f 6c 6f 61 64 65 72 | 2f 6c 69 62 2f 73 71 6c |./loader|/lib/sql|
|00004cb0| 6c 6f 61 64 65 72 2e 6d | 6b 0a 2e 2f 6c 6f 61 64 |loader.m|k../load|
|00004cc0| 65 72 2f 6c 69 62 2f 6c | 69 62 6c 6f 61 64 65 72 |er/lib/l|ibloader|
|00004cd0| 2e 61 0a 0a 2e 2f 62 69 | 6e 2f 73 71 6c 6c 6f 61 |.a.../bi|n/sqlloa|
|00004ce0| 64 0a 30 37 30 37 30 37 | 30 30 30 34 35 30 30 30 |d.070707|00045000|
|00004cf0| 37 37 36 36 31 30 30 35 | 35 34 30 30 30 33 31 31 |77661005|54000311|
|00004d00| 30 30 30 30 36 32 30 30 | 30 30 30 31 30 30 30 30 |00006200|00010000|
|00004d10| 30 30 30 34 37 36 34 35 | 37 34 30 34 33 30 30 30 |00047645|74043000|
|00004d20| 30 32 37 30 30 30 30 30 | 30 30 34 36 35 35 69 6e |02700000|004655in|
|00004d30| 73 74 61 6c 6c 2f 6c 6f | 61 64 65 72 2e 69 6e 73 |stall/lo|ader.ins|
|00004d40| 74 61 6c 6c 00 3a 0a 23 | 20 0a 23 20 24 48 65 61 |tall.:.#| .# $Hea|
|00004d50| 64 65 72 3a 20 6c 6f 61 | 64 65 72 2e 69 6e 2e 70 |der: loa|der.in.p|
|00004d60| 70 2c 76 20 36 2e 31 38 | 20 38 39 2f 30 38 2f 30 |p,v 6.18| 89/08/0|
|00004d70| 33 20 31 39 3a 30 38 3a | 34 32 20 72 61 66 73 61 |3 19:08:|42 rafsa|
|00004d80| 72 69 66 20 45 78 70 20 | 24 20 6c 6f 61 64 65 72 |rif Exp |$ loader|
|00004d90| 2e 69 6e 2e 70 70 0a 23 | 0a 23 20 20 6c 6f 61 64 |.in.pp.#|.# load|
|00004da0| 65 72 2e 69 6e 73 74 61 | 6c 6c 0a 23 0a 23 20 20 |er.insta|ll.#.# |
|00004db0| 54 68 69 73 20 69 73 20 | 74 68 65 20 69 6e 73 74 |This is |the inst|
|00004dc0| 61 6c 6c 61 74 69 6f 6e | 20 73 63 72 69 70 74 20 |allation| script |
|00004dd0| 74 6f 20 69 6e 73 74 61 | 6c 6c 20 53 51 4c 2a 4c |to insta|ll SQL*L|
|00004de0| 6f 61 64 65 72 20 6f 6e | 20 61 0a 23 20 20 55 4e |oader on| a.# UN|
|00004df0| 49 58 20 4f 52 41 43 4c | 45 20 73 79 73 74 65 6d |IX ORACL|E system|
|00004e00| 2e 0a 23 0a 23 20 20 49 | 74 20 63 61 6e 20 62 65 |..#.# I|t can be|
|00004e10| 20 69 6e 76 6f 6b 65 64 | 20 62 79 20 74 68 65 20 | invoked| by the |
|00004e20| 6d 61 73 74 65 72 20 69 | 6e 73 74 61 6c 6c 61 74 |master i|nstallat|
|00004e30| 69 6f 6e 20 73 63 72 69 | 70 74 2c 20 6f 72 61 63 |ion scri|pt, orac|
|00004e40| 6c 65 2e 69 6e 73 74 61 | 6c 6c 2c 0a 23 20 20 6f |le.insta|ll,.# o|
|00004e50| 72 20 61 73 20 61 20 73 | 74 61 6e 64 20 61 6c 6f |r as a s|tand alo|
|00004e60| 6e 65 20 70 72 6f 63 65 | 64 75 72 65 2e 0a 23 0a |ne proce|dure..#.|
|00004e70| 23 20 20 54 68 65 20 6d | 61 73 74 65 72 20 73 63 |# The m|aster sc|
|00004e80| 72 69 70 74 2c 20 6f 72 | 61 63 6c 65 2e 69 6e 73 |ript, or|acle.ins|
|00004e90| 74 61 6c 6c 2c 20 73 65 | 74 73 20 4f 52 41 43 4c |tall, se|ts ORACL|
|00004ea0| 45 5f 48 4f 4d 45 2c 20 | 0a 23 20 20 61 6e 64 20 |E_HOME, |.# and |
|00004eb0| 4c 4f 47 20 62 65 66 6f | 72 65 20 69 74 20 72 75 |LOG befo|re it ru|
|00004ec0| 6e 73 20 74 68 69 73 20 | 73 63 72 69 70 74 2e 0a |ns this |script..|
|00004ed0| 23 20 20 49 66 20 74 68 | 65 20 73 63 72 69 70 74 |# If th|e script|
|00004ee0| 20 69 73 20 72 75 6e 20 | 73 74 61 6e 64 2d 61 6c | is run |stand-al|
|00004ef0| 6f 6e 65 2c 20 74 68 65 | 6e 20 74 68 65 73 65 20 |one, the|n these |
|00004f00| 76 61 72 69 61 62 6c 65 | 73 20 6d 75 73 74 20 62 |variable|s must b|
|00004f10| 65 20 73 65 74 20 61 6e | 64 0a 23 20 20 65 78 70 |e set an|d.# exp|
|00004f20| 6f 72 74 65 64 20 62 65 | 66 6f 72 65 20 69 74 20 |orted be|fore it |
|00004f30| 69 73 20 72 75 6e 2e 0a | 23 0a 23 20 20 44 65 66 |is run..|#.# Def|
|00004f40| 61 75 6c 74 20 61 6e 73 | 77 65 72 73 20 61 72 65 |ault ans|wers are|
|00004f50| 20 73 68 6f 77 6e 20 69 | 6e 20 73 71 75 61 72 65 | shown i|n square|
|00004f60| 20 62 72 61 63 6b 65 74 | 73 2e 0a 23 0a 0a 4e 45 | bracket|s..#..NE|
|00004f70| 54 4c 49 42 4e 41 4d 45 | 3d 22 6e 73 6c 5f 73 22 |TLIBNAME|="nsl_s"|
|00004f80| 0a 50 48 59 53 5f 42 4c | 4b 5f 53 49 5a 45 3d 32 |.PHYS_BL|K_SIZE=2|
|00004f90| 30 34 38 20 20 0a 56 4e | 44 52 5f 4e 45 54 4c 49 |048 .VN|DR_NETLI|
|00004fa0| 42 53 3d 22 2d 6c 6e 73 | 6c 5f 73 20 22 0a 43 48 |BS="-lns|l_s ".CH|
|00004fb0| 4f 57 4e 3d 2f 62 69 6e | 2f 63 68 6f 77 6e 0a 4d |OWN=/bin|/chown.M|
|00004fc0| 41 4b 45 3d 6d 61 6b 65 | 20 20 20 20 20 20 20 20 |AKE=make| |
|00004fd0| 0a 4f 52 41 43 4c 45 5f | 4c 50 50 52 4f 47 3d 22 |.ORACLE_|LPPROG="|
|00004fe0| 2f 75 73 72 2f 62 69 6e | 2f 6c 70 22 0a 4f 52 41 |/usr/bin|/lp".ORA|
|00004ff0| 43 4c 45 5f 50 41 47 45 | 52 3d 22 2f 75 73 72 2f |CLE_PAGE|R="/usr/|
|00005000| 62 69 6e 2f 6d 6f 72 65 | 22 0a 4f 52 41 43 4c 45 |bin/more|".ORACLE|
|00005010| 5f 4c 50 53 54 41 54 3d | 22 2f 75 73 72 2f 62 69 |_LPSTAT=|"/usr/bi|
|00005020| 6e 2f 6c 70 73 74 61 74 | 22 0a 0a 23 0a 23 20 20 |n/lpstat|"..#.# |
|00005030| 49 6e 69 74 69 61 6c 69 | 7a 65 20 76 61 72 69 61 |Initiali|ze varia|
|00005040| 62 6c 65 73 20 75 73 65 | 64 20 69 6e 20 69 6e 73 |bles use|d in ins|
|00005050| 74 61 6c 6c 61 74 69 6f | 6e 20 73 63 72 69 70 74 |tallatio|n script|
|00005060| 2e 0a 23 0a 50 52 4f 44 | 55 43 54 3d 4c 4f 41 44 |..#.PROD|UCT=LOAD|
|00005070| 45 52 0a 70 72 6f 64 75 | 63 74 3d 6c 6f 61 64 65 |ER.produ|ct=loade|
|00005080| 72 0a 4d 4b 54 47 5f 4e | 41 4d 45 3d 53 51 4c 2a |r.MKTG_N|AME=SQL*|
|00005090| 4c 6f 61 64 65 72 0a 0a | 23 0a 23 20 20 53 65 74 |Loader..|#.# Set|
|000050a0| 75 70 20 20 74 68 65 20 | 65 6e 76 69 72 6f 6e 6d |up the |environm|
|000050b0| 65 6e 74 20 76 61 72 69 | 61 62 6c 65 73 20 66 6f |ent vari|ables fo|
|000050c0| 72 20 74 68 65 20 69 6e | 73 74 61 6c 6c 61 74 69 |r the in|stallati|
|000050d0| 6f 6e 20 73 63 72 69 70 | 74 2e 0a 23 0a 2e 20 24 |on scrip|t..#.. $|
|000050e0| 4f 52 41 43 4c 45 5f 48 | 4f 4d 45 2f 69 6e 73 74 |ORACLE_H|OME/inst|
|000050f0| 61 6c 6c 2f 73 65 74 75 | 70 2e 69 6e 73 0a 0a 23 |all/setu|p.ins..#|
|00005100| 0a 23 20 22 69 6e 73 74 | 61 6c 6c 22 20 75 73 65 |.# "inst|all" use|
|00005110| 72 20 75 74 69 6c 69 74 | 69 65 73 0a 23 0a 63 64 |r utilit|ies.#.cd|
|00005120| 20 24 4f 52 41 43 4c 45 | 5f 48 4f 4d 45 2f 62 69 | $ORACLE|_HOME/bi|
|00005130| 6e 0a 63 68 6d 6f 64 20 | 37 35 31 20 73 71 6c 6c |n.chmod |751 sqll|
|00005140| 6f 61 64 20 32 3e 2f 64 | 65 76 2f 6e 75 6c 6c 0a |oad 2>/d|ev/null.|
|00005150| 0a 23 46 49 4c 45 5f 4c | 49 53 54 3d 60 63 61 74 |.#FILE_L|IST=`cat|
|00005160| 20 24 4f 52 41 43 4c 45 | 5f 48 4f 4d 45 2f 24 7b | $ORACLE|_HOME/${|
|00005170| 70 72 6f 64 75 63 74 7d | 2f 69 6e 73 74 61 6c 6c |product}|/install|
|00005180| 2f 24 7b 50 52 4f 44 55 | 43 54 7d 2e 44 49 53 54 |/${PRODU|CT}.DIST|
|00005190| 60 0a 0a 69 66 20 5b 20 | 22 24 4c 49 4e 4b 5f 50 |`..if [ |"$LINK_P|
|000051a0| 52 4f 44 55 43 54 22 20 | 3d 20 22 54 22 20 5d 20 |RODUCT" |= "T" ] |
|000051b0| 3b 20 74 68 65 6e 0a 20 | 20 20 23 0a 20 20 20 23 |; then. | #. #|
|000051c0| 20 4c 69 6e 6b 20 73 71 | 6c 6c 6f 61 64 20 28 69 | Link sq|lload (i|
|000051d0| 6e 20 74 68 65 20 6c 69 | 62 20 64 69 72 65 63 74 |n the li|b direct|
|000051e0| 6f 72 79 29 20 61 6e 64 | 20 70 75 74 20 69 74 20 |ory) and| put it |
|000051f0| 69 6e 74 6f 20 74 68 65 | 20 62 69 6e 20 64 69 72 |into the| bin dir|
|00005200| 65 63 74 6f 72 79 2e 0a | 20 20 20 23 0a 20 20 20 |ectory..| #. |
|00005210| 63 64 20 24 4f 52 41 43 | 4c 45 5f 48 4f 4d 45 2f |cd $ORAC|LE_HOME/|
|00005220| 24 7b 70 72 6f 64 75 63 | 74 7d 2f 6c 69 62 0a 20 |${produc|t}/lib. |
|00005230| 20 20 65 63 68 6f 20 22 | 22 0a 20 20 20 65 63 68 | echo "|". ech|
|00005240| 6f 20 22 4c 69 6e 6b 69 | 6e 67 20 61 6e 64 20 69 |o "Linki|ng and i|
|00005250| 6e 73 74 61 6c 6c 69 6e | 67 20 24 4d 4b 54 47 5f |nstallin|g $MKTG_|
|00005260| 4e 41 4d 45 20 65 78 65 | 63 75 74 61 62 6c 65 73 |NAME exe|cutables|
|00005270| 2e 2e 2e 22 20 7c 20 74 | 65 65 20 2d 61 20 24 4c |..." | t|ee -a $L|
|00005280| 4f 47 0a 20 20 20 65 63 | 68 6f 20 22 22 0a 20 20 |OG. ec|ho "". |
|00005290| 20 24 4d 41 4b 45 20 2d | 66 20 73 71 6c 6c 6f 61 | $MAKE -|f sqlloa|
|000052a0| 64 65 72 2e 6d 6b 20 20 | 4f 52 41 43 4c 45 5f 48 |der.mk |ORACLE_H|
|000052b0| 4f 4d 45 3d 24 4f 52 41 | 43 4c 45 5f 48 4f 4d 45 |OME=$ORA|CLE_HOME|
|000052c0| 20 69 6e 73 74 61 6c 6c | 20 3e 3e 20 24 4c 4f 47 | install| >> $LOG|
|000052d0| 20 32 3e 26 31 0a 20 20 | 20 69 66 20 5b 20 24 3f | 2>&1. | if [ $?|
|000052e0| 20 3d 20 30 20 5d 20 3b | 20 74 68 65 6e 0a 20 20 | = 0 ] ;| then. |
|000052f0| 20 20 20 20 63 61 73 65 | 20 24 53 55 50 45 52 5f | case| $SUPER_|
|00005300| 55 53 45 52 20 69 6e 0a | 20 20 20 20 20 20 20 20 |USER in.| |
|00005310| 54 52 55 45 29 09 24 43 | 48 4f 57 4e 20 24 4f 52 |TRUE).$C|HOWN $OR|
|00005320| 41 43 4c 45 5f 4f 57 4e | 45 52 20 24 4f 52 41 43 |ACLE_OWN|ER $ORAC|
|00005330| 4c 45 5f 48 4f 4d 45 2f | 62 69 6e 2f 73 71 6c 6c |LE_HOME/|bin/sqll|
|00005340| 6f 61 64 20 3b 3b 0a 20 | 20 20 20 20 20 65 73 61 |oad ;;. | esa|
|00005350| 63 0a 20 20 20 65 6c 73 | 65 0a 20 20 20 20 20 20 |c. els|e. |
|00005360| 65 63 68 6f 20 22 0a 09 | 52 65 6c 69 6e 6b 69 6e |echo "..|Relinkin|
|00005370| 67 20 45 72 72 6f 72 2e | 0a 09 54 68 65 20 65 78 |g Error.|..The ex|
|00005380| 65 63 75 74 61 62 6c 65 | 20 66 6f 72 20 24 4d 4b |ecutable| for $MK|
|00005390| 54 47 5f 4e 41 4d 45 20 | 77 61 73 20 6e 6f 74 20 |TG_NAME |was not |
|000053a0| 6d 61 64 65 20 73 75 63 | 63 65 73 73 66 75 6c 6c |made suc|cessfull|
|000053b0| 79 2e 0a 09 50 6c 65 61 | 73 65 20 63 68 65 63 6b |y...Plea|se check|
|000053c0| 20 74 68 65 20 6c 6f 67 | 20 66 69 6c 65 2c 20 61 | the log| file, a|
|000053d0| 6e 64 20 72 65 70 65 61 | 74 20 74 68 65 20 69 6e |nd repea|t the in|
|000053e0| 73 74 61 6c 6c 61 74 69 | 6f 6e 0a 09 70 72 6f 63 |stallati|on..proc|
|000053f0| 65 64 75 72 65 20 66 6f | 72 20 24 4d 4b 54 47 5f |edure fo|r $MKTG_|
|00005400| 4e 41 4d 45 2e 0a 09 22 | 20 7c 20 74 65 65 20 2d |NAME..."| | tee -|
|00005410| 61 20 24 4c 4f 47 0a 20 | 20 20 66 69 0a 66 69 0a |a $LOG. | fi.fi.|
|00005420| 0a 23 0a 23 20 20 55 73 | 65 20 22 74 6f 75 63 68 |.#.# Us|e "touch|
|00005430| 22 20 74 6f 20 74 69 6d | 65 20 73 74 61 6d 70 20 |" to tim|e stamp |
|00005440| 68 69 64 64 65 6e 20 66 | 69 6c 65 2c 20 66 6f 72 |hidden f|ile, for|
|00005450| 20 66 75 74 75 72 65 20 | 76 65 72 69 66 69 63 61 | future |verifica|
|00005460| 74 69 6f 6e 20 6f 66 20 | 0a 23 20 20 70 72 6f 64 |tion of |.# prod|
|00005470| 75 63 74 20 69 6e 73 74 | 61 6c 6c 61 74 69 6f 6e |uct inst|allation|
|00005480| 2e 0a 74 6f 75 63 68 20 | 22 24 4f 52 41 43 4c 45 |..touch |"$ORACLE|
|00005490| 5f 48 4f 4d 45 2f 24 70 | 72 6f 64 75 63 74 2f 69 |_HOME/$p|roduct/i|
|000054a0| 6e 73 74 61 6c 6c 2f 2e | 24 70 72 6f 64 75 63 74 |nstall/.|$product|
|000054b0| 22 20 32 3e 20 2f 64 65 | 76 2f 6e 75 6c 6c 0a 0a |" 2> /de|v/null..|
|000054c0| 23 0a 23 20 20 48 6f 6f | 6b 20 66 6f 72 20 76 65 |#.# Hoo|k for ve|
|000054d0| 72 69 66 69 63 61 74 69 | 6f 6e 20 73 63 72 69 70 |rificati|on scrip|
|000054e0| 74 73 20 2d 2d 20 74 68 | 69 73 20 6d 75 73 74 20 |ts -- th|is must |
|000054f0| 68 61 70 70 65 6e 20 6c | 61 73 74 0a 23 0a 63 61 |happen l|ast.#.ca|
|00005500| 73 65 20 24 4f 52 41 43 | 4c 45 5f 56 45 52 49 46 |se $ORAC|LE_VERIF|
|00005510| 59 20 69 6e 0a 20 20 20 | 20 54 29 09 69 66 20 5b |Y in. | T).if [|
|00005520| 20 2d 66 20 24 4f 52 41 | 43 4c 45 5f 48 4f 4d 45 | -f $ORA|CLE_HOME|
|00005530| 2f 24 70 72 6f 64 75 63 | 74 2f 69 6e 73 74 61 6c |/$produc|t/instal|
|00005540| 6c 2f 24 7b 70 72 6f 64 | 75 63 74 7d 2e 76 65 72 |l/${prod|uct}.ver|
|00005550| 69 66 79 20 5d 20 3b 20 | 74 68 65 6e 0a 09 20 20 |ify ] ; |then.. |
|00005560| 20 20 4f 52 41 43 4c 45 | 5f 49 4e 53 54 41 4c 4c | ORACLE|_INSTALL|
|00005570| 3d 54 20 3b 20 65 78 70 | 6f 72 74 20 4f 52 41 43 |=T ; exp|ort ORAC|
|00005580| 4c 45 5f 49 4e 53 54 41 | 4c 4c 0a 09 20 20 20 20 |LE_INSTA|LL.. |
|00005590| 63 68 6d 6f 64 20 37 35 | 35 20 24 4f 52 41 43 4c |chmod 75|5 $ORACL|
|000055a0| 45 5f 48 4f 4d 45 2f 24 | 70 72 6f 64 75 63 74 2f |E_HOME/$|product/|
|000055b0| 69 6e 73 74 61 6c 6c 2f | 24 7b 70 72 6f 64 75 63 |install/|${produc|
|000055c0| 74 7d 2e 76 65 72 69 66 | 79 0a 09 20 20 20 20 24 |t}.verif|y.. $|
|000055d0| 4f 52 41 43 4c 45 5f 48 | 4f 4d 45 2f 24 70 72 6f |ORACLE_H|OME/$pro|
|000055e0| 64 75 63 74 2f 69 6e 73 | 74 61 6c 6c 2f 24 7b 70 |duct/ins|tall/${p|
|000055f0| 72 6f 64 75 63 74 7d 2e | 76 65 72 69 66 79 0a 09 |roduct}.|verify..|
|00005600| 66 69 20 3b 3b 0a 65 73 | 61 63 0a 0a 23 0a 23 20 |fi ;;.es|ac..#.# |
|00005610| 20 44 6f 20 61 6e 79 20 | 63 6c 65 61 6e 75 70 20 | Do any |cleanup |
|00005620| 61 6e 64 20 65 78 69 74 | 20 74 68 69 73 20 73 63 |and exit| this sc|
|00005630| 72 69 70 74 2e 0a 23 0a | 65 63 68 6f 20 22 22 0a |ript..#.|echo "".|
|00005640| 63 61 73 65 20 24 55 50 | 44 41 54 45 20 69 6e 0a |case $UP|DATE in.|
|00005650| 20 20 20 20 59 29 20 65 | 63 68 6f 20 22 24 4d 4b | Y) e|cho "$MK|
|00005660| 54 47 5f 4e 41 4d 45 20 | 75 70 64 61 74 65 20 63 |TG_NAME |update c|
|00005670| 6f 6d 70 6c 65 74 65 64 | 2e 22 20 7c 20 74 65 65 |ompleted|." | tee|
|00005680| 20 2d 61 20 24 4c 4f 47 | 20 3b 3b 0a 20 20 20 20 | -a $LOG| ;;. |
|00005690| 2a 29 20 65 63 68 6f 20 | 22 24 4d 4b 54 47 5f 4e |*) echo |"$MKTG_N|
|000056a0| 41 4d 45 20 69 6e 73 74 | 61 6c 6c 61 74 69 6f 6e |AME inst|allation|
|000056b0| 20 63 6f 6d 70 6c 65 74 | 65 64 2e 22 20 7c 20 74 | complet|ed." | t|
|000056c0| 65 65 20 2d 61 20 24 4c | 4f 47 20 3b 3b 0a 65 73 |ee -a $L|OG ;;.es|
|000056d0| 61 63 0a 65 63 68 6f 20 | 22 22 0a 73 79 6e 63 3b |ac.echo |"".sync;|
|000056e0| 73 79 6e 63 3b 73 79 6e | 63 0a 65 78 69 74 20 30 |sync;syn|c.exit 0|
|000056f0| 0a 0a 30 37 30 37 30 37 | 30 30 30 34 35 30 30 30 |..070707|00045000|
|00005700| 37 37 36 37 31 30 30 35 | 35 34 30 30 30 33 31 31 |77671005|54000311|
|00005710| 30 30 30 30 36 32 30 30 | 30 30 30 31 30 30 30 30 |00006200|00010000|
|00005720| 30 30 30 34 37 36 34 35 | 37 34 30 34 33 30 30 30 |00047645|74043000|
|00005730| 30 32 33 30 30 30 30 30 | 30 30 30 30 35 34 69 6e |02300000|000054in|
|00005740| 73 74 61 6c 6c 2f 6c 6f | 61 64 65 72 2e 6b 65 79 |stall/lo|ader.key|
|00005750| 00 37 30 3a 6c 6f 61 64 | 65 72 3a 53 51 4c 2a 4c |.70:load|er:SQL*L|
|00005760| 6f 61 64 65 72 3a 6c 6f | 61 64 65 72 2f 69 6e 73 |oader:lo|ader/ins|
|00005770| 74 61 6c 6c 2f 6c 6f 61 | 64 65 72 3a 0a 30 37 30 |tall/loa|der:.070|
|00005780| 37 30 37 30 30 30 34 35 | 30 30 30 37 37 37 30 31 |70700045|00077701|
|00005790| 30 30 35 35 34 30 30 30 | 33 31 31 30 30 30 30 36 |00554000|31100006|
|000057a0| 32 30 30 30 30 30 31 30 | 30 30 30 30 30 30 34 37 |20000010|00000047|
|000057b0| 36 34 35 37 34 30 34 34 | 30 30 30 30 32 36 30 30 |64574044|00002600|
|000057c0| 30 30 30 30 30 35 34 35 | 31 69 6e 73 74 61 6c 6c |00000545|1install|
|000057d0| 2f 6c 6f 61 64 65 72 2e | 76 65 72 69 66 79 00 3a |/loader.|verify.:|
|000057e0| 0a 23 20 0a 23 20 24 48 | 65 61 64 65 72 3a 20 6c |.# .# $H|eader: l|
|000057f0| 6f 61 64 65 72 2e 76 65 | 72 2e 70 70 2c 76 20 36 |oader.ve|r.pp,v 6|
|00005800| 2e 37 20 38 39 2f 30 33 | 2f 31 30 20 31 37 3a 35 |.7 89/03|/10 17:5|
|00005810| 34 3a 30 39 20 72 61 66 | 73 61 72 69 66 20 45 78 |4:09 raf|sarif Ex|
|00005820| 70 20 24 20 6c 6f 61 64 | 65 72 2e 76 65 72 2e 70 |p $ load|er.ver.p|
|00005830| 70 20 0a 23 20 0a 23 0a | 23 20 6c 6f 61 64 65 72 |p .# .#.|# loader|
|00005840| 2e 76 65 72 69 66 79 0a | 23 0a 23 20 54 68 69 73 |.verify.|#.# This|
|00005850| 20 73 63 72 69 70 74 20 | 64 6f 65 73 20 33 20 74 | script |does 3 t|
|00005860| 68 69 6e 67 73 20 74 6f | 20 76 65 72 69 66 79 20 |hings to| verify |
|00005870| 74 68 65 20 53 51 4c 2a | 4c 6f 61 64 65 72 20 70 |the SQL*|Loader p|
|00005880| 72 6f 64 75 63 74 3a 0a | 23 20 20 20 20 2d 20 69 |roduct:.|# - i|
|00005890| 6e 73 74 61 6c 6c 20 53 | 51 4c 2a 4c 6f 61 64 65 |nstall S|QL*Loade|
|000058a0| 72 20 69 66 20 24 4f 52 | 41 43 4c 45 5f 49 4e 53 |r if $OR|ACLE_INS|
|000058b0| 54 41 4c 4c 21 3d 54 0a | 23 20 20 20 20 20 20 20 |TALL!=T.|# |
|000058c0| 20 20 20 69 2e 65 2e 20 | 4e 4f 54 20 62 65 69 6e | i.e. |NOT bein|
|000058d0| 67 20 63 61 6c 6c 65 64 | 20 69 6e 73 69 64 65 20 |g called| inside |
|000058e0| 6c 6f 61 64 65 72 2e 69 | 6e 73 74 61 6c 6c 0a 23 |loader.i|nstall.#|
|000058f0| 20 20 20 20 2d 20 64 69 | 73 70 6c 61 79 20 62 61 | - di|splay ba|
|00005900| 6e 6e 65 72 73 20 66 6f | 72 20 73 71 6c 6c 6f 61 |nners fo|r sqlloa|
|00005910| 64 0a 23 20 20 20 20 2d | 20 69 6e 76 6f 6b 65 20 |d.# -| invoke |
|00005920| 64 65 6d 6f 3a 20 0a 23 | 20 20 20 20 20 20 20 20 |demo: .#| |
|00005930| 2a 20 63 61 73 65 31 2e | 73 71 6c 0a 23 20 20 20 |* case1.|sql.# |
|00005940| 20 20 20 20 20 20 20 28 | 54 68 69 73 20 69 73 20 | (|This is |
|00005950| 6a 75 73 74 20 61 20 56 | 45 52 59 20 73 68 6f 72 |just a V|ERY shor|
|00005960| 74 20 74 65 73 74 20 74 | 6f 20 76 65 72 69 66 79 |t test t|o verify|
|00005970| 20 74 68 61 74 0a 23 20 | 20 20 20 20 20 20 20 20 | that.# | |
|00005980| 20 20 53 51 4c 2a 4c 6f | 61 64 65 72 20 69 73 20 | SQL*Lo|ader is |
|00005990| 66 75 6e 63 74 69 6f 6e | 61 6c 2e 20 20 49 74 20 |function|al. It |
|000059a0| 69 73 20 6e 6f 74 20 74 | 72 79 69 6e 67 0a 23 20 |is not t|rying.# |
|000059b0| 20 20 20 20 20 20 20 20 | 20 20 74 6f 20 64 65 6d | | to dem|
|000059c0| 6f 6e 73 74 72 61 74 65 | 20 74 68 65 20 70 72 6f |onstrate| the pro|
|000059d0| 64 75 63 74 20 6e 6f 72 | 20 74 6f 20 71 61 20 69 |duct nor| to qa i|
|000059e0| 74 2e 29 0a 23 20 0a 23 | 20 54 68 65 20 73 63 72 |t.).# .#| The scr|
|000059f0| 69 70 74 20 69 73 20 61 | 73 73 75 6d 65 64 20 69 |ipt is a|ssumed i|
|00005a00| 74 73 65 6c 66 20 74 6f | 20 62 65 20 69 6e 20 3f |tself to| be in ?|
|00005a10| 2f 6c 6f 61 64 65 72 2f | 69 6e 73 74 61 6c 6c 0a |/loader/|install.|
|00005a20| 23 20 41 6c 6c 20 6f 75 | 74 70 75 74 20 6f 66 20 |# All ou|tput of |
|00005a30| 74 68 69 73 20 61 75 74 | 6f 6d 61 74 65 64 20 70 |this aut|omated p|
|00005a40| 72 6f 63 65 73 73 20 77 | 69 6c 6c 20 62 65 20 72 |rocess w|ill be r|
|00005a50| 65 63 6f 72 64 65 64 20 | 69 6e 20 0a 23 20 3f 2f |ecorded |in .# ?/|
|00005a60| 6c 6f 61 64 65 72 2f 69 | 6e 73 74 61 6c 6c 2f 6c |loader/i|nstall/l|
|00005a70| 6f 61 64 65 72 5f 76 65 | 72 2e 6f 75 74 0a 23 20 |oader_ve|r.out.# |
|00005a80| 0a 0a 50 52 4f 44 55 43 | 54 3d 4c 4f 41 44 45 52 |..PRODUC|T=LOADER|
|00005a90| 0a 70 72 6f 64 75 63 74 | 3d 6c 6f 61 64 65 72 0a |.product|=loader.|
|00005aa0| 4d 4b 54 47 5f 4e 41 4d | 45 3d 53 51 4c 2a 4c 6f |MKTG_NAM|E=SQL*Lo|
|00005ab0| 61 64 65 72 0a 0a 23 0a | 23 20 20 53 65 74 75 70 |ader..#.|# Setup|
|00005ac0| 20 20 74 68 65 20 65 6e | 76 69 72 6f 6e 6d 65 6e | the en|vironmen|
|00005ad0| 74 20 76 61 72 69 61 62 | 6c 65 73 20 66 6f 72 20 |t variab|les for |
|00005ae0| 74 68 65 20 76 65 72 69 | 66 69 63 61 74 69 6f 6e |the veri|fication|
|00005af0| 20 73 63 72 69 70 74 2e | 0a 23 0a 2e 20 24 4f 52 | script.|.#.. $OR|
|00005b00| 41 43 4c 45 5f 48 4f 4d | 45 2f 69 6e 73 74 61 6c |ACLE_HOM|E/instal|
|00005b10| 6c 2f 73 65 74 75 70 2e | 76 65 72 0a 0a 23 0a 23 |l/setup.|ver..#.#|
|00005b20| 23 20 31 2e 20 41 75 74 | 6f 6d 61 74 69 63 61 6c |# 1. Aut|omatical|
|00005b30| 6c 79 20 69 6e 73 74 61 | 6c 6c 20 53 51 4c 2a 4c |ly insta|ll SQL*L|
|00005b40| 6f 61 64 65 72 20 69 66 | 20 21 20 24 4f 52 41 43 |oader if| ! $ORAC|
|00005b50| 4c 45 5f 49 4e 53 54 41 | 4c 4c 2e 0a 23 20 20 20 |LE_INSTA|LL..# |
|00005b60| 20 20 20 20 20 20 20 20 | 20 20 69 2e 65 2e 20 6e | | i.e. n|
|00005b70| 6f 74 20 63 61 6c 6c 65 | 64 20 62 79 20 6c 6f 61 |ot calle|d by loa|
|00005b80| 64 65 72 2e 69 6e 73 74 | 61 6c 6c 0a 23 0a 65 63 |der.inst|all.#.ec|
|00005b90| 68 6f 20 24 4e 20 22 2e | 24 43 22 20 20 20 20 20 |ho $N ".|$C" |
|00005ba0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 23 57 | | #W|
|00005bb0| 61 69 74 20 6d 65 73 73 | 61 67 65 0a 69 66 20 74 |ait mess|age.if t|
|00005bc0| 65 73 74 20 22 24 4f 52 | 41 43 4c 45 5f 49 4e 53 |est "$OR|ACLE_INS|
|00005bd0| 54 41 4c 4c 22 20 21 3d | 20 54 0a 74 68 65 6e 0a |TALL" !=| T.then.|
|00005be0| 0a 65 63 68 6f 20 22 23 | 44 65 66 61 75 6c 74 20 |.echo "#|Default |
|00005bf0| 69 6e 73 74 61 6c 6c 20 | 6f 66 20 53 51 4c 2a 4c |install |of SQL*L|
|00005c00| 6f 61 64 65 72 3a 0a 22 | 20 3e 3e 20 24 4f 55 54 |oader:."| >> $OUT|
|00005c10| 50 55 54 0a 23 20 53 69 | 6e 63 65 20 77 65 20 61 |PUT.# Si|nce we a|
|00005c20| 72 65 20 63 61 6c 6c 69 | 6e 67 20 6c 6f 61 64 65 |re calli|ng loade|
|00005c30| 72 2e 69 6e 73 74 61 6c | 6c 20 77 69 74 68 69 6e |r.instal|l within|
|00005c40| 20 76 65 72 69 66 79 2c | 20 0a 23 20 20 20 4f 52 | verify,| .# OR|
|00005c50| 41 43 4c 45 5f 56 45 52 | 49 46 59 20 73 68 6f 75 |ACLE_VER|IFY shou|
|00005c60| 6c 64 20 62 65 20 66 61 | 6c 73 65 2e 0a 4f 52 41 |ld be fa|lse..ORA|
|00005c70| 43 4c 45 5f 56 45 52 49 | 46 59 3d 46 0a 65 78 70 |CLE_VERI|FY=F.exp|
|00005c80| 6f 72 74 20 4f 52 41 43 | 4c 45 5f 56 45 52 49 46 |ort ORAC|LE_VERIF|
|00005c90| 59 0a 23 20 65 78 69 74 | 20 69 66 20 69 6e 73 74 |Y.# exit| if inst|
|00005ca0| 61 6c 6c 20 66 61 69 6c | 73 0a 6c 6f 61 64 65 72 |all fail|s.loader|
|00005cb0| 2e 69 6e 73 74 61 6c 6c | 20 3e 3e 20 24 4f 55 54 |.install| >> $OUT|
|00005cc0| 50 55 54 20 32 3e 26 31 | 20 3c 3c 21 0a 21 0a 69 |PUT 2>&1| <<!.!.i|
|00005cd0| 66 20 74 65 73 74 20 24 | 3f 20 2d 67 74 20 30 0a |f test $|? -gt 0.|
|00005ce0| 74 68 65 6e 20 65 78 69 | 74 0a 66 69 0a 65 63 68 |then exi|t.fi.ech|
|00005cf0| 6f 20 22 0a 0a 22 20 3e | 3e 20 24 4f 55 54 50 55 |o ".." >|> $OUTPU|
|00005d00| 54 0a 65 63 68 6f 20 22 | 20 20 20 20 20 20 20 20 |T.echo "| |
|00005d10| 20 20 20 20 20 20 20 23 | 23 23 23 23 23 23 23 23 | #|########|
|00005d20| 23 23 23 23 23 23 23 23 | 23 23 23 23 23 23 23 23 |########|########|
|00005d30| 23 23 23 23 23 23 23 23 | 23 23 23 23 23 23 23 23 |########|########|
|00005d40| 0a 22 20 3e 3e 20 24 4f | 55 54 50 55 54 0a 0a 66 |." >> $O|UTPUT..f|
|00005d50| 69 0a 23 0a 23 23 20 32 | 2e 20 43 68 65 63 6b 20 |i.#.## 2|. Check |
|00005d60| 62 61 6e 6e 65 72 73 20 | 66 6f 72 20 73 71 6c 6c |banners |for sqll|
|00005d70| 6f 61 64 0a 23 20 20 20 | 20 20 20 20 20 2a 20 75 |oad.# | * u|
|00005d80| 73 65 73 20 24 4f 52 41 | 43 4c 45 5f 48 4f 4d 45 |ses $ORA|CLE_HOME|
|00005d90| 2f 69 6e 73 74 61 6c 6c | 2f 70 72 74 76 65 72 73 |/install|/prtvers|
|00005da0| 69 6f 6e 2e 73 68 0a 23 | 0a 65 63 68 6f 20 24 4e |ion.sh.#|.echo $N|
|00005db0| 20 22 2e 24 43 22 20 20 | 20 20 20 20 20 20 20 20 | ".$C" | |
|00005dc0| 20 20 20 20 20 20 20 20 | 20 23 57 61 69 74 20 6d | | #Wait m|
|00005dd0| 65 73 73 61 67 65 0a 65 | 63 68 6f 20 22 23 43 68 |essage.e|cho "#Ch|
|00005de0| 65 63 6b 20 74 68 65 20 | 62 61 6e 6e 65 72 73 3a |eck the |banners:|
|00005df0| 0a 22 20 3e 3e 20 24 4f | 55 54 50 55 54 0a 24 4f |." >> $O|UTPUT.$O|
|00005e00| 52 41 43 4c 45 5f 48 4f | 4d 45 2f 69 6e 73 74 61 |RACLE_HO|ME/insta|
|00005e10| 6c 6c 2f 70 72 74 76 65 | 72 73 69 6f 6e 2e 73 68 |ll/prtve|rsion.sh|
|00005e20| 20 2d 66 20 74 65 6d 70 | 24 24 0a 65 63 68 6f 20 | -f temp|$$.echo |
|00005e30| 24 4e 20 22 2e 24 43 22 | 20 20 20 20 20 20 20 20 |$N ".$C"| |
|00005e40| 20 20 20 20 20 20 20 20 | 20 20 20 23 57 61 69 74 | | #Wait|
|00005e50| 20 6d 65 73 73 61 67 65 | 0a 66 67 72 65 70 20 27 | message|.fgrep '|
|00005e60| 73 71 6c 6c 6f 61 64 27 | 20 74 65 6d 70 24 24 20 |sqlload'| temp$$ |
|00005e70| 3e 3e 20 24 4f 55 54 50 | 55 54 0a 72 6d 20 74 65 |>> $OUTP|UT.rm te|
|00005e80| 6d 70 24 24 0a 65 63 68 | 6f 20 22 0a 0a 22 20 3e |mp$$.ech|o ".." >|
|00005e90| 3e 20 24 4f 55 54 50 55 | 54 0a 0a 65 63 68 6f 20 |> $OUTPU|T..echo |
|00005ea0| 22 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |" | |
|00005eb0| 23 23 23 23 23 23 23 23 | 23 23 23 23 23 23 23 23 |########|########|
|00005ec0| 23 23 23 23 23 23 23 23 | 23 23 23 23 23 23 23 23 |########|########|
|00005ed0| 23 23 23 23 23 23 23 23 | 0a 22 20 3e 3e 20 24 4f |########|." >> $O|
|00005ee0| 55 54 50 55 54 0a 23 0a | 23 23 20 33 2e 20 49 6e |UTPUT.#.|## 3. In|
|00005ef0| 76 6f 6b 65 20 74 68 65 | 20 64 65 6d 6f 73 0a 23 |voke the| demos.#|
|00005f00| 0a 65 63 68 6f 20 24 4e | 20 22 2e 24 43 22 20 20 |.echo $N| ".$C" |
|00005f10| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00005f20| 20 23 57 61 69 74 20 6d | 65 73 73 61 67 65 0a 65 | #Wait m|essage.e|
|00005f30| 63 68 6f 20 22 23 44 65 | 6d 6f 20 74 65 73 74 69 |cho "#De|mo testi|
|00005f40| 6e 67 3a 0a 20 20 20 20 | 20 20 23 20 73 71 6c 6c |ng:. | # sqll|
|00005f50| 6f 61 64 20 73 63 6f 74 | 74 2f 74 69 67 65 72 20 |oad scot|t/tiger |
|00005f60| 63 61 73 65 31 2e 63 74 | 6c 0a 20 20 20 20 20 20 |case1.ct|l. |
|00005f70| 23 20 63 6f 6e 74 65 6e | 74 20 6f 66 20 63 61 73 |# conten|t of cas|
|00005f80| 65 31 2e 63 74 6c 3a 0a | 20 20 20 20 20 20 23 20 |e1.ctl:.| # |
|00005f90| 20 20 20 20 20 20 20 20 | 20 2a 2a 2a 2a 2a 2a 2a | | *******|
|00005fa0| 2a 2a 0a 20 20 20 20 20 | 20 23 20 4c 4f 41 44 20 |**. | # LOAD |
|00005fb0| 44 41 54 41 0a 20 20 20 | 20 20 20 23 20 49 4e 46 |DATA. | # INF|
|00005fc0| 49 4c 45 20 2a 0a 20 20 | 20 20 20 20 23 20 49 4e |ILE *. | # IN|
|00005fd0| 54 4f 20 54 41 42 4c 45 | 20 44 45 50 54 0a 20 20 |TO TABLE| DEPT. |
|00005fe0| 20 20 20 20 23 20 46 49 | 45 4c 44 53 20 54 45 52 | # FI|ELDS TER|
|00005ff0| 4d 49 4e 41 54 45 44 20 | 42 59 20 27 2c 27 20 4f |MINATED |BY ',' O|
|00006000| 50 54 49 4f 4e 41 4c 4c | 59 20 45 4e 43 4c 4f 53 |PTIONALL|Y ENCLOS|
|00006010| 45 44 20 42 59 20 27 22 | 27 0a 20 20 20 20 20 20 |ED BY '"|'. |
|00006020| 23 20 28 44 45 50 54 4e | 4f 2c 20 44 4e 41 4d 45 |# (DEPTN|O, DNAME|
|00006030| 2c 20 4c 4f 43 29 0a 20 | 20 20 20 20 20 23 20 42 |, LOC). | # B|
|00006040| 45 47 49 4e 44 41 54 41 | 0a 20 20 20 20 20 20 23 |EGINDATA|. #|
|00006050| 20 31 32 2c 52 45 53 45 | 41 52 43 48 2c 22 53 41 | 12,RESE|ARCH,"SA|
|00006060| 52 41 54 4f 47 41 22 0a | 20 20 20 20 20 20 23 20 |RATOGA".| # |
|00006070| 31 30 2c 22 41 43 43 4f | 55 4e 54 49 4e 47 22 2c |10,"ACCO|UNTING",|
|00006080| 43 4c 45 56 45 4c 41 4e | 44 0a 20 20 20 20 20 20 |CLEVELAN|D. |
|00006090| 23 20 31 31 2c 22 41 52 | 54 22 2c 53 41 4c 45 4d |# 11,"AR|T",SALEM|
|000060a0| 0a 20 20 20 20 20 20 23 | 20 31 33 2c 46 49 4e 41 |. #| 13,FINA|
|000060b0| 4e 43 45 2c 22 42 4f 53 | 54 4f 4e 22 0a 20 20 20 |NCE,"BOS|TON". |
|000060c0| 20 20 20 23 20 32 31 2c | 22 53 41 4c 45 53 22 2c | # 21,|"SALES",|
|000060d0| 50 48 49 4c 41 2e 0a 20 | 20 20 20 20 20 23 20 32 |PHILA.. | # 2|
|000060e0| 32 2c 22 53 41 4c 45 53 | 22 2c 52 4f 43 48 45 53 |2,"SALES|",ROCHES|
|000060f0| 54 45 52 0a 20 20 20 20 | 20 20 23 20 34 32 2c 22 |TER. | # 42,"|
|00006100| 49 4e 54 27 4c 22 2c 22 | 53 41 4e 20 46 52 41 4e |INT'L","|SAN FRAN|
|00006110| 22 0a 20 20 20 20 20 20 | 23 20 20 20 20 20 20 20 |". |# |
|00006120| 20 20 20 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 0a 22 20 | *****|*****." |
|00006130| 3e 3e 20 24 4f 55 54 50 | 55 54 0a 23 20 69 6e 76 |>> $OUTP|UT.# inv|
|00006140| 6f 6b 65 20 74 68 65 20 | 64 65 6d 6f 73 0a 63 64 |oke the |demos.cd|
|00006150| 20 2e 2e 2f 64 65 6d 6f | 0a 73 71 6c 70 6c 75 73 | ../demo|.sqlplus|
|00006160| 20 3e 2f 64 65 76 2f 6e | 75 6c 6c 20 32 3e 26 31 | >/dev/n|ull 2>&1|
|00006170| 20 3c 3c 21 0a 24 53 59 | 53 54 45 4d 5f 50 41 53 | <<!.$SY|STEM_PAS|
|00006180| 53 0a 40 63 61 73 65 0a | 21 0a 73 71 6c 6c 6f 61 |S.@case.|!.sqlloa|
|00006190| 64 20 73 63 6f 74 74 2f | 74 69 67 65 72 20 63 61 |d scott/|tiger ca|
|000061a0| 73 65 31 2e 63 74 6c 20 | 3e 3e 20 24 4f 55 54 50 |se1.ctl |>> $OUTP|
|000061b0| 55 54 20 32 3e 26 31 0a | 73 71 6c 70 6c 75 73 20 |UT 2>&1.|sqlplus |
|000061c0| 3e 2f 64 65 76 2f 6e 75 | 6c 6c 20 32 3e 26 31 20 |>/dev/nu|ll 2>&1 |
|000061d0| 3c 3c 21 0a 73 63 6f 74 | 74 2f 74 69 67 65 72 0a |<<!.scot|t/tiger.|
|000061e0| 73 70 6f 6f 6c 20 63 61 | 73 65 31 2e 6f 75 74 0a |spool ca|se1.out.|
|000061f0| 73 65 74 20 65 63 68 6f | 20 6f 6e 0a 73 65 6c 65 |set echo| on.sele|
|00006200| 63 74 20 2a 20 66 72 6f | 6d 20 64 65 70 74 3b 0a |ct * fro|m dept;.|
|00006210| 21 0a 0a 65 63 68 6f 20 | 22 20 20 20 20 20 20 0a |!..echo |" .|
|00006220| 09 23 43 6f 6e 74 65 6e | 74 20 6f 66 20 63 61 73 |.#Conten|t of cas|
|00006230| 65 31 2e 6f 75 74 0a 22 | 20 3e 3e 20 24 4f 55 54 |e1.out."| >> $OUT|
|00006240| 50 55 54 0a 63 61 74 20 | 63 61 73 65 31 2e 6f 75 |PUT.cat |case1.ou|
|00006250| 74 20 3e 3e 20 24 4f 55 | 54 50 55 54 0a 0a 65 63 |t >> $OU|TPUT..ec|
|00006260| 68 6f 20 22 0a 0a 22 20 | 3e 3e 20 24 4f 55 54 50 |ho ".." |>> $OUTP|
|00006270| 55 54 0a 0a 65 63 68 6f | 20 22 20 20 20 20 20 20 |UT..echo| " |
|00006280| 20 20 20 20 20 20 20 20 | 20 23 23 23 23 23 23 23 | | #######|
|00006290| 20 20 20 20 4c 6f 61 64 | 65 72 2e 56 65 72 69 66 | Load|er.Verif|
|000062a0| 79 20 44 6f 6e 65 20 20 | 20 20 23 23 23 23 23 23 |y Done | ######|
|000062b0| 23 0a 22 20 3e 3e 20 24 | 4f 55 54 50 55 54 0a 0a |#." >> $|OUTPUT..|
|000062c0| 65 63 68 6f 20 22 22 0a | 65 63 68 6f 20 22 20 20 |echo "".|echo " |
|000062d0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 23 23 23 | | ###|
|000062e0| 23 23 23 23 20 20 20 20 | 4c 6f 61 64 65 72 2e 56 |#### |Loader.V|
|000062f0| 65 72 69 66 79 20 44 6f | 6e 65 20 20 20 20 23 23 |erify Do|ne ##|
|00006300| 23 23 23 23 23 22 0a 0a | 30 37 30 37 30 37 30 30 |#####"..|07070700|
|00006310| 30 34 35 30 30 30 37 37 | 37 31 31 30 30 36 30 30 |04500077|71100600|
|00006320| 30 30 30 33 31 31 30 30 | 30 30 36 32 30 30 30 30 |00031100|00620000|
|00006330| 30 31 30 30 30 30 30 30 | 30 34 37 36 34 36 34 37 |01000000|04764647|
|00006340| 33 35 33 30 30 30 30 32 | 30 30 30 30 30 30 30 30 |35300002|00000000|
|00006350| 30 30 30 30 69 6e 73 74 | 61 6c 6c 2f 2e 6c 6f 61 |0000inst|all/.loa|
|00006360| 64 65 72 00 30 37 30 37 | 30 37 30 30 30 34 35 30 |der.0707|07000450|
|00006370| 30 30 37 37 37 32 31 30 | 30 35 35 34 30 30 30 33 |00777210|05540003|
|00006380| 31 31 30 30 30 30 36 32 | 30 30 30 30 30 31 30 30 |11000062|00000100|
|00006390| 30 30 30 30 30 34 37 36 | 34 35 37 34 30 34 34 30 |00000476|45740440|
|000063a0| 30 30 30 32 37 30 30 30 | 30 30 30 30 33 33 35 35 |00027000|00003355|
|000063b0| 69 6e 73 74 61 6c 6c 2f | 6c 6f 61 64 65 72 5f 76 |install/|loader_v|
|000063c0| 65 72 2e 6f 75 74 00 0a | 0a 23 56 65 72 69 66 79 |er.out..|.#Verify|
|000063d0| 69 6e 67 20 53 51 4c 2a | 4c 6f 61 64 65 72 20 2e |ing SQL*|Loader .|
|000063e0| 2e 2e 0a 0a 0a 20 20 20 | 20 20 20 20 20 20 20 20 |..... | |
|000063f0| 20 20 20 20 23 23 23 23 | 23 23 23 23 23 23 23 23 | ####|########|
+--------+-------------------------+-------------------------+--------+--------+
Only 25.0 KB of data is shown above.
