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: 27.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 31 31 31 |07070700|04500111|
|00001e10| 35 30 30 34 30 37 37 37 | 30 30 30 33 31 31 30 30 |50040777|00031100|
|00001e20| 30 30 36 32 30 30 30 30 | 30 37 30 30 30 30 30 30 |00620000|07000000|
|00001e30| 30 34 37 36 34 36 34 37 | 36 34 33 30 30 30 30 30 |04764647|64300000|
|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 31 31 31 35 31 |07070004|50011151|
|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 33 | 30 30 30 30 30 30 30 34 |62000003|00000004|
|00001e80| 37 36 34 35 37 35 34 36 | 32 30 30 30 30 30 36 30 |76457546|20000060|
|00001e90| 30 30 30 30 30 30 30 30 | 30 30 61 64 6d 69 6e 00 |00000000|00admin.|
|00001ea0| 30 37 30 37 30 37 30 30 | 30 34 35 30 30 31 31 31 |07070700|04500111|
|00001eb0| 35 32 30 34 30 37 35 35 | 30 30 30 33 31 31 30 30 |52040755|00031100|
|00001ec0| 30 30 36 32 30 30 30 30 | 30 32 30 30 30 30 30 30 |00620000|02000000|
|00001ed0| 30 34 37 36 34 35 37 35 | 34 33 32 30 30 30 30 31 |04764575|43200001|
|00001ee0| 33 30 30 30 30 30 30 30 | 30 30 30 30 61 64 6d 69 |30000000|0000admi|
|00001ef0| 6e 2f 68 65 6c 70 00 30 | 37 30 37 30 37 30 30 30 |n/help.0|70707000|
|00001f00| 34 35 30 30 31 31 31 35 | 33 31 30 30 34 34 34 30 |45001115|31004440|
|00001f10| 30 30 33 31 31 30 30 30 | 30 36 32 30 30 30 30 30 |00311000|06200000|
|00001f20| 31 30 30 30 30 30 30 30 | 34 37 36 34 35 37 35 34 |10000000|47645754|
|00001f30| 33 32 30 30 30 30 33 30 | 30 30 30 30 30 30 30 31 |32000030|00000001|
|00001f40| 34 30 32 61 64 6d 69 6e | 2f 68 65 6c 70 2f 68 65 |402admin|/help/he|
|00001f50| 6c 70 69 6e 64 78 2e 73 | 71 6c 00 72 65 6d 0a 72 |lpindx.s|ql.rem.r|
|00001f60| 65 6d 20 20 24 48 65 61 | 64 65 72 3a 20 68 65 6c |em $Hea|der: hel|
|00001f70| 70 69 6e 64 78 2e 73 71 | 6c 2e 30 2c 76 20 31 2e |pindx.sq|l.0,v 1.|
|00001f80| 31 20 38 39 2f 30 37 2f | 31 38 20 31 38 3a 31 30 |1 89/07/|18 18:10|
|00001f90| 3a 31 36 20 64 6f 73 74 | 65 72 62 65 20 45 78 70 |:16 dost|erbe Exp|
|00001fa0| 20 24 20 62 61 73 65 20 | 73 71 6c 70 6c 75 73 20 | $ base |sqlplus |
|00001fb0| 73 71 6c 70 6c 75 73 2f | 61 64 6d 69 6e 2f 68 65 |sqlplus/|admin/he|
|00001fc0| 6c 70 20 68 65 6c 70 69 | 6e 64 78 2e 73 71 6c 20 |lp helpi|ndx.sql |
|00001fd0| 30 20 43 6f 70 79 72 20 | 28 63 29 20 31 39 38 38 |0 Copyr |(c) 1988|
|00001fe0| 20 4f 72 61 63 6c 65 20 | 43 6f 72 70 6f 72 61 74 | Oracle |Corporat|
|00001ff0| 69 6f 6e 20 0a 72 65 6d | 0a 53 45 54 20 54 45 52 |ion .rem|.SET TER|
|00002000| 4d 4f 55 54 20 6f 6e 0a | 20 0a 72 65 6d 20 4f 61 |MOUT on.| .rem Oa|
|00002010| 74 65 73 3a 20 20 20 20 | 20 43 72 65 61 74 65 64 |tes: | Created|
|00002020| 3a 20 31 36 2d 46 65 62 | 2d 38 33 0a 72 65 6d 20 |: 16-Feb|-83.rem |
|00002030| 4a 61 63 6f 62 73 3a 20 | 20 20 20 4d 6f 64 69 66 |Jacobs: | Modif|
|00002040| 69 65 64 3a 20 33 30 2d | 41 70 72 2d 38 33 20 2d |ied: 30-|Apr-83 -|
|00002050| 20 42 75 69 6c 64 20 54 | 4f 50 49 43 53 20 48 65 | Build T|OPICS He|
|00002060| 6c 70 0a 72 65 6d 20 46 | 69 73 68 65 72 3a 20 20 |lp.rem F|isher: |
|00002070| 20 20 4d 6f 64 69 66 69 | 65 64 3a 20 32 33 2d 4f | Modifi|ed: 23-O|
|00002080| 63 74 2d 38 36 20 2d 20 | 4f 6e 65 20 55 6e 69 71 |ct-86 - |One Uniq|
|00002090| 75 65 20 43 6f 6e 63 61 | 74 69 6e 61 74 65 64 20 |ue Conca|tinated |
|000020a0| 49 6e 64 65 78 2e 0a 72 | 65 6d 20 4f 73 74 65 72 |Index..r|em Oster|
|000020b0| 62 65 72 67 3a 20 4d 6f | 64 69 66 69 65 64 3a 20 |berg: Mo|dified: |
|000020c0| 31 31 2d 41 70 72 2d 38 | 39 20 2d 20 55 70 64 61 |11-Apr-8|9 - Upda|
|000020d0| 74 65 20 66 6f 72 20 56 | 36 20 0a 0a 73 65 74 20 |te for V|6 ..set |
|000020e0| 74 65 72 6d 6f 75 74 20 | 6f 66 66 0a 73 70 6f 6f |termout |off.spoo|
|000020f0| 6c 20 68 65 6c 70 69 6e | 64 78 2e 6c 69 73 0a 43 |l helpin|dx.lis.C|
|00002100| 52 45 41 54 45 20 49 4e | 44 45 58 20 48 45 4c 50 |REATE IN|DEX HELP|
|00002110| 5f 54 4f 50 49 43 5f 53 | 45 51 20 4f 4e 20 48 45 |_TOPIC_S|EQ ON HE|
|00002120| 4c 50 28 54 4f 50 49 43 | 2c 53 45 51 29 3b 0a 49 |LP(TOPIC|,SEQ);.I|
|00002130| 4e 53 45 52 54 20 49 4e | 54 4f 20 48 45 4c 50 0a |NSERT IN|TO HELP.|
|00002140| 20 20 20 56 41 4c 55 45 | 53 20 28 27 54 4f 50 49 | VALUE|S ('TOPI|
|00002150| 43 53 27 2c 20 2d 32 2c | 20 4e 55 4c 4c 29 3b 0a |CS', -2,| NULL);.|
|00002160| 49 4e 53 45 52 54 20 49 | 4e 54 4f 20 48 45 4c 50 |INSERT I|NTO HELP|
|00002170| 0a 20 20 20 56 41 4c 55 | 45 53 20 28 27 54 4f 50 |. VALU|ES ('TOP|
|00002180| 49 43 53 27 2c 20 2d 31 | 2c 20 27 48 65 6c 70 20 |ICS', -1|, 'Help |
|00002190| 69 73 20 61 76 61 69 6c | 61 62 6c 65 20 6f 6e 20 |is avail|able on |
|000021a0| 74 68 65 20 66 6f 6c 6c | 6f 77 69 6e 67 20 74 6f |the foll|owing to|
|000021b0| 70 69 63 73 3a 20 27 29 | 3b 0a 49 4e 53 45 52 54 |pics: ')|;.INSERT|
|000021c0| 20 49 4e 54 4f 20 48 45 | 4c 50 0a 20 20 20 56 41 | INTO HE|LP. VA|
|000021d0| 4c 55 45 53 20 28 27 54 | 4f 50 49 43 53 27 2c 20 |LUES ('T|OPICS', |
|000021e0| 30 2c 20 4e 55 4c 4c 29 | 3b 0a 49 4e 53 45 52 54 |0, NULL)|;.INSERT|
|000021f0| 20 49 4e 54 4f 20 48 45 | 4c 50 0a 20 20 20 53 45 | INTO HE|LP. SE|
|00002200| 4c 45 43 54 20 27 54 4f | 50 49 43 53 27 2c 20 31 |LECT 'TO|PICS', 1|
|00002210| 2c 20 54 4f 50 49 43 0a | 20 20 20 46 52 4f 4d 20 |, TOPIC.| FROM |
|00002220| 48 45 4c 50 0a 20 20 20 | 47 52 4f 55 50 20 42 59 |HELP. |GROUP BY|
|00002230| 20 54 4f 50 49 43 3b 0a | 47 52 41 4e 54 20 53 45 | TOPIC;.|GRANT SE|
|00002240| 4c 45 43 54 20 4f 4e 20 | 48 45 4c 50 20 54 4f 20 |LECT ON |HELP TO |
|00002250| 50 55 42 4c 49 43 3b 0a | 45 58 49 54 0a 30 37 30 |PUBLIC;.|EXIT.070|
|00002260| 37 30 37 30 30 30 34 35 | 30 30 31 31 31 35 34 31 |70700045|00111541|
|00002270| 30 30 34 34 34 30 30 30 | 33 31 31 30 30 30 30 36 |00444000|31100006|
|00002280| 32 30 30 30 30 30 31 30 | 30 30 30 30 30 30 34 37 |20000010|00000047|
|00002290| 36 34 35 37 35 34 33 32 | 30 30 30 30 32 37 30 30 |64575432|00002700|
|000022a0| 30 30 30 30 30 30 37 31 | 36 61 64 6d 69 6e 2f 68 |00000071|6admin/h|
|000022b0| 65 6c 70 2f 68 65 6c 70 | 74 62 6c 2e 73 71 6c 00 |elp/help|tbl.sql.|
|000022c0| 72 65 6d 0a 72 65 6d 20 | 20 24 48 65 61 64 65 72 |rem.rem | $Header|
|000022d0| 3a 20 68 65 6c 70 74 62 | 6c 2e 73 71 6c 2e 30 2c |: helptb|l.sql.0,|
|000022e0| 76 20 31 2e 31 20 38 39 | 2f 30 37 2f 31 38 20 31 |v 1.1 89|/07/18 1|
|000022f0| 38 3a 31 33 3a 32 37 20 | 64 6f 73 74 65 72 62 65 |8:13:27 |dosterbe|
|00002300| 20 45 78 70 20 24 20 62 | 61 73 65 20 73 71 6c 70 | Exp $ b|ase sqlp|
|00002310| 6c 75 73 20 73 71 6c 70 | 6c 75 73 2f 61 64 6d 69 |lus sqlp|lus/admi|
|00002320| 6e 2f 68 65 6c 70 20 68 | 65 6c 70 74 62 6c 2e 73 |n/help h|elptbl.s|
|00002330| 71 6c 20 30 20 43 6f 70 | 79 72 20 28 63 29 20 31 |ql 0 Cop|yr (c) 1|
|00002340| 39 38 38 20 4f 72 61 63 | 6c 65 20 43 6f 72 70 6f |988 Orac|le Corpo|
|00002350| 72 61 74 69 6f 6e 20 0a | 72 65 6d 0a 53 45 54 20 |ration .|rem.SET |
|00002360| 54 45 52 4d 4f 55 54 20 | 4f 46 46 0a 0a 72 65 6d |TERMOUT |OFF..rem|
|00002370| 20 4f 61 74 65 73 3a 20 | 20 20 20 20 43 72 65 61 | Oates: | Crea|
|00002380| 74 65 64 3a 20 31 36 2d | 46 65 62 2d 38 33 0a 72 |ted: 16-|Feb-83.r|
|00002390| 65 6d 20 42 72 61 64 62 | 75 72 79 3a 20 20 4d 6f |em Bradb|ury: Mo|
|000023a0| 64 69 66 69 65 64 3a 20 | 30 34 2d 41 70 72 2d 38 |dified: |04-Apr-8|
|000023b0| 36 20 53 70 6f 6f 6c 20 | 61 66 74 65 72 20 64 72 |6 Spool |after dr|
|000023c0| 6f 70 69 6e 67 20 74 61 | 62 6c 65 0a 72 65 6d 20 |oping ta|ble.rem |
|000023d0| 4f 73 74 65 72 62 65 72 | 67 3a 20 4d 6f 64 69 66 |Osterber|g: Modif|
|000023e0| 69 65 64 3a 20 31 31 2d | 41 70 72 2d 38 39 20 6e |ied: 11-|Apr-89 n|
|000023f0| 6f 20 6d 6f 72 65 20 53 | 59 53 54 45 4d 2f 4d 41 |o more S|YSTEM/MA|
|00002400| 4e 41 47 45 52 20 6c 69 | 6e 65 0a 0a 44 52 4f 50 |NAGER li|ne..DROP|
|00002410| 20 54 41 42 4c 45 20 48 | 45 4c 50 3b 0a 53 50 4f | TABLE H|ELP;.SPO|
|00002420| 4f 4c 20 68 65 6c 70 74 | 62 6c 2e 6c 69 73 0a 43 |OL helpt|bl.lis.C|
|00002430| 52 45 41 54 45 20 54 41 | 42 4c 45 20 48 45 4c 50 |REATE TA|BLE HELP|
|00002440| 0a 28 0a 20 20 54 4f 50 | 49 43 20 43 48 41 52 28 |.(. TOP|IC CHAR(|
|00002450| 33 30 29 20 4e 4f 54 20 | 4e 55 4c 4c 2c 0a 20 20 |30) NOT |NULL,. |
|00002460| 53 45 51 09 4e 55 4d 42 | 45 52 09 20 4e 4f 54 20 |SEQ.NUMB|ER. NOT |
|00002470| 4e 55 4c 4c 2c 0a 20 20 | 49 4e 46 4f 09 43 48 41 |NULL,. |INFO.CHA|
|00002480| 52 28 38 30 29 0a 29 3b | 0a 45 58 49 54 0a 30 37 |R(80).);|.EXIT.07|
|00002490| 30 37 30 37 30 30 30 34 | 35 30 30 31 31 31 35 35 |07070004|50011155|
|000024a0| 31 30 30 34 34 34 30 30 | 30 33 31 31 30 30 30 30 |10044400|03110000|
|000024b0| 36 32 30 30 30 30 30 31 | 30 30 30 30 30 30 30 34 |62000001|00000004|
|000024c0| 37 36 34 35 37 35 34 36 | 32 30 30 30 30 33 30 30 |76457546|20000300|
|000024d0| 30 30 30 31 34 33 36 30 | 36 32 61 64 6d 69 6e 2f |00014360|62admin/|
|000024e0| 68 65 6c 70 2f 70 6c 75 | 73 68 65 6c 70 2e 63 74 |help/plu|shelp.ct|
|000024f0| 6c 00 6c 6f 61 64 20 64 | 61 74 61 0a 69 6e 66 69 |l.load d|ata.infi|
|00002500| 6c 65 20 2a 0a 63 6f 6e | 63 61 74 65 6e 61 74 65 |le *.con|catenate|
|00002510| 20 32 0a 69 6e 74 6f 20 | 74 61 62 6c 65 20 68 65 | 2.into |table he|
|00002520| 6c 70 20 72 65 70 6c 61 | 63 65 0a 66 69 65 6c 64 |lp repla|ce.field|
|00002530| 73 0a 28 0a 20 20 73 65 | 71 20 20 20 20 63 68 61 |s.(. se|q cha|
|00002540| 72 20 28 33 29 20 74 65 | 72 6d 69 6e 61 74 65 64 |r (3) te|rminated|
|00002550| 20 62 79 20 27 2c 27 2c | 0a 20 20 74 6f 70 69 63 | by ',',|. topic|
|00002560| 20 20 63 68 61 72 20 28 | 33 30 29 20 74 65 72 6d | char (|30) term|
|00002570| 69 6e 61 74 65 64 20 62 | 79 20 27 2c 27 2c 0a 20 |inated b|y ',',. |
|00002580| 20 69 6e 66 6f 20 20 20 | 70 6f 73 69 74 69 6f 6e | info |position|
|00002590| 20 28 2a 29 20 63 68 61 | 72 20 28 38 30 29 0a 29 | (*) cha|r (80).)|
|000025a0| 0a 42 45 47 49 4e 44 41 | 54 41 0a 20 20 31 2c 2f |.BEGINDA|TA. 1,/|
|000025b0| 2c 0a 0a 20 20 32 2c 2f | 2c 0a 0a 20 20 33 2c 2f |,.. 2,/|,.. 3,/|
|000025c0| 2c 0a 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |,. | |
|000025d0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|000025e0| 20 20 2f 20 28 73 6c 61 | 73 68 29 0a 20 20 34 2c | / (sla|sh). 4,|
|000025f0| 2f 2c 0a 0a 20 20 35 2c | 2f 2c 0a 20 2f 0a 20 20 |/,.. 5,|/,. /. |
|00002600| 36 2c 2f 2c 0a 0a 20 20 | 37 2c 2f 2c 0a 20 45 6e |6,/,.. |7,/,. En|
|00002610| 74 65 72 20 61 20 73 6c | 61 73 68 20 28 2f 29 20 |ter a sl|ash (/) |
|00002620| 61 74 20 74 68 65 20 63 | 6f 6d 6d 61 6e 64 20 70 |at the c|ommand p|
|00002630| 72 6f 6d 70 74 20 6f 72 | 20 61 74 20 61 20 6c 69 |rompt or| at a li|
|00002640| 6e 65 20 6e 75 6d 62 65 | 72 20 70 72 6f 6d 70 74 |ne numbe|r prompt|
|00002650| 20 74 6f 0a 20 20 38 2c | 2f 2c 0a 20 65 78 65 63 | to. 8,|/,. exec|
|00002660| 75 74 65 20 61 20 53 51 | 4c 20 63 6f 6d 6d 61 6e |ute a SQ|L comman|
|00002670| 64 20 6f 72 20 50 4c 2f | 53 51 4c 20 62 6c 6f 63 |d or PL/|SQL bloc|
|00002680| 6b 20 69 6e 20 74 68 65 | 20 53 51 4c 20 62 75 66 |k in the| SQL buf|
|00002690| 66 65 72 2e 20 20 54 68 | 65 20 73 6c 61 73 68 0a |fer. Th|e slash.|
|000026a0| 20 20 39 2c 2f 2c 0a 20 | 63 6f 6d 6d 61 6e 64 20 | 9,/,. |command |
|000026b0| 77 6f 72 6b 73 20 6c 69 | 6b 65 20 52 55 4e 2c 20 |works li|ke RUN, |
|000026c0| 62 75 74 20 64 6f 65 73 | 20 6e 6f 74 20 6c 69 73 |but does| not lis|
|000026d0| 74 20 74 68 65 20 63 6f | 6d 6d 61 6e 64 20 6f 6e |t the co|mmand on|
|000026e0| 20 79 6f 75 72 20 73 63 | 72 65 65 6e 0a 20 31 30 | your sc|reen. 10|
|000026f0| 2c 2f 2c 0a 20 62 75 66 | 66 65 72 2e 0a 20 31 31 |,/,. buf|fer.. 11|
|00002700| 2c 2f 2c 0a 0a 20 31 32 | 2c 2f 2c 0a 20 45 78 65 |,/,.. 12|,/,. Exe|
|00002710| 63 75 74 69 6e 67 20 61 | 20 53 51 4c 20 63 6f 6d |cuting a| SQL com|
|00002720| 6d 61 6e 64 20 6f 72 20 | 50 4c 2f 53 51 4c 20 62 |mand or |PL/SQL b|
|00002730| 6c 6f 63 6b 20 77 69 74 | 68 20 74 68 65 20 73 6c |lock wit|h the sl|
|00002740| 61 73 68 20 64 6f 65 73 | 20 6e 6f 74 20 63 68 61 |ash does| not cha|
|00002750| 6e 67 65 20 74 68 65 0a | 20 31 33 2c 2f 2c 0a 20 |nge the.| 13,/,. |
|00002760| 63 75 72 72 65 6e 74 20 | 6c 69 6e 65 20 6e 75 6d |current |line num|
|00002770| 62 65 72 20 69 6e 20 74 | 68 65 20 53 51 4c 20 62 |ber in t|he SQL b|
|00002780| 75 66 66 65 72 20 75 6e | 6c 65 73 73 20 74 68 65 |uffer un|less the|
|00002790| 20 63 6f 6d 6d 61 6e 64 | 20 69 6e 20 74 68 65 20 | command| in the |
|000027a0| 62 75 66 66 65 72 20 68 | 61 73 0a 20 31 34 2c 2f |buffer h|as. 14,/|
|000027b0| 2c 0a 20 61 6e 20 65 72 | 72 6f 72 2e 20 20 49 66 |,. an er|ror. If|
|000027c0| 20 73 6f 2c 20 53 51 4c | 2a 50 6c 75 73 20 6d 61 | so, SQL|*Plus ma|
|000027d0| 6b 65 73 20 74 68 65 20 | 6c 69 6e 65 20 77 69 74 |kes the |line wit|
|000027e0| 68 20 74 68 65 20 65 72 | 72 6f 72 20 74 68 65 20 |h the er|ror the |
|000027f0| 63 75 72 72 65 6e 74 20 | 6c 69 6e 65 2e 0a 20 31 |current |line.. 1|
|00002800| 35 2c 2f 2c 0a 0a 20 31 | 36 2c 2f 2c 0a 20 45 78 |5,/,.. 1|6,/,. Ex|
|00002810| 61 6d 70 6c 65 73 3a 20 | 54 79 70 65 20 4c 49 53 |amples: |Type LIS|
|00002820| 54 20 74 6f 20 73 65 65 | 20 74 68 65 20 63 6f 6e |T to see| the con|
|00002830| 74 65 6e 74 73 20 6f 66 | 20 74 68 65 20 62 75 66 |tents of| the buf|
|00002840| 66 65 72 3a 0a 20 31 37 | 2c 2f 2c 0a 0a 20 31 38 |fer:. 17|,/,.. 18|
|00002850| 2c 2f 2c 0a 20 20 20 20 | 20 20 20 20 20 20 20 20 |,/,. | |
|00002860| 20 20 20 53 51 4c 3e 20 | 4c 49 53 54 0a 20 31 39 | SQL> |LIST. 19|
|00002870| 2c 2f 2c 0a 20 20 20 20 | 20 20 20 20 20 20 20 20 |,/,. | |
|00002880| 20 20 20 20 20 31 2a 20 | 53 45 4c 45 43 54 20 45 | 1* |SELECT E|
|00002890| 4e 41 4d 45 2c 20 4a 4f | 42 20 46 52 4f 4d 20 45 |NAME, JO|B FROM E|
|000028a0| 4d 50 20 57 48 45 52 45 | 20 45 4e 41 4d 45 20 3d |MP WHERE| ENAME =|
|000028b0| 20 27 4a 41 4d 45 53 27 | 0a 20 32 30 2c 2f 2c 0a | 'JAMES'|. 20,/,.|
|000028c0| 0a 20 32 31 2c 2f 2c 0a | 20 20 20 20 20 20 20 20 |. 21,/,.| |
|000028d0| 20 20 20 45 6e 74 65 72 | 20 2f 20 28 73 6c 61 73 | Enter| / (slas|
|000028e0| 68 29 20 74 6f 20 65 78 | 65 63 75 74 65 20 74 68 |h) to ex|ecute th|
|000028f0| 65 20 63 6f 6d 6d 61 6e | 64 20 69 6e 20 74 68 65 |e comman|d in the|
|00002900| 20 62 75 66 66 65 72 3a | 0a 20 32 32 2c 2f 2c 0a | buffer:|. 22,/,.|
|00002910| 0a 20 32 33 2c 2f 2c 0a | 20 20 20 20 20 20 20 20 |. 23,/,.| |
|00002920| 20 20 20 20 20 20 20 53 | 51 4c 3e 20 2f 20 20 20 | S|QL> / |
|00002930| 20 20 20 20 20 20 4f 75 | 74 70 75 74 3a 20 20 45 | Ou|tput: E|
|00002940| 4e 41 4d 45 20 20 20 4a | 4f 42 0a 20 32 34 2c 2f |NAME J|OB. 24,/|
|00002950| 2c 0a 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |,. | |
|00002960| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00002970| 20 20 20 20 20 20 20 20 | 20 2d 2d 2d 2d 2d 2d 20 | | ------ |
|00002980| 20 2d 2d 2d 2d 2d 0a 20 | 32 35 2c 2f 2c 0a 20 20 | -----. |25,/,. |
|00002990| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|000029a0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|000029b0| 20 20 20 20 20 4a 41 4d | 45 53 20 20 20 43 4c 45 | JAM|ES CLE|
|000029c0| 52 4b 0a 20 32 36 2c 2f | 2c 0a 0a 20 32 37 2c 2f |RK. 26,/|,.. 27,/|
|000029d0| 2c 0a 20 53 65 65 20 61 | 6c 73 6f 3a 20 40 2c 20 |,. See a|lso: @, |
|000029e0| 65 64 69 74 2c 20 67 65 | 74 2c 20 6c 69 73 74 2c |edit, ge|t, list,|
|000029f0| 20 72 75 6e 2c 20 73 61 | 76 65 2c 20 70 61 72 61 | run, sa|ve, para|
|00002a00| 6d 65 74 65 72 73 2c 20 | 73 65 74 20 28 53 51 4c |meters, |set (SQL|
|00002a10| 20 62 75 66 66 65 72 29 | 2c 0a 20 32 38 2c 2f 2c | buffer)|,. 28,/,|
|00002a20| 0a 20 20 20 20 20 20 20 | 20 20 20 20 73 70 6f 6f |. | spoo|
|00002a30| 6c 2c 20 73 74 61 72 74 | 2c 20 63 6f 6d 6d 61 6e |l, start|, comman|
|00002a40| 64 73 2c 20 6d 65 6e 75 | 2e 0a 20 20 31 2c 31 20 |ds, menu|.. 1,1 |
|00002a50| 52 6f 77 20 43 68 61 72 | 20 46 75 6e 63 74 69 6f |Row Char| Functio|
|00002a60| 6e 73 2c 0a 0a 20 20 32 | 2c 31 20 52 6f 77 20 43 |ns,.. 2|,1 Row C|
|00002a70| 68 61 72 20 46 75 6e 63 | 74 69 6f 6e 73 2c 0a 0a |har Func|tions,..|
|00002a80| 20 20 33 2c 31 20 52 6f | 77 20 43 68 61 72 20 46 | 3,1 Ro|w Char F|
|00002a90| 75 6e 63 74 69 6f 6e 73 | 2c 0a 20 20 20 20 20 20 |unctions|,. |
|00002aa0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00002ab0| 20 20 20 20 20 31 20 52 | 6f 77 20 43 68 61 72 20 | 1 R|ow Char |
|00002ac0| 46 75 6e 63 74 69 6f 6e | 73 0a 20 20 34 2c 31 20 |Function|s. 4,1 |
|00002ad0| 52 6f 77 20 43 68 61 72 | 20 46 75 6e 63 74 69 6f |Row Char| Functio|
|00002ae0| 6e 73 2c 0a 0a 20 20 35 | 2c 31 20 52 6f 77 20 43 |ns,.. 5|,1 Row C|
|00002af0| 68 61 72 20 46 75 6e 63 | 74 69 6f 6e 73 2c 0a 20 |har Func|tions,. |
|00002b00| 41 53 43 49 49 28 73 74 | 72 69 6e 67 29 20 20 20 |ASCII(st|ring) |
|00002b10| 20 20 52 65 74 75 72 6e | 73 20 63 6f 6c 6c 61 74 | Return|s collat|
|00002b20| 69 6e 67 20 73 65 71 75 | 65 6e 63 65 20 76 61 6c |ing sequ|ence val|
|00002b30| 75 65 20 6f 66 20 31 73 | 74 20 63 68 61 72 20 6f |ue of 1s|t char o|
|00002b40| 66 20 73 74 72 69 6e 67 | 2e 0a 20 20 36 2c 31 20 |f string|.. 6,1 |
|00002b50| 52 6f 77 20 43 68 61 72 | 20 46 75 6e 63 74 69 6f |Row Char| Functio|
|00002b60| 6e 73 2c 0a 20 43 48 52 | 28 6e 29 20 20 20 20 20 |ns,. CHR|(n) |
|00002b70| 20 20 20 20 20 20 20 52 | 65 74 75 72 6e 73 20 63 | R|eturns c|
|00002b80| 68 61 72 61 63 74 65 72 | 20 68 61 76 69 6e 67 20 |haracter| having |
|00002b90| 41 53 43 49 49 20 6f 72 | 20 45 42 43 44 49 43 20 |ASCII or| EBCDIC |
|00002ba0| 76 61 6c 75 65 20 6f 66 | 20 6e 2e 0a 20 20 37 2c |value of| n.. 7,|
|00002bb0| 31 20 52 6f 77 20 43 68 | 61 72 20 46 75 6e 63 74 |1 Row Ch|ar Funct|
|00002bc0| 69 6f 6e 73 2c 0a 20 49 | 4e 49 54 43 41 50 28 63 |ions,. I|NITCAP(c|
|00002bd0| 68 61 72 29 20 20 20 20 | 20 43 61 70 69 74 61 6c |har) | Capital|
|00002be0| 69 7a 65 73 20 65 61 63 | 68 20 77 6f 72 64 27 73 |izes eac|h word's|
|00002bf0| 20 66 69 72 73 74 20 6c | 65 74 74 65 72 2c 20 6f | first l|etter, o|
|00002c00| 74 68 65 72 73 20 6c 6f | 77 65 72 63 61 73 65 2e |thers lo|wercase.|
|00002c10| 0a 20 20 38 2c 31 20 52 | 6f 77 20 43 68 61 72 20 |. 8,1 R|ow Char |
|00002c20| 46 75 6e 63 74 69 6f 6e | 73 2c 0a 20 49 4e 53 54 |Function|s,. INST|
|00002c30| 52 28 63 68 61 72 31 2c | 20 20 20 20 20 20 42 65 |R(char1,| Be|
|00002c40| 67 69 6e 6e 69 6e 67 20 | 61 74 20 70 6f 73 69 74 |ginning |at posit|
|00002c50| 69 6f 6e 20 6d 2c 20 72 | 65 74 75 72 6e 73 20 74 |ion m, r|eturns t|
|00002c60| 68 65 20 70 6f 73 69 74 | 69 6f 6e 20 6f 66 20 74 |he posit|ion of t|
|00002c70| 68 65 0a 20 20 39 2c 31 | 20 52 6f 77 20 43 68 61 |he. 9,1| Row Cha|
|00002c80| 72 20 46 75 6e 63 74 69 | 6f 6e 73 2c 0a 20 20 20 |r Functi|ons,. |
|00002c90| 63 68 61 72 32 2c 20 6d | 2c 20 6e 29 20 20 20 20 |char2, m|, n) |
|00002ca0| 20 20 20 6e 74 68 20 6f | 63 63 75 72 72 65 6e 63 | nth o|ccurrenc|
|00002cb0| 65 20 6f 66 20 63 68 61 | 72 32 20 69 6e 20 63 68 |e of cha|r2 in ch|
|00002cc0| 61 72 31 3b 20 6d 20 26 | 20 6e 20 3d 20 30 20 69 |ar1; m &| n = 0 i|
|00002cd0| 66 20 61 62 73 65 6e 74 | 2e 0a 20 31 30 2c 31 20 |f absent|.. 10,1 |
|00002ce0| 52 6f 77 20 43 68 61 72 | 20 46 75 6e 63 74 69 6f |Row Char| Functio|
|00002cf0| 6e 73 2c 0a 20 4c 45 4e | 47 54 48 28 63 68 61 72 |ns,. LEN|GTH(char|
|00002d00| 29 20 20 20 20 20 20 52 | 65 74 75 72 6e 73 20 74 |) R|eturns t|
|00002d10| 68 65 20 6c 65 6e 67 74 | 68 20 6f 66 20 63 68 61 |he lengt|h of cha|
|00002d20| 72 2e 0a 20 31 31 2c 31 | 20 52 6f 77 20 43 68 61 |r.. 11,1| Row Cha|
|00002d30| 72 20 46 75 6e 63 74 69 | 6f 6e 73 2c 0a 20 4c 4f |r Functi|ons,. LO|
|00002d40| 57 45 52 28 63 68 61 72 | 29 20 20 20 20 20 20 20 |WER(char|) |
|00002d50| 52 65 74 75 72 6e 73 20 | 63 68 61 72 20 69 6e 20 |Returns |char in |
|00002d60| 6c 6f 77 65 72 63 61 73 | 65 2e 0a 20 31 32 2c 31 |lowercas|e.. 12,1|
|00002d70| 20 52 6f 77 20 43 68 61 | 72 20 46 75 6e 63 74 69 | Row Cha|r Functi|
|00002d80| 6f 6e 73 2c 0a 20 4c 50 | 41 44 28 63 68 61 72 31 |ons,. LP|AD(char1|
|00002d90| 2c 20 20 20 20 20 20 20 | 41 64 64 73 20 63 68 61 |, |Adds cha|
|00002da0| 72 32 20 6e 20 6e 75 6d | 62 65 72 20 6f 66 20 74 |r2 n num|ber of t|
|00002db0| 69 6d 65 73 20 69 6e 20 | 66 72 6f 6e 74 20 6f 66 |imes in |front of|
|00002dc0| 20 63 68 61 72 31 2e 0a | 20 31 33 2c 31 20 52 6f | char1..| 13,1 Ro|
|00002dd0| 77 20 43 68 61 72 20 46 | 75 6e 63 74 69 6f 6e 73 |w Char F|unctions|
|00002de0| 2c 0a 20 20 20 6e 2c 20 | 63 68 61 72 32 29 0a 20 |,. n, |char2). |
|00002df0| 31 34 2c 31 20 52 6f 77 | 20 43 68 61 72 20 46 75 |14,1 Row| Char Fu|
|00002e00| 6e 63 74 69 6f 6e 73 2c | 0a 20 4c 54 52 49 4d 28 |nctions,|. LTRIM(|
|00002e10| 63 68 61 72 2c 20 73 29 | 20 20 20 20 52 65 6d 6f |char, s)| Remo|
|00002e20| 76 65 73 20 62 65 67 69 | 6e 6e 69 6e 67 20 63 68 |ves begi|nning ch|
|00002e30| 61 72 61 63 74 65 72 73 | 20 66 72 6f 6d 20 63 68 |aracters| from ch|
|00002e40| 61 72 2c 20 75 70 20 74 | 6f 20 74 68 65 20 66 69 |ar, up t|o the fi|
|00002e50| 72 73 74 0a 20 31 35 2c | 31 20 52 6f 77 20 43 68 |rst. 15,|1 Row Ch|
|00002e60| 61 72 20 46 75 6e 63 74 | 69 6f 6e 73 2c 0a 20 20 |ar Funct|ions,. |
|00002e70| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00002e80| 20 20 20 20 63 68 61 72 | 61 63 74 65 72 20 6e 6f | char|acter no|
|00002e90| 74 20 69 6e 20 74 68 65 | 20 73 20 73 65 74 3b 20 |t in the| s set; |
|00002ea0| 73 20 3d 20 27 27 69 66 | 20 61 62 73 65 6e 74 2e |s = ''if| absent.|
|00002eb0| 0a 20 31 36 2c 31 20 52 | 6f 77 20 43 68 61 72 20 |. 16,1 R|ow Char |
|00002ec0| 46 75 6e 63 74 69 6f 6e | 73 2c 0a 20 4e 4c 53 53 |Function|s,. NLSS|
|00002ed0| 4f 52 54 28 63 68 61 72 | 29 20 20 20 20 20 47 69 |ORT(char|) Gi|
|00002ee0| 76 65 73 20 63 68 61 72 | 27 73 20 4e 61 74 69 6f |ves char|'s Natio|
|00002ef0| 6e 61 6c 20 4c 61 6e 67 | 75 61 67 65 20 63 6f 6c |nal Lang|uage col|
|00002f00| 6c 61 74 69 6e 67 20 73 | 65 71 75 65 6e 63 65 2e |lating s|equence.|
|00002f10| 0a 20 31 37 2c 31 20 52 | 6f 77 20 43 68 61 72 20 |. 17,1 R|ow Char |
|00002f20| 46 75 6e 63 74 69 6f 6e | 73 2c 0a 20 52 45 50 4c |Function|s,. REPL|
|00002f30| 41 43 45 28 63 68 61 72 | 2c 20 20 20 20 20 43 68 |ACE(char|, Ch|
|00002f40| 61 6e 67 65 73 20 65 61 | 63 68 20 66 69 6e 64 20 |anges ea|ch find |
|00002f50| 69 6e 20 63 68 61 72 20 | 74 6f 20 6e 65 77 3b 20 |in char |to new; |
|00002f60| 6f 6d 69 74 20 6e 65 77 | 20 74 6f 20 65 72 61 73 |omit new| to eras|
|00002f70| 65 0a 20 31 38 2c 31 20 | 52 6f 77 20 43 68 61 72 |e. 18,1 |Row Char|
|00002f80| 20 46 75 6e 63 74 69 6f | 6e 73 2c 0a 20 20 20 66 | Functio|ns,. f|
|00002f90| 69 6e 64 2c 20 6e 65 77 | 29 20 20 20 20 20 20 20 |ind, new|) |
|00002fa0| 20 20 66 69 6e 64 2e 20 | 20 55 73 65 20 54 52 41 | find. | Use TRA|
|00002fb0| 4e 53 4c 41 54 45 20 66 | 6f 72 20 73 69 6e 67 6c |NSLATE f|or singl|
|00002fc0| 65 20 63 68 61 72 61 63 | 74 65 72 73 2e 0a 20 31 |e charac|ters.. 1|
|00002fd0| 39 2c 31 20 52 6f 77 20 | 43 68 61 72 20 46 75 6e |9,1 Row |Char Fun|
|00002fe0| 63 74 69 6f 6e 73 2c 0a | 20 52 50 41 44 28 63 68 |ctions,.| RPAD(ch|
|00002ff0| 61 72 31 2c 20 6e 2c 20 | 20 20 20 41 64 64 73 20 |ar1, n, | Adds |
|00003000| 63 68 61 72 32 20 6e 20 | 6e 75 6d 62 65 72 20 6f |char2 n |number o|
|00003010| 66 20 74 69 6d 65 73 20 | 61 66 74 65 72 20 63 68 |f times |after ch|
|00003020| 61 72 31 2e 0a 20 32 30 | 2c 31 20 52 6f 77 20 43 |ar1.. 20|,1 Row C|
|00003030| 68 61 72 20 46 75 6e 63 | 74 69 6f 6e 73 2c 0a 20 |har Func|tions,. |
|00003040| 20 20 63 68 61 72 32 29 | 0a 20 32 31 2c 31 20 52 | char2)|. 21,1 R|
|00003050| 6f 77 20 43 68 61 72 20 | 46 75 6e 63 74 69 6f 6e |ow Char |Function|
|00003060| 73 2c 0a 20 52 54 52 49 | 4d 28 63 68 61 72 2c 20 |s,. RTRI|M(char, |
|00003070| 73 65 74 29 20 20 52 65 | 6d 6f 76 65 73 20 63 68 |set) Re|moves ch|
|00003080| 61 72 61 63 74 65 72 73 | 20 66 72 6f 6d 20 74 68 |aracters| from th|
|00003090| 65 20 65 6e 64 20 6f 66 | 20 63 68 61 72 20 75 6e |e end of| char un|
|000030a0| 74 69 6c 20 74 68 65 0a | 20 32 32 2c 31 20 52 6f |til the.| 22,1 Ro|
|000030b0| 77 20 43 68 61 72 20 46 | 75 6e 63 74 69 6f 6e 73 |w Char F|unctions|
|000030c0| 2c 0a 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |,. | |
|000030d0| 20 20 20 20 20 20 20 20 | 66 69 72 73 74 20 63 68 | |first ch|
|000030e0| 61 72 61 63 74 65 72 20 | 6e 6f 74 20 69 6e 20 73 |aracter |not in s|
|000030f0| 65 74 3b 20 73 65 74 20 | 3d 20 27 27 69 66 20 61 |et; set |= ''if a|
|00003100| 62 73 65 6e 74 2e 0a 20 | 32 33 2c 31 20 52 6f 77 |bsent.. |23,1 Row|
|00003110| 20 43 68 61 72 20 46 75 | 6e 63 74 69 6f 6e 73 2c | Char Fu|nctions,|
|00003120| 0a 20 53 4f 55 4e 44 45 | 58 28 63 68 61 72 29 20 |. SOUNDE|X(char) |
|00003130| 20 20 20 20 52 65 74 75 | 72 6e 73 20 73 74 72 69 | Retu|rns stri|
|00003140| 6e 67 20 70 68 6f 6e 65 | 74 69 63 61 6c 6c 79 20 |ng phone|tically |
|00003150| 65 71 75 69 76 61 6c 65 | 6e 74 20 74 6f 20 63 68 |equivale|nt to ch|
|00003160| 61 72 2e 0a 20 32 34 2c | 31 20 52 6f 77 20 43 68 |ar.. 24,|1 Row Ch|
|00003170| 61 72 20 46 75 6e 63 74 | 69 6f 6e 73 2c 0a 20 53 |ar Funct|ions,. S|
|00003180| 55 42 53 54 52 28 63 68 | 61 72 2c 20 20 20 20 20 |UBSTR(ch|ar, |
|00003190| 20 52 65 74 75 72 6e 73 | 20 6e 20 63 68 61 72 61 | Returns| n chara|
|000031a0| 63 74 65 72 73 20 69 6e | 20 63 68 61 72 2c 20 73 |cters in| char, s|
|000031b0| 74 61 72 74 69 6e 67 20 | 61 74 20 63 68 61 72 20 |tarting |at char |
|000031c0| 63 2e 0a 20 32 35 2c 31 | 20 52 6f 77 20 43 68 61 |c.. 25,1| Row Cha|
|000031d0| 72 20 46 75 6e 63 74 69 | 6f 6e 73 2c 0a 20 20 20 |r Functi|ons,. |
|000031e0| 63 2c 20 6e 29 0a 20 32 | 36 2c 31 20 52 6f 77 20 |c, n). 2|6,1 Row |
|000031f0| 43 68 61 72 20 46 75 6e | 63 74 69 6f 6e 73 2c 0a |Char Fun|ctions,.|
|00003200| 20 54 52 41 4e 53 4c 41 | 54 45 28 63 68 61 72 2c | TRANSLA|TE(char,|
|00003210| 20 20 20 52 65 74 75 72 | 6e 73 20 63 68 61 72 20 | Retur|ns char |
|00003220| 77 69 74 68 20 65 61 63 | 68 20 66 69 6e 64 20 63 |with eac|h find c|
|00003230| 68 61 6e 67 65 64 20 74 | 6f 20 6e 65 77 2e 0a 20 |hanged t|o new.. |
|00003240| 32 37 2c 31 20 52 6f 77 | 20 43 68 61 72 20 46 75 |27,1 Row| Char Fu|
|00003250| 6e 63 74 69 6f 6e 73 2c | 0a 20 20 20 66 69 6e 64 |nctions,|. find|
|00003260| 2c 20 6e 65 77 29 0a 20 | 32 38 2c 31 20 52 6f 77 |, new). |28,1 Row|
|00003270| 20 43 68 61 72 20 46 75 | 6e 63 74 69 6f 6e 73 2c | Char Fu|nctions,|
|00003280| 0a 20 55 50 50 45 52 28 | 63 68 61 72 29 20 20 20 |. UPPER(|char) |
|00003290| 20 20 20 20 52 65 74 75 | 72 6e 73 20 63 68 61 72 | Retu|rns char|
|000032a0| 20 69 6e 20 55 50 50 45 | 52 43 41 53 45 2e 0a 20 | in UPPE|RCASE.. |
|000032b0| 32 39 2c 31 20 52 6f 77 | 20 43 68 61 72 20 46 75 |29,1 Row| Char Fu|
|000032c0| 6e 63 74 69 6f 6e 73 2c | 0a 0a 20 33 30 2c 31 20 |nctions,|.. 30,1 |
|000032d0| 52 6f 77 20 43 68 61 72 | 20 46 75 6e 63 74 69 6f |Row Char| Functio|
|000032e0| 6e 73 2c 0a 0a 20 33 31 | 2c 31 20 52 6f 77 20 43 |ns,.. 31|,1 Row C|
|000032f0| 68 61 72 20 46 75 6e 63 | 74 69 6f 6e 73 2c 0a 20 |har Func|tions,. |
|00003300| 53 65 65 20 61 6c 73 6f | 3a 20 31 20 72 6f 77 20 |See also|: 1 row |
|00003310| 6e 75 6d 62 65 72 2c 20 | 63 6f 6e 76 65 72 73 69 |number, |conversi|
|00003320| 6f 6e 2c 20 64 61 74 65 | 20 66 75 6e 63 74 69 6f |on, date| functio|
|00003330| 6e 73 2c 20 65 72 72 6f | 72 20 72 65 70 6f 72 74 |ns, erro|r report|
|00003340| 69 6e 67 2c 0a 20 33 32 | 2c 31 20 52 6f 77 20 43 |ing,. 32|,1 Row C|
|00003350| 68 61 72 20 46 75 6e 63 | 74 69 6f 6e 73 2c 0a 20 |har Func|tions,. |
|00003360| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00003370| 67 72 6f 75 70 2c 20 6f | 74 68 65 72 20 66 75 6e |group, o|ther fun|
|00003380| 63 74 69 6f 6e 73 2c 20 | 63 6f 6d 6d 61 6e 64 73 |ctions, |commands|
|00003390| 2c 20 6d 65 6e 75 2e 0a | 20 20 31 2c 31 20 52 6f |, menu..| 1,1 Ro|
|000033a0| 77 20 4e 75 6d 62 65 72 | 20 46 75 6e 63 74 69 6f |w Number| Functio|
|000033b0| 6e 73 2c 0a 0a 20 20 32 | 2c 31 20 52 6f 77 20 4e |ns,.. 2|,1 Row N|
|000033c0| 75 6d 62 65 72 20 46 75 | 6e 63 74 69 6f 6e 73 2c |umber Fu|nctions,|
|000033d0| 0a 0a 20 20 33 2c 31 20 | 52 6f 77 20 4e 75 6d 62 |.. 3,1 |Row Numb|
|000033e0| 65 72 20 46 75 6e 63 74 | 69 6f 6e 73 2c 0a 20 20 |er Funct|ions,. |
|000033f0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00003400| 20 31 20 52 6f 77 20 4e | 75 6d 62 65 72 20 46 75 | 1 Row N|umber Fu|
|00003410| 6e 63 74 69 6f 6e 73 0a | 20 20 34 2c 31 20 52 6f |nctions.| 4,1 Ro|
|00003420| 77 20 4e 75 6d 62 65 72 | 20 46 75 6e 63 74 69 6f |w Number| Functio|
|00003430| 6e 73 2c 0a 0a 20 20 35 | 2c 31 20 52 6f 77 20 4e |ns,.. 5|,1 Row N|
|00003440| 75 6d 62 65 72 20 46 75 | 6e 63 74 69 6f 6e 73 2c |umber Fu|nctions,|
|00003450| 0a 20 41 42 53 28 6e 29 | 20 20 20 20 20 20 20 20 |. ABS(n)| |
|00003460| 52 65 74 75 72 6e 73 20 | 74 68 65 20 61 62 73 6f |Returns |the abso|
|00003470| 6c 75 74 65 20 76 61 6c | 75 65 20 6f 66 20 6e 2e |lute val|ue of n.|
|00003480| 0a 20 20 36 2c 31 20 52 | 6f 77 20 4e 75 6d 62 65 |. 6,1 R|ow Numbe|
|00003490| 72 20 46 75 6e 63 74 69 | 6f 6e 73 2c 0a 0a 20 20 |r Functi|ons,.. |
|000034a0| 37 2c 31 20 52 6f 77 20 | 4e 75 6d 62 65 72 20 46 |7,1 Row |Number F|
|000034b0| 75 6e 63 74 69 6f 6e 73 | 2c 0a 20 43 45 49 4c 28 |unctions|,. CEIL(|
|000034c0| 6e 29 20 20 20 20 20 20 | 20 52 65 74 75 72 6e 73 |n) | Returns|
|000034d0| 20 74 68 65 20 73 6d 61 | 6c 6c 65 73 74 20 69 6e | the sma|llest in|
|000034e0| 74 65 67 65 72 20 67 72 | 65 61 74 65 72 20 74 68 |teger gr|eater th|
|000034f0| 61 6e 20 6f 72 20 65 71 | 75 61 6c 20 74 6f 20 6e |an or eq|ual to n|
|00003500| 2e 0a 20 20 38 2c 31 20 | 52 6f 77 20 4e 75 6d 62 |.. 8,1 |Row Numb|
|00003510| 65 72 20 46 75 6e 63 74 | 69 6f 6e 73 2c 0a 0a 20 |er Funct|ions,.. |
|00003520| 20 39 2c 31 20 52 6f 77 | 20 4e 75 6d 62 65 72 20 | 9,1 Row| Number |
|00003530| 46 75 6e 63 74 69 6f 6e | 73 2c 0a 20 46 4c 4f 4f |Function|s,. FLOO|
|00003540| 52 28 6e 29 20 20 20 20 | 20 20 52 65 74 75 72 6e |R(n) | Return|
|00003550| 73 20 74 68 65 20 6c 61 | 72 67 65 73 74 20 69 6e |s the la|rgest in|
|00003560| 74 65 67 65 72 20 6c 65 | 73 73 20 74 68 61 6e 20 |teger le|ss than |
|00003570| 6f 72 20 65 71 75 61 6c | 20 74 6f 20 6e 2e 0a 20 |or equal| to n.. |
|00003580| 31 30 2c 31 20 52 6f 77 | 20 4e 75 6d 62 65 72 20 |10,1 Row| Number |
|00003590| 46 75 6e 63 74 69 6f 6e | 73 2c 0a 0a 20 31 31 2c |Function|s,.. 11,|
|000035a0| 31 20 52 6f 77 20 4e 75 | 6d 62 65 72 20 46 75 6e |1 Row Nu|mber Fun|
|000035b0| 63 74 69 6f 6e 73 2c 0a | 20 4d 4f 44 28 6d 2c 6e |ctions,.| MOD(m,n|
|000035c0| 29 20 20 20 20 20 20 52 | 65 74 75 72 6e 73 20 72 |) R|eturns r|
|000035d0| 65 73 75 6c 74 20 6f 66 | 20 6d 20 64 69 76 69 64 |esult of| m divid|
|000035e0| 65 64 20 62 79 20 6e 3b | 20 6f 72 20 69 66 20 6e |ed by n;| or if n|
|000035f0| 3d 30 2c 20 6d 20 72 65 | 74 75 72 6e 65 64 2e 0a |=0, m re|turned..|
|00003600| 20 31 32 2c 31 20 52 6f | 77 20 4e 75 6d 62 65 72 | 12,1 Ro|w Number|
|00003610| 20 46 75 6e 63 74 69 6f | 6e 73 2c 0a 0a 20 31 33 | Functio|ns,.. 13|
|00003620| 2c 31 20 52 6f 77 20 4e | 75 6d 62 65 72 20 46 75 |,1 Row N|umber Fu|
|00003630| 6e 63 74 69 6f 6e 73 2c | 0a 20 50 4f 57 45 52 28 |nctions,|. POWER(|
|00003640| 6d 2c 6e 29 20 20 20 20 | 52 65 74 75 72 6e 73 20 |m,n) |Returns |
|00003650| 6d 20 72 61 69 73 65 64 | 20 74 6f 20 74 68 65 20 |m raised| to the |
|00003660| 6e 74 68 20 70 6f 77 65 | 72 3b 20 6e 20 6d 75 73 |nth powe|r; n mus|
|00003670| 74 20 62 65 20 61 6e 20 | 69 6e 74 65 67 65 72 2e |t be an |integer.|
|00003680| 0a 20 31 34 2c 31 20 52 | 6f 77 20 4e 75 6d 62 65 |. 14,1 R|ow Numbe|
|00003690| 72 20 46 75 6e 63 74 69 | 6f 6e 73 2c 0a 0a 20 31 |r Functi|ons,.. 1|
|000036a0| 35 2c 31 20 52 6f 77 20 | 4e 75 6d 62 65 72 20 46 |5,1 Row |Number F|
|000036b0| 75 6e 63 74 69 6f 6e 73 | 2c 0a 20 52 4f 55 4e 44 |unctions|,. ROUND|
|000036c0| 28 6d 2c 6e 29 20 20 20 | 20 52 65 74 75 72 6e 73 |(m,n) | Returns|
|000036d0| 20 6d 20 72 6f 75 6e 64 | 65 64 20 74 6f 20 6e 20 | m round|ed to n |
|000036e0| 28 6f 70 74 69 6f 6e 61 | 6c 29 20 64 65 63 69 6d |(optiona|l) decim|
|000036f0| 61 6c 20 70 6c 61 63 65 | 73 2e 0a 20 31 36 2c 31 |al place|s.. 16,1|
|00003700| 20 52 6f 77 20 4e 75 6d | 62 65 72 20 46 75 6e 63 | Row Num|ber Func|
|00003710| 74 69 6f 6e 73 2c 0a 0a | 20 31 37 2c 31 20 52 6f |tions,..| 17,1 Ro|
|00003720| 77 20 4e 75 6d 62 65 72 | 20 46 75 6e 63 74 69 6f |w Number| Functio|
|00003730| 6e 73 2c 0a 20 53 49 47 | 4e 28 6e 29 20 20 20 20 |ns,. SIG|N(n) |
|00003740| 20 20 20 52 65 74 75 72 | 6e 73 20 2d 31 20 69 66 | Retur|ns -1 if|
|00003750| 20 6e 20 69 73 20 6e 65 | 67 61 74 69 76 65 2c 20 | n is ne|gative, |
|00003760| 31 20 69 66 20 6e 20 69 | 73 20 70 6f 73 69 74 69 |1 if n i|s positi|
|00003770| 76 65 2c 20 30 20 69 66 | 20 6e 3d 30 2e 0a 20 31 |ve, 0 if| n=0.. 1|
|00003780| 38 2c 31 20 52 6f 77 20 | 4e 75 6d 62 65 72 20 46 |8,1 Row |Number F|
|00003790| 75 6e 63 74 69 6f 6e 73 | 2c 0a 0a 20 31 39 2c 31 |unctions|,.. 19,1|
|000037a0| 20 52 6f 77 20 4e 75 6d | 62 65 72 20 46 75 6e 63 | Row Num|ber Func|
|000037b0| 74 69 6f 6e 73 2c 0a 20 | 53 51 52 54 28 6e 29 20 |tions,. |SQRT(n) |
|000037c0| 20 20 20 20 20 20 52 65 | 74 75 72 6e 73 20 74 68 | Re|turns th|
|000037d0| 65 20 73 71 75 61 72 65 | 20 72 6f 6f 74 20 6f 66 |e square| root of|
|000037e0| 20 6e 2e 0a 20 32 30 2c | 31 20 52 6f 77 20 4e 75 | n.. 20,|1 Row Nu|
|000037f0| 6d 62 65 72 20 46 75 6e | 63 74 69 6f 6e 73 2c 0a |mber Fun|ctions,.|
|00003800| 0a 20 32 31 2c 31 20 52 | 6f 77 20 4e 75 6d 62 65 |. 21,1 R|ow Numbe|
|00003810| 72 20 46 75 6e 63 74 69 | 6f 6e 73 2c 0a 20 54 52 |r Functi|ons,. TR|
|00003820| 55 4e 43 28 6d 2c 6e 29 | 20 20 20 20 53 74 72 69 |UNC(m,n)| Stri|
|00003830| 70 73 20 6d 20 74 6f 20 | 6e 20 28 6f 70 74 29 20 |ps m to |n (opt) |
|00003840| 70 6c 61 63 65 73 3b 20 | 2d 6e 20 61 64 64 73 20 |places; |-n adds |
|00003850| 6e 20 7a 65 72 6f 73 20 | 74 6f 20 61 6e 20 69 6e |n zeros |to an in|
|00003860| 74 65 67 65 72 2e 0a 20 | 32 32 2c 31 20 52 6f 77 |teger.. |22,1 Row|
|00003870| 20 4e 75 6d 62 65 72 20 | 46 75 6e 63 74 69 6f 6e | Number |Function|
|00003880| 73 2c 0a 0a 20 32 33 2c | 31 20 52 6f 77 20 4e 75 |s,.. 23,|1 Row Nu|
|00003890| 6d 62 65 72 20 46 75 6e | 63 74 69 6f 6e 73 2c 0a |mber Fun|ctions,.|
|000038a0| 0a 20 32 34 2c 31 20 52 | 6f 77 20 4e 75 6d 62 65 |. 24,1 R|ow Numbe|
|000038b0| 72 20 46 75 6e 63 74 69 | 6f 6e 73 2c 0a 20 53 65 |r Functi|ons,. Se|
|000038c0| 65 20 61 6c 73 6f 3a 20 | 31 20 72 6f 77 20 63 68 |e also: |1 row ch|
|000038d0| 61 72 2c 20 63 6f 6e 76 | 65 72 73 69 6f 6e 2c 20 |ar, conv|ersion, |
|000038e0| 64 61 74 65 20 66 75 6e | 63 74 69 6f 6e 73 2c 20 |date fun|ctions, |
|000038f0| 65 72 72 6f 72 20 72 65 | 70 6f 72 74 69 6e 67 2c |error re|porting,|
|00003900| 0a 20 32 35 2c 31 20 52 | 6f 77 20 4e 75 6d 62 65 |. 25,1 R|ow Numbe|
|00003910| 72 20 46 75 6e 63 74 69 | 6f 6e 73 2c 0a 20 20 20 |r Functi|ons,. |
|00003920| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 67 | | g|
|00003930| 72 6f 75 70 2c 20 6f 74 | 68 65 72 20 66 75 6e 63 |roup, ot|her func|
|00003940| 74 69 6f 6e 73 2c 20 63 | 6f 6d 6d 61 6e 64 73 2c |tions, c|ommands,|
|00003950| 20 6d 65 6e 75 2e 0a 20 | 20 31 2c 40 2c 0a 20 40 | menu.. | 1,@,. @|
|00003960| 0a 20 20 32 2c 40 2c 0a | 20 20 20 20 20 20 20 20 |. 2,@,.| |
|00003970| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00003980| 20 20 20 20 20 20 20 40 | 20 28 22 61 74 22 20 73 | @| ("at" s|
|00003990| 69 67 6e 29 0a 20 20 33 | 2c 40 2c 0a 0a 20 20 34 |ign). 3|,@,.. 4|
|000039a0| 2c 40 2c 0a 20 40 20 66 | 69 6c 65 5f 6e 61 6d 65 |,@,. @ f|ile_name|
|000039b0| 5b 2e 65 78 74 20 5d 0a | 20 20 35 2c 40 2c 0a 0a |[.ext ].| 5,@,..|
|000039c0| 20 20 36 2c 40 2c 0a 20 | 52 75 6e 73 20 74 68 65 | 6,@,. |Runs the|
|000039d0| 20 73 70 65 63 69 66 69 | 65 64 20 63 6f 6d 6d 61 | specifi|ed comma|
|000039e0| 6e 64 20 66 69 6c 65 2e | 0a 20 20 37 2c 40 2c 0a |nd file.|. 7,@,.|
|000039f0| 0a 20 20 38 2c 40 2c 0a | 20 20 20 20 20 66 69 6c |. 8,@,.| fil|
|00003a00| 65 5f 6e 61 6d 65 5b 2e | 65 78 74 20 5d 0a 20 20 |e_name[.|ext ]. |
|00003a10| 39 2c 40 2c 0a 20 20 20 | 20 20 20 20 20 20 69 73 |9,@,. | is|
|00003a20| 20 74 68 65 20 63 6f 6d | 6d 61 6e 64 20 66 69 6c | the com|mand fil|
|00003a30| 65 20 79 6f 75 20 77 69 | 73 68 20 74 6f 20 72 75 |e you wi|sh to ru|
|00003a40| 6e 2e 20 49 66 20 79 6f | 75 20 6f 6d 69 74 20 65 |n. If yo|u omit e|
|00003a50| 78 74 2c 20 53 51 4c 2a | 50 6c 75 73 0a 20 31 30 |xt, SQL*|Plus. 10|
|00003a60| 2c 40 2c 0a 20 20 20 20 | 20 20 20 20 20 61 73 73 |,@,. | ass|
|00003a70| 75 6d 65 73 20 74 68 65 | 20 64 65 66 61 75 6c 74 |umes the| default|
|00003a80| 20 63 6f 6d 6d 61 6e 64 | 2d 66 69 6c 65 20 65 78 | command|-file ex|
|00003a90| 74 65 6e 73 69 6f 6e 20 | 28 75 73 75 61 6c 6c 79 |tension |(usually|
|00003aa0| 20 53 51 4c 29 2e 20 20 | 54 6f 0a 20 31 31 2c 40 | SQL). |To. 11,@|
|00003ab0| 2c 0a 20 20 20 20 20 20 | 20 20 20 63 68 61 6e 67 |,. | chang|
|00003ac0| 65 20 74 68 65 20 64 65 | 66 61 75 6c 74 20 65 78 |e the de|fault ex|
|00003ad0| 74 65 6e 73 69 6f 6e 2c | 20 75 73 65 20 74 68 65 |tension,| use the|
|00003ae0| 20 53 55 46 46 49 58 20 | 63 6c 61 75 73 65 20 6f | SUFFIX |clause o|
|00003af0| 66 20 74 68 65 20 53 45 | 54 0a 20 31 32 2c 40 2c |f the SE|T. 12,@,|
|00003b00| 0a 20 20 20 20 20 20 20 | 20 20 63 6f 6d 6d 61 6e |. | comman|
|00003b10| 64 2e 20 20 55 73 65 20 | 40 66 69 6c 65 5f 6e 61 |d. Use |@file_na|
|00003b20| 6d 65 20 6f 72 20 40 20 | 66 69 6c 65 5f 6e 61 6d |me or @ |file_nam|
|00003b30| 65 3b 20 74 68 65 20 73 | 70 61 63 65 20 69 73 20 |e; the s|pace is |
|00003b40| 6f 70 74 69 6f 6e 61 6c | 2e 0a 20 31 33 2c 40 2c |optional|.. 13,@,|
|00003b50| 0a 20 20 20 20 20 20 20 | 20 20 43 61 73 65 20 6d |. | Case m|
|00003b60| 61 79 20 62 65 20 73 69 | 67 6e 69 66 69 63 61 6e |ay be si|gnifican|
|00003b70| 74 20 69 6e 20 73 6f 6d | 65 20 6f 70 65 72 61 74 |t in som|e operat|
|00003b80| 69 6e 67 20 65 6e 76 69 | 72 6f 6e 6d 65 6e 74 73 |ing envi|ronments|
|00003b90| 2e 0a 20 31 34 2c 40 2c | 0a 0a 20 31 35 2c 40 2c |.. 14,@,|.. 15,@,|
|00003ba0| 0a 20 59 6f 75 20 63 61 | 6e 20 69 6e 63 6c 75 64 |. You ca|n includ|
|00003bb0| 65 20 69 6e 20 61 20 63 | 6f 6d 6d 61 6e 64 20 66 |e in a c|ommand f|
|00003bc0| 69 6c 65 20 61 6e 79 20 | 74 79 70 65 61 62 6c 65 |ile any |typeable|
|00003bd0| 20 63 6f 6d 6d 61 6e 64 | 2d 2d 75 73 75 61 6c 6c | command|--usuall|
|00003be0| 79 20 53 51 4c 20 6f 72 | 0a 20 31 36 2c 40 2c 0a |y SQL or|. 16,@,.|
|00003bf0| 20 53 51 4c 2a 50 6c 75 | 73 20 63 6f 6d 6d 61 6e | SQL*Plu|s comman|
|00003c00| 64 73 2e 20 20 54 68 65 | 20 40 20 63 6f 6d 6d 61 |ds. The| @ comma|
|00003c10| 6e 64 20 77 6f 72 6b 73 | 20 6c 69 6b 65 20 53 54 |nd works| like ST|
|00003c20| 41 52 54 2c 20 62 75 74 | 20 64 6f 65 73 20 6e 6f |ART, but| does no|
|00003c30| 74 20 61 6c 6c 6f 77 0a | 20 31 37 2c 40 2c 0a 20 |t allow.| 17,@,. |
|00003c40| 76 61 6c 75 65 73 20 74 | 6f 20 62 65 20 70 61 73 |values t|o be pas|
|00003c50| 73 65 64 20 74 6f 20 70 | 61 72 61 6d 65 74 65 72 |sed to p|arameter|
|00003c60| 73 2e 0a 20 31 38 2c 40 | 2c 0a 0a 20 31 39 2c 40 |s.. 18,@|,.. 19,@|
|00003c70| 2c 0a 20 45 78 61 6d 70 | 6c 65 73 3a 0a 20 32 30 |,. Examp|les:. 20|
|00003c80| 2c 40 2c 0a 0a 20 32 31 | 2c 40 2c 0a 20 20 20 20 |,@,.. 21|,@,. |
|00003c90| 20 54 6f 20 72 75 6e 20 | 61 20 63 6f 6d 6d 61 6e | To run |a comman|
|00003ca0| 64 20 66 69 6c 65 20 6e | 61 6d 65 64 20 50 52 49 |d file n|amed PRI|
|00003cb0| 4e 54 52 50 54 2e 53 51 | 4c 2c 20 65 6e 74 65 72 |NTRPT.SQ|L, enter|
|00003cc0| 3a 0a 20 32 32 2c 40 2c | 0a 0a 20 32 33 2c 40 2c |:. 22,@,|.. 23,@,|
|00003cd0| 0a 20 20 20 20 20 20 20 | 20 20 53 51 4c 3e 20 40 |. | SQL> @|
|00003ce0| 50 52 49 4e 54 52 50 54 | 0a 20 32 34 2c 40 2c 0a |PRINTRPT|. 24,@,.|
|00003cf0| 0a 20 32 35 2c 40 2c 0a | 0a 20 32 36 2c 40 2c 0a |. 25,@,.|. 26,@,.|
|00003d00| 20 20 20 20 20 54 6f 20 | 72 75 6e 20 74 68 65 20 | To |run the |
|00003d10| 63 6f 6d 6d 61 6e 64 20 | 66 69 6c 65 20 57 4b 52 |command |file WKR|
|00003d20| 50 54 20 77 69 74 68 20 | 74 68 65 20 65 78 74 65 |PT with |the exte|
|00003d30| 6e 73 69 6f 6e 20 51 52 | 59 2c 20 65 6e 74 65 72 |nsion QR|Y, enter|
|00003d40| 3a 0a 20 32 37 2c 40 2c | 0a 0a 20 32 38 2c 40 2c |:. 27,@,|.. 28,@,|
|00003d50| 0a 20 20 20 20 20 20 20 | 20 20 53 51 4c 3e 20 40 |. | SQL> @|
|00003d60| 57 4b 52 50 54 2e 51 52 | 59 0a 20 32 39 2c 40 2c |WKRPT.QR|Y. 29,@,|
|00003d70| 0a 0a 20 33 30 2c 40 2c | 0a 0a 20 33 31 2c 40 2c |.. 30,@,|.. 31,@,|
|00003d80| 0a 20 53 65 65 20 61 6c | 73 6f 3a 20 73 75 66 66 |. See al|so: suff|
|00003d90| 69 78 2c 20 73 74 61 72 | 74 2c 20 2f 2c 20 65 64 |ix, star|t, /, ed|
|00003da0| 69 74 2c 20 72 75 6e 2c | 20 67 65 74 2c 20 73 65 |it, run,| get, se|
|00003db0| 74 20 28 53 51 4c 20 62 | 75 66 66 65 72 29 2c 20 |t (SQL b|uffer), |
|00003dc0| 73 70 6f 6f 6c 2c 0a 20 | 33 32 2c 40 2c 0a 20 20 |spool,. |32,@,. |
|00003dd0| 20 20 20 20 20 20 20 20 | 20 6c 69 73 74 2c 20 73 | | list, s|
|00003de0| 61 76 65 2c 20 70 61 72 | 61 6d 65 74 65 72 73 2c |ave, par|ameters,|
|00003df0| 20 63 6f 6d 6d 61 6e 64 | 73 2c 20 6d 65 6e 75 2e | command|s, menu.|
|00003e00| 0a 20 20 31 2c 41 43 43 | 45 50 54 2c 0a 0a 20 20 |. 1,ACC|EPT,.. |
|00003e10| 32 2c 41 43 43 45 50 54 | 2c 0a 0a 20 20 33 2c 41 |2,ACCEPT|,.. 3,A|
|00003e20| 43 43 45 50 54 2c 0a 20 | 20 20 20 20 20 20 20 20 |CCEPT,. | |
|00003e30| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00003e40| 20 20 20 20 20 20 20 20 | 20 20 41 43 43 45 50 54 | | ACCEPT|
|00003e50| 0a 20 20 34 2c 41 43 43 | 45 50 54 2c 0a 0a 20 20 |. 4,ACC|EPT,.. |
|00003e60| 35 2c 41 43 43 45 50 54 | 2c 0a 20 41 43 43 5b 45 |5,ACCEPT|,. ACC[E|
|00003e70| 50 54 5d 20 76 61 72 69 | 61 62 6c 65 20 5b 4e 55 |PT] vari|able [NU|
|00003e80| 4d 5b 42 45 52 5d 7c 43 | 48 41 52 5d 20 5b 50 52 |M[BER]|C|HAR] [PR|
|00003e90| 4f 4d 50 54 20 74 65 78 | 74 7c 4e 4f 50 52 5b 4f |OMPT tex|t|NOPR[O|
|00003ea0| 4d 50 54 5d 5d 20 5b 48 | 49 44 45 5d 0a 20 20 36 |MPT]] [H|IDE]. 6|
|00003eb0| 2c 41 43 43 45 50 54 2c | 0a 0a 20 20 37 2c 41 43 |,ACCEPT,|.. 7,AC|
|00003ec0| 43 45 50 54 2c 0a 20 41 | 43 43 45 50 54 20 72 65 |CEPT,. A|CCEPT re|
|00003ed0| 61 64 73 20 61 20 6c 69 | 6e 65 20 6f 66 20 69 6e |ads a li|ne of in|
|00003ee0| 70 75 74 20 61 6e 64 20 | 73 74 6f 72 65 73 20 69 |put and |stores i|
|00003ef0| 74 20 69 6e 20 61 20 67 | 69 76 65 6e 20 75 73 65 |t in a g|iven use|
|00003f00| 72 20 76 61 72 69 61 62 | 6c 65 2e 0a 20 20 38 2c |r variab|le.. 8,|
|00003f10| 41 43 43 45 50 54 2c 0a | 0a 20 20 39 2c 41 43 43 |ACCEPT,.|. 9,ACC|
|00003f20| 45 50 54 2c 0a 20 20 20 | 20 20 76 61 72 69 61 62 |EPT,. | variab|
|00003f30| 6c 65 0a 20 31 30 2c 41 | 43 43 45 50 54 2c 0a 20 |le. 10,A|CCEPT,. |
|00003f40| 20 20 20 20 20 20 20 20 | 69 73 20 74 68 65 20 6e | |is the n|
|00003f50| 61 6d 65 20 6f 66 20 74 | 68 65 20 76 61 72 69 61 |ame of t|he varia|
|00003f60| 62 6c 65 20 69 6e 20 77 | 68 69 63 68 20 79 6f 75 |ble in w|hich you|
|00003f70| 20 77 69 73 68 20 74 6f | 20 73 74 6f 72 65 20 61 | wish to| store a|
|00003f80| 20 76 61 6c 75 65 2e 0a | 20 31 31 2c 41 43 43 45 | value..| 11,ACCE|
|00003f90| 50 54 2c 0a 20 20 20 20 | 20 20 20 20 20 49 66 20 |PT,. | If |
|00003fa0| 76 61 72 69 61 62 6c 65 | 20 64 6f 65 73 6e 27 74 |variable| doesn't|
|00003fb0| 20 65 78 69 73 74 2c 20 | 53 51 4c 2a 50 6c 75 73 | exist, |SQL*Plus|
|00003fc0| 20 63 72 65 61 74 65 73 | 20 69 74 2e 0a 20 31 32 | creates| it.. 12|
|00003fd0| 2c 41 43 43 45 50 54 2c | 0a 0a 20 31 33 2c 41 43 |,ACCEPT,|.. 13,AC|
|00003fe0| 43 45 50 54 2c 0a 20 20 | 20 20 20 4e 55 4d 5b 42 |CEPT,. | NUM[B|
|00003ff0| 45 52 5d 0a 20 31 34 2c | 41 43 43 45 50 54 2c 0a |ER]. 14,|ACCEPT,.|
|00004000| 20 20 20 20 20 20 20 20 | 20 72 65 73 74 72 69 63 | | restric|
|00004010| 74 73 20 74 68 65 20 64 | 61 74 61 74 79 70 65 20 |ts the d|atatype |
|00004020| 6f 66 20 76 61 72 69 61 | 62 6c 65 20 74 6f 20 74 |of varia|ble to t|
|00004030| 68 65 20 64 61 74 61 74 | 79 70 65 20 4e 55 4d 42 |he datat|ype NUMB|
|00004040| 45 52 2e 20 20 49 66 20 | 74 68 65 0a 20 31 35 2c |ER. If |the. 15,|
|00004050| 41 43 43 45 50 54 2c 0a | 20 20 20 20 20 20 20 20 |ACCEPT,.| |
|00004060| 20 72 65 70 6c 79 20 64 | 6f 65 73 20 6e 6f 74 20 | reply d|oes not |
|00004070| 6d 61 74 63 68 20 74 68 | 65 20 64 61 74 61 74 79 |match th|e dataty|
|00004080| 70 65 2c 20 41 43 43 45 | 50 54 20 67 69 76 65 73 |pe, ACCE|PT gives|
|00004090| 20 61 6e 20 65 72 72 6f | 72 20 6d 65 73 73 61 67 | an erro|r messag|
|000040a0| 65 0a 20 31 36 2c 41 43 | 43 45 50 54 2c 0a 20 20 |e. 16,AC|CEPT,. |
|000040b0| 20 20 20 20 20 20 20 61 | 6e 64 20 74 65 72 6d 69 | a|nd termi|
|000040c0| 6e 61 74 65 73 2e 0a 20 | 31 37 2c 41 43 43 45 50 |nates.. |17,ACCEP|
|000040d0| 54 2c 0a 0a 20 31 38 2c | 41 43 43 45 50 54 2c 0a |T,.. 18,|ACCEPT,.|
|000040e0| 20 20 20 20 20 43 48 41 | 52 0a 20 31 39 2c 41 43 | CHA|R. 19,AC|
|000040f0| 43 45 50 54 2c 0a 20 20 | 20 20 20 20 20 20 20 72 |CEPT,. | r|
|00004100| 65 73 74 72 69 63 74 73 | 20 74 68 65 20 64 61 74 |estricts| the dat|
|00004110| 61 74 79 70 65 20 6f 66 | 20 76 61 72 69 61 62 6c |atype of| variabl|
|00004120| 65 20 74 6f 20 74 68 65 | 20 64 61 74 61 74 79 70 |e to the| datatyp|
|00004130| 65 20 43 48 41 52 2e 20 | 20 49 66 20 74 68 65 0a |e CHAR. | If the.|
|00004140| 20 32 30 2c 41 43 43 45 | 50 54 2c 0a 20 20 20 20 | 20,ACCE|PT,. |
|00004150| 20 20 20 20 20 72 65 70 | 6c 79 20 64 6f 65 73 20 | rep|ly does |
|00004160| 6e 6f 74 20 6d 61 74 63 | 68 20 74 68 65 20 64 61 |not matc|h the da|
|00004170| 74 61 74 79 70 65 2c 20 | 41 43 43 45 50 54 20 67 |tatype, |ACCEPT g|
|00004180| 69 76 65 73 20 61 6e 20 | 65 72 72 6f 72 20 6d 65 |ives an |error me|
|00004190| 73 73 61 67 65 0a 20 32 | 31 2c 41 43 43 45 50 54 |ssage. 2|1,ACCEPT|
|000041a0| 2c 0a 20 20 20 20 20 20 | 20 20 20 61 6e 64 20 74 |,. | and t|
|000041b0| 65 72 6d 69 6e 61 74 65 | 73 2e 0a 20 32 32 2c 41 |erminate|s.. 22,A|
|000041c0| 43 43 45 50 54 2c 0a 0a | 20 32 33 2c 41 43 43 45 |CCEPT,..| 23,ACCE|
|000041d0| 50 54 2c 0a 20 20 20 20 | 20 50 52 4f 4d 50 54 20 |PT,. | PROMPT |
|000041e0| 74 65 78 74 0a 20 32 34 | 2c 41 43 43 45 50 54 2c |text. 24|,ACCEPT,|
|000041f0| 0a 20 20 20 20 20 20 20 | 20 20 64 69 73 70 6c 61 |. | displa|
|00004200| 79 73 20 74 65 78 74 20 | 6f 6e 2d 73 63 72 65 65 |ys text |on-scree|
|00004210| 6e 20 62 65 66 6f 72 65 | 20 61 63 63 65 70 74 69 |n before| accepti|
|00004220| 6e 67 20 74 68 65 20 76 | 61 6c 75 65 20 6f 66 20 |ng the v|alue of |
|00004230| 76 61 72 69 61 62 6c 65 | 0a 20 32 35 2c 41 43 43 |variable|. 25,ACC|
|00004240| 45 50 54 2c 0a 20 20 20 | 20 20 20 20 20 20 66 72 |EPT,. | fr|
|00004250| 6f 6d 20 74 68 65 20 75 | 73 65 72 2e 0a 20 32 36 |om the u|ser.. 26|
|00004260| 2c 41 43 43 45 50 54 2c | 0a 0a 20 32 37 2c 41 43 |,ACCEPT,|.. 27,AC|
|00004270| 43 45 50 54 2c 0a 20 20 | 20 20 20 4e 4f 50 52 5b |CEPT,. | NOPR[|
|00004280| 4f 4d 50 54 5d 0a 20 32 | 38 2c 41 43 43 45 50 54 |OMPT]. 2|8,ACCEPT|
|00004290| 2c 0a 20 20 20 20 20 20 | 20 20 20 73 6b 69 70 73 |,. | skips|
|000042a0| 20 61 20 6c 69 6e 65 20 | 61 6e 64 20 77 61 69 74 | a line |and wait|
|000042b0| 73 20 66 6f 72 20 69 6e | 70 75 74 3b 20 70 72 6f |s for in|put; pro|
|000042c0| 6d 70 74 20 6e 6f 74 20 | 64 69 73 70 6c 61 79 65 |mpt not |displaye|
|000042d0| 64 2e 0a 20 32 39 2c 41 | 43 43 45 50 54 2c 0a 0a |d.. 29,A|CCEPT,..|
|000042e0| 20 33 30 2c 41 43 43 45 | 50 54 2c 0a 20 20 20 20 | 30,ACCE|PT,. |
|000042f0| 20 48 49 44 45 0a 20 33 | 31 2c 41 43 43 45 50 54 | HIDE. 3|1,ACCEPT|
|00004300| 2c 0a 20 20 20 20 20 20 | 20 20 20 73 75 70 70 72 |,. | suppr|
|00004310| 65 73 73 65 73 20 74 68 | 65 20 64 69 73 70 6c 61 |esses th|e displa|
|00004320| 79 20 61 73 20 79 6f 75 | 20 74 79 70 65 20 74 68 |y as you| type th|
|00004330| 65 20 72 65 70 6c 79 2e | 0a 20 33 32 2c 41 43 43 |e reply.|. 32,ACC|
|00004340| 45 50 54 2c 0a 0a 20 33 | 33 2c 41 43 43 45 50 54 |EPT,.. 3|3,ACCEPT|
|00004350| 2c 0a 0a 20 33 34 2c 41 | 43 43 45 50 54 2c 0a 20 |,.. 34,A|CCEPT,. |
|00004360| 45 78 61 6d 70 6c 65 73 | 3a 20 54 6f 20 64 69 73 |Examples|: To dis|
|00004370| 70 6c 61 79 20 74 68 65 | 20 70 72 6f 6d 70 74 20 |play the| prompt |
|00004380| 74 65 78 74 20 22 53 61 | 6c 61 72 79 3a 20 22 20 |text "Sa|lary: " |
|00004390| 61 6e 64 20 70 6c 61 63 | 65 20 74 68 65 20 72 65 |and plac|e the re|
|000043a0| 70 6c 79 20 69 6e 20 61 | 0a 20 33 35 2c 41 43 43 |ply in a|. 35,ACC|
|000043b0| 45 50 54 2c 0a 20 20 20 | 20 20 20 20 20 20 20 20 |EPT,. | |
|000043c0| 4e 55 4d 42 45 52 20 76 | 61 72 69 61 62 6c 65 20 |NUMBER v|ariable |
|000043d0| 6e 61 6d 65 64 20 53 41 | 4c 41 52 59 2c 20 65 6e |named SA|LARY, en|
|000043e0| 74 65 72 3a 0a 20 33 36 | 2c 41 43 43 45 50 54 2c |ter:. 36|,ACCEPT,|
|000043f0| 0a 0a 20 33 37 2c 41 43 | 43 45 50 54 2c 0a 20 20 |.. 37,AC|CEPT,. |
|00004400| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 53 51 4c | | SQL|
|00004410| 3e 20 41 43 43 45 50 54 | 20 73 61 6c 61 72 79 20 |> ACCEPT| salary |
|00004420| 4e 55 4d 42 45 52 20 50 | 52 4f 4d 50 54 20 27 53 |NUMBER P|ROMPT 'S|
|00004430| 61 6c 61 72 79 3a 20 27 | 0a 20 33 38 2c 41 43 43 |alary: '|. 38,ACC|
|00004440| 45 50 54 2c 0a 0a 20 33 | 39 2c 41 43 43 45 50 54 |EPT,.. 3|9,ACCEPT|
|00004450| 2c 0a 0a 20 34 30 2c 41 | 43 43 45 50 54 2c 0a 20 |,.. 40,A|CCEPT,. |
|00004460| 20 20 20 20 20 20 20 20 | 20 20 54 6f 20 64 69 73 | | To dis|
|00004470| 70 6c 61 79 20 74 68 65 | 20 70 72 6f 6d 70 74 20 |play the| prompt |
|00004480| 22 50 61 73 73 77 6f 72 | 64 3a 20 22 2c 20 61 6e |"Passwor|d: ", an|
|00004490| 64 20 70 6c 61 63 65 20 | 74 68 65 20 72 65 70 6c |d place |the repl|
|000044a0| 79 20 69 6e 20 74 68 65 | 0a 20 34 31 2c 41 43 43 |y in the|. 41,ACC|
|000044b0| 45 50 54 2c 0a 20 20 20 | 20 20 20 20 20 20 20 20 |EPT,. | |
|000044c0| 43 48 41 52 20 76 61 72 | 69 61 62 6c 65 20 50 53 |CHAR var|iable PS|
|000044d0| 57 44 2c 20 77 68 69 6c | 65 20 73 75 70 70 72 65 |WD, whil|e suppre|
|000044e0| 73 73 69 6e 67 20 74 68 | 65 20 64 69 73 70 6c 61 |ssing th|e displa|
|000044f0| 79 2c 20 65 6e 74 65 72 | 3a 0a 20 34 32 2c 41 43 |y, enter|:. 42,AC|
|00004500| 43 45 50 54 2c 0a 0a 20 | 34 33 2c 41 43 43 45 50 |CEPT,.. |43,ACCEP|
|00004510| 54 2c 0a 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |T,. | |
|00004520| 20 20 53 51 4c 3e 20 41 | 43 43 45 50 54 20 70 73 | SQL> A|CCEPT ps|
|00004530| 77 64 20 43 48 41 52 20 | 50 52 4f 4d 50 54 20 27 |wd CHAR |PROMPT '|
|00004540| 50 61 73 73 77 6f 72 64 | 3a 20 27 20 48 49 44 45 |Password|: ' HIDE|
|00004550| 0a 20 34 34 2c 41 43 43 | 45 50 54 2c 0a 0a 20 34 |. 44,ACC|EPT,.. 4|
|00004560| 35 2c 41 43 43 45 50 54 | 2c 0a 0a 20 34 36 2c 41 |5,ACCEPT|,.. 46,A|
|00004570| 43 43 45 50 54 2c 0a 20 | 53 65 65 20 61 6c 73 6f |CCEPT,. |See also|
|00004580| 3a 20 64 65 66 69 6e 65 | 2c 20 69 6e 70 75 74 2c |: define|, input,|
|00004590| 20 70 72 6f 6d 70 74 2c | 20 70 61 72 61 6d 65 74 | prompt,| paramet|
|000045a0| 65 72 73 2c 20 63 6f 6d | 6d 61 6e 64 73 2c 20 6d |ers, com|mands, m|
|000045b0| 65 6e 75 2e 0a 20 20 31 | 2c 41 4c 54 45 52 20 43 |enu.. 1|,ALTER C|
|000045c0| 4c 55 53 54 45 52 2c 0a | 0a 20 20 32 2c 41 4c 54 |LUSTER,.|. 2,ALT|
|000045d0| 45 52 20 43 4c 55 53 54 | 45 52 2c 0a 0a 20 20 33 |ER CLUST|ER,.. 3|
|000045e0| 2c 41 4c 54 45 52 20 43 | 4c 55 53 54 45 52 2c 0a |,ALTER C|LUSTER,.|
|000045f0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00004600| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00004610| 41 4c 54 45 52 20 43 4c | 55 53 54 45 52 0a 20 20 |ALTER CL|USTER. |
|00004620| 34 2c 41 4c 54 45 52 20 | 43 4c 55 53 54 45 52 2c |4,ALTER |CLUSTER,|
|00004630| 0a 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |. | |
|00004640| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00004650| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00004660| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 53 51 4c | | SQL|
|00004670| 20 73 74 61 74 65 6d 65 | 6e 74 0a 20 20 35 2c 41 | stateme|nt. 5,A|
|00004680| 4c 54 45 52 20 43 4c 55 | 53 54 45 52 2c 0a 0a 20 |LTER CLU|STER,.. |
|00004690| 20 36 2c 41 4c 54 45 52 | 20 43 4c 55 53 54 45 52 | 6,ALTER| CLUSTER|
|000046a0| 2c 0a 20 41 4c 54 45 52 | 20 43 4c 55 53 54 45 52 |,. ALTER| CLUSTER|
|000046b0| 20 75 73 65 72 2e 63 6c | 75 73 74 65 72 20 20 20 | user.cl|uster |
|000046c0| 20 20 20 2d 2d 75 73 65 | 72 2e 20 61 6e 64 20 63 | --use|r. and c|
|000046d0| 6c 61 75 73 65 73 20 62 | 65 6c 6f 77 20 6f 70 74 |lauses b|elow opt|
|000046e0| 69 6f 6e 61 6c 0a 20 20 | 37 2c 41 4c 54 45 52 20 |ional. |7,ALTER |
|000046f0| 43 4c 55 53 54 45 52 2c | 0a 20 20 20 20 50 43 54 |CLUSTER,|. PCT|
|00004700| 55 53 45 44 20 69 6e 74 | 65 67 65 72 20 20 20 20 |USED int|eger |
|00004710| 20 20 20 20 20 20 20 20 | 20 20 2d 2d 6d 69 6e 20 | | --min |
|00004720| 73 70 61 63 65 20 75 73 | 65 20 70 65 72 20 62 6c |space us|e per bl|
|00004730| 6f 63 6b 3b 20 64 65 66 | 61 75 6c 74 20 69 73 20 |ock; def|ault is |
|00004740| 34 30 0a 20 20 38 2c 41 | 4c 54 45 52 20 43 4c 55 |40. 8,A|LTER CLU|
|00004750| 53 54 45 52 2c 0a 20 20 | 20 20 50 43 54 46 52 45 |STER,. | PCTFRE|
|00004760| 45 20 69 6e 74 65 67 65 | 72 20 20 20 20 20 20 20 |E intege|r |
|00004770| 20 20 20 20 20 20 20 2d | 2d 25 20 6f 66 20 62 6c | -|-% of bl|
|00004780| 6f 63 6b 20 66 6f 72 20 | 75 70 64 61 74 65 73 3b |ock for |updates;|
|00004790| 20 64 65 66 61 75 6c 74 | 20 69 73 20 31 30 0a 20 | default| is 10. |
|000047a0| 20 39 2c 41 4c 54 45 52 | 20 43 4c 55 53 54 45 52 | 9,ALTER| CLUSTER|
|000047b0| 2c 0a 20 20 20 20 53 49 | 5a 45 20 69 6e 74 65 67 |,. SI|ZE integ|
|000047c0| 65 72 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |er | |
|000047d0| 20 20 20 2d 2d 74 68 65 | 20 6e 75 6d 62 65 72 20 | --the| number |
|000047e0| 6f 66 20 63 6c 75 73 74 | 65 72 20 6b 65 79 73 20 |of clust|er keys |
|000047f0| 73 74 6f 72 65 64 0a 20 | 31 30 2c 41 4c 54 45 52 |stored. |10,ALTER|
|00004800| 20 43 4c 55 53 54 45 52 | 2c 0a 20 20 20 20 49 4e | CLUSTER|,. IN|
|00004810| 49 54 52 41 4e 53 20 69 | 6e 74 65 67 65 72 20 20 |ITRANS i|nteger |
|00004820| 20 20 20 20 20 20 20 20 | 20 20 20 2d 2d 69 6e 69 | | --ini|
|00004830| 74 69 61 6c 20 6e 75 6d | 62 65 72 20 6f 66 20 74 |tial num|ber of t|
|00004840| 72 61 6e 73 61 63 74 69 | 6f 6e 73 20 65 6e 74 72 |ransacti|ons entr|
|00004850| 69 65 73 0a 20 31 31 2c | 41 4c 54 45 52 20 43 4c |ies. 11,|ALTER CL|
|00004860| 55 53 54 45 52 2c 0a 20 | 20 20 20 4d 41 58 54 52 |USTER,. | MAXTR|
|00004870| 41 4e 53 20 69 6e 74 65 | 67 65 72 20 20 20 20 20 |ANS inte|ger |
|00004880| 20 20 20 20 20 20 20 20 | 2d 2d 6d 61 78 69 6d 75 | |--maximu|
|00004890| 6d 20 6e 75 6d 62 65 72 | 20 6f 66 20 74 72 61 6e |m number| of tran|
|000048a0| 73 61 63 74 69 6f 6e 73 | 20 61 74 20 6f 6e 63 65 |sactions| at once|
|000048b0| 0a 20 31 32 2c 41 4c 54 | 45 52 20 43 4c 55 53 54 |. 12,ALT|ER CLUST|
|000048c0| 45 52 2c 0a 20 20 20 20 | 53 54 4f 52 41 47 45 20 |ER,. |STORAGE |
|000048d0| 63 6c 61 75 73 65 20 20 | 20 20 20 20 20 20 20 20 |clause | |
|000048e0| 20 20 20 20 20 2d 2d 63 | 6f 6e 74 72 6f 6c 73 20 | --c|ontrols |
|000048f0| 73 70 61 63 65 20 61 6c | 6c 6f 63 61 74 69 6f 6e |space al|location|
|00004900| 0a 20 31 33 2c 41 4c 54 | 45 52 20 43 4c 55 53 54 |. 13,ALT|ER CLUST|
|00004910| 45 52 2c 0a 0a 20 31 34 | 2c 41 4c 54 45 52 20 43 |ER,.. 14|,ALTER C|
|00004920| 4c 55 53 54 45 52 2c 0a | 0a 20 31 35 2c 41 4c 54 |LUSTER,.|. 15,ALT|
|00004930| 45 52 20 43 4c 55 53 54 | 45 52 2c 0a 20 41 4c 54 |ER CLUST|ER,. ALT|
|00004940| 45 52 20 43 4c 55 53 54 | 45 52 20 72 65 64 65 66 |ER CLUST|ER redef|
|00004950| 69 6e 65 73 20 61 20 63 | 6c 75 73 74 65 72 27 73 |ines a c|luster's|
|00004960| 20 66 75 74 75 72 65 20 | 73 74 6f 72 61 67 65 20 | future |storage |
|00004970| 61 6c 6c 6f 63 61 74 69 | 6f 6e 73 2e 20 20 59 6f |allocati|ons. Yo|
|00004980| 75 20 63 61 6e 0a 20 31 | 36 2c 41 4c 54 45 52 20 |u can. 1|6,ALTER |
|00004990| 43 4c 55 53 54 45 52 2c | 0a 20 63 68 61 6e 67 65 |CLUSTER,|. change|
|000049a0| 20 61 6e 79 20 6f 66 20 | 74 68 65 20 70 61 72 61 | any of |the para|
|000049b0| 6d 65 74 65 72 73 20 6c | 69 73 74 65 64 2c 20 62 |meters l|isted, b|
|000049c0| 75 74 20 79 6f 75 20 63 | 61 6e 6e 6f 74 3a 0a 20 |ut you c|annot:. |
|000049d0| 31 37 2c 41 4c 54 45 52 | 20 43 4c 55 53 54 45 52 |17,ALTER| CLUSTER|
|000049e0| 2c 0a 0a 20 31 38 2c 41 | 4c 54 45 52 20 43 4c 55 |,.. 18,A|LTER CLU|
|000049f0| 53 54 45 52 2c 0a 20 20 | 20 20 2d 20 20 63 68 61 |STER,. | - cha|
|00004a00| 6e 67 65 20 74 68 65 20 | 6e 75 6d 62 65 72 20 6f |nge the |number o|
|00004a10| 72 20 6e 61 6d 65 20 6f | 66 20 63 6f 6c 75 6d 6e |r name o|f column|
|00004a20| 73 20 69 6e 20 61 20 63 | 6c 75 73 74 65 72 20 6b |s in a c|luster k|
|00004a30| 65 79 0a 20 31 39 2c 41 | 4c 54 45 52 20 43 4c 55 |ey. 19,A|LTER CLU|
|00004a40| 53 54 45 52 2c 0a 20 20 | 20 20 2d 20 20 61 6c 74 |STER,. | - alt|
|00004a50| 65 72 20 74 68 65 20 4d | 49 4e 45 58 54 45 4e 54 |er the M|INEXTENT|
|00004a60| 53 20 70 61 72 61 6d 65 | 74 65 72 0a 20 32 30 2c |S parame|ter. 20,|
|00004a70| 41 4c 54 45 52 20 43 4c | 55 53 54 45 52 2c 0a 20 |ALTER CL|USTER,. |
|00004a80| 20 20 20 2d 20 20 61 6c | 74 65 72 20 61 6e 79 20 | - al|ter any |
|00004a90| 70 61 72 61 6d 65 74 65 | 72 73 20 61 66 66 65 63 |paramete|rs affec|
|00004aa0| 74 69 6e 67 20 62 6c 6f | 63 6b 73 20 61 6c 72 65 |ting blo|cks alre|
|00004ab0| 61 64 79 20 61 6c 6c 6f | 63 61 74 65 64 0a 20 32 |ady allo|cated. 2|
|00004ac0| 31 2c 41 4c 54 45 52 20 | 43 4c 55 53 54 45 52 2c |1,ALTER |CLUSTER,|
|00004ad0| 0a 20 20 20 20 2d 20 20 | 72 65 6d 6f 76 65 20 74 |. - |remove t|
|00004ae0| 61 62 6c 65 73 20 66 72 | 6f 6d 20 61 20 63 6c 75 |ables fr|om a clu|
|00004af0| 73 74 65 72 20 28 75 73 | 65 20 44 52 4f 50 20 43 |ster (us|e DROP C|
|00004b00| 4c 55 53 54 45 52 20 61 | 6e 64 20 44 52 4f 50 20 |LUSTER a|nd DROP |
|00004b10| 54 41 42 4c 45 29 0a 20 | 32 32 2c 41 4c 54 45 52 |TABLE). |22,ALTER|
|00004b20| 20 43 4c 55 53 54 45 52 | 2c 0a 20 20 20 20 2d 20 | CLUSTER|,. - |
|00004b30| 20 61 6c 74 65 72 20 61 | 20 63 6c 75 73 74 65 72 | alter a| cluster|
|00004b40| 27 73 20 74 61 62 6c 65 | 73 70 61 63 65 0a 20 32 |'s table|space. 2|
|00004b50| 33 2c 41 4c 54 45 52 20 | 43 4c 55 53 54 45 52 2c |3,ALTER |CLUSTER,|
|00004b60| 0a 0a 20 32 34 2c 41 4c | 54 45 52 20 43 4c 55 53 |.. 24,AL|TER CLUS|
|00004b70| 54 45 52 2c 0a 20 53 65 | 65 20 61 6c 73 6f 3a 20 |TER,. Se|e also: |
|00004b80| 63 72 65 61 74 65 20 63 | 6c 75 73 74 65 72 2c 20 |create c|luster, |
|00004b90| 63 72 65 61 74 65 20 74 | 61 62 6c 65 2c 20 63 6f |create t|able, co|
|00004ba0| 6d 6d 61 6e 64 73 2c 20 | 6d 65 6e 75 2e 0a 20 20 |mmands, |menu.. |
|00004bb0| 31 2c 41 4c 54 45 52 20 | 44 41 54 41 42 41 53 45 |1,ALTER |DATABASE|
|00004bc0| 2c 0a 0a 20 20 32 2c 41 | 4c 54 45 52 20 44 41 54 |,.. 2,A|LTER DAT|
|00004bd0| 41 42 41 53 45 2c 0a 0a | 20 20 33 2c 41 4c 54 45 |ABASE,..| 3,ALTE|
|00004be0| 52 20 44 41 54 41 42 41 | 53 45 2c 0a 20 20 20 20 |R DATABA|SE,. |
|00004bf0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00004c00| 20 20 20 20 20 20 20 20 | 20 20 20 20 41 4c 54 45 | | ALTE|
|00004c10| 52 20 44 41 54 41 42 41 | 53 45 0a 20 20 34 2c 41 |R DATABA|SE. 4,A|
|00004c20| 4c 54 45 52 20 44 41 54 | 41 42 41 53 45 2c 0a 20 |LTER DAT|ABASE,. |
|00004c30| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00004c40| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00004c50| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00004c60| 20 20 20 20 20 20 20 53 | 51 4c 20 73 74 61 74 65 | S|QL state|
|00004c70| 6d 65 6e 74 0a 20 20 35 | 2c 41 4c 54 45 52 20 44 |ment. 5|,ALTER D|
|00004c80| 41 54 41 42 41 53 45 2c | 0a 20 41 4c 54 45 52 20 |ATABASE,|. ALTER |
|00004c90| 44 41 54 41 42 41 53 45 | 20 64 61 74 61 62 61 73 |DATABASE| databas|
|00004ca0| 65 0a 20 20 36 2c 41 4c | 54 45 52 20 44 41 54 41 |e. 6,AL|TER DATA|
|00004cb0| 42 41 53 45 2c 0a 20 20 | 20 20 41 44 44 20 4c 4f |BASE,. | ADD LO|
|00004cc0| 47 46 49 4c 45 20 27 66 | 69 6c 65 6e 61 6d 65 27 |GFILE 'f|ilename'|
|00004cd0| 20 53 49 5a 45 20 69 6e | 74 65 67 65 72 20 4b 20 | SIZE in|teger K |
|00004ce0| 7c 20 4d 20 52 45 55 53 | 45 2c 2e 2e 2e 0a 20 20 || M REUS|E,.... |
|00004cf0| 37 2c 41 4c 54 45 52 20 | 44 41 54 41 42 41 53 45 |7,ALTER |DATABASE|
|00004d00| 2c 0a 20 20 20 20 44 52 | 4f 50 20 4c 4f 47 46 49 |,. DR|OP LOGFI|
|00004d10| 4c 45 20 27 66 69 6c 65 | 6e 61 6d 65 27 2c 20 27 |LE 'file|name', '|
|00004d20| 66 69 6c 65 6e 61 6d 65 | 27 2c 2e 2e 2e 0a 20 20 |filename|',.... |
|00004d30| 38 2c 41 4c 54 45 52 20 | 44 41 54 41 42 41 53 45 |8,ALTER |DATABASE|
|00004d40| 2c 0a 20 20 20 20 52 45 | 4e 41 4d 45 20 46 49 4c |,. RE|NAME FIL|
|00004d50| 45 20 27 66 69 6c 65 6e | 61 6d 65 27 2c 20 27 66 |E 'filen|ame', 'f|
|00004d60| 69 6c 65 6e 61 6d 65 27 | 2c 2e 2e 2e 0a 20 20 39 |ilename'|,.... 9|
|00004d70| 2c 41 4c 54 45 52 20 44 | 41 54 41 42 41 53 45 2c |,ALTER D|ATABASE,|
|00004d80| 0a 20 20 20 20 20 20 20 | 20 20 20 20 20 20 54 4f |. | TO|
|00004d90| 20 27 66 69 6c 65 6e 61 | 6d 65 27 2c 20 27 66 69 | 'filena|me', 'fi|
|00004da0| 6c 65 6e 61 6d 65 27 2c | 2e 2e 2e 0a 20 31 30 2c |lename',|.... 10,|
|00004db0| 41 4c 54 45 52 20 44 41 | 54 41 42 41 53 45 2c 0a |ALTER DA|TABASE,.|
|00004dc0| 20 20 20 20 41 52 43 48 | 49 56 45 4c 4f 47 20 7c | ARCH|IVELOG ||
|00004dd0| 20 4e 4f 41 52 43 48 49 | 56 45 4c 4f 47 0a 20 31 | NOARCHI|VELOG. 1|
|00004de0| 31 2c 41 4c 54 45 52 20 | 44 41 54 41 42 41 53 45 |1,ALTER |DATABASE|
|00004df0| 2c 0a 20 20 20 20 4d 4f | 55 4e 54 20 53 48 41 52 |,. MO|UNT SHAR|
|00004e00| 45 44 20 7c 20 45 58 43 | 4c 55 53 49 56 45 0a 20 |ED | EXC|LUSIVE. |
|00004e10| 31 32 2c 41 4c 54 45 52 | 20 44 41 54 41 42 41 53 |12,ALTER| DATABAS|
|00004e20| 45 2c 0a 20 20 20 20 44 | 49 53 4d 4f 55 4e 54 0a |E,. D|ISMOUNT.|
|00004e30| 20 31 33 2c 41 4c 54 45 | 52 20 44 41 54 41 42 41 | 13,ALTE|R DATABA|
|00004e40| 53 45 2c 0a 20 20 20 20 | 4f 50 45 4e 20 7c 20 43 |SE,. |OPEN | C|
|00004e50| 4c 4f 53 45 20 4e 4f 52 | 4d 41 4c 20 7c 20 49 4d |LOSE NOR|MAL | IM|
|00004e60| 4d 45 44 49 41 54 45 0a | 20 31 34 2c 41 4c 54 45 |MEDIATE.| 14,ALTE|
|00004e70| 52 20 44 41 54 41 42 41 | 53 45 2c 0a 0a 20 31 35 |R DATABA|SE,.. 15|
|00004e80| 2c 41 4c 54 45 52 20 44 | 41 54 41 42 41 53 45 2c |,ALTER D|ATABASE,|
|00004e90| 0a 20 55 73 65 20 74 68 | 65 20 41 4c 54 45 52 20 |. Use th|e ALTER |
|00004ea0| 44 41 54 41 42 41 53 45 | 20 73 74 61 74 65 6d 65 |DATABASE| stateme|
|00004eb0| 6e 74 20 74 6f 20 6d 6f | 75 6e 74 20 61 20 64 61 |nt to mo|unt a da|
|00004ec0| 74 61 62 61 73 65 2c 20 | 65 69 74 68 65 72 20 73 |tabase, |either s|
|00004ed0| 68 61 72 65 64 0a 20 31 | 36 2c 41 4c 54 45 52 20 |hared. 1|6,ALTER |
|00004ee0| 44 41 54 41 42 41 53 45 | 2c 0a 20 6f 72 20 65 78 |DATABASE|,. or ex|
|00004ef0| 63 6c 75 73 69 76 65 3b | 20 6f 70 65 6e 20 6f 72 |clusive;| open or|
|00004f00| 20 63 6c 6f 73 65 20 61 | 20 64 61 74 61 62 61 73 | close a| databas|
|00004f10| 65 3b 20 61 64 64 2c 20 | 64 72 6f 70 2c 20 6f 72 |e; add, |drop, or|
|00004f20| 20 72 65 6e 61 6d 65 20 | 61 20 72 65 64 6f 0a 20 | rename |a redo. |
|00004f30| 31 37 2c 41 4c 54 45 52 | 20 44 41 54 41 42 41 53 |17,ALTER| DATABAS|
|00004f40| 45 2c 0a 20 6c 6f 67 20 | 66 69 6c 65 3b 20 6f 72 |E,. log |file; or|
|00004f50| 20 72 65 6e 61 6d 65 20 | 61 20 64 61 74 61 62 61 | rename |a databa|
|00004f60| 73 65 20 66 69 6c 65 2e | 20 20 59 6f 75 20 63 61 |se file.| You ca|
|00004f70| 6e 20 61 6c 73 6f 20 73 | 65 74 20 74 68 65 20 72 |n also s|et the r|
|00004f80| 65 64 6f 20 6c 6f 67 0a | 20 31 38 2c 41 4c 54 45 |edo log.| 18,ALTE|
|00004f90| 52 20 44 41 54 41 42 41 | 53 45 2c 0a 20 74 6f 20 |R DATABA|SE,. to |
|00004fa0| 62 65 20 61 72 63 68 69 | 76 65 64 20 28 75 73 65 |be archi|ved (use|
|00004fb0| 66 75 6c 20 66 6f 72 20 | 6d 65 64 69 61 20 72 65 |ful for |media re|
|00004fc0| 63 6f 76 65 72 79 29 2c | 20 6f 72 20 6e 6f 74 20 |covery),| or not |
|00004fd0| 61 72 63 68 69 76 65 64 | 20 28 75 73 65 66 75 6c |archived| (useful|
|00004fe0| 0a 20 31 39 2c 41 4c 54 | 45 52 20 44 41 54 41 42 |. 19,ALT|ER DATAB|
|00004ff0| 41 53 45 2c 0a 20 6f 6e | 6c 79 20 66 6f 72 20 69 |ASE,. on|ly for i|
|00005000| 6e 73 74 61 6e 63 65 20 | 72 65 63 6f 76 65 72 79 |nstance |recovery|
|00005010| 29 2e 20 20 49 66 20 64 | 61 74 61 62 61 73 65 20 |). If d|atabase |
|00005020| 69 73 20 6f 6d 69 74 74 | 65 64 2c 20 74 68 65 20 |is omitt|ed, the |
|00005030| 76 61 6c 75 65 20 66 6f | 72 0a 20 32 30 2c 41 4c |value fo|r. 20,AL|
|00005040| 54 45 52 20 44 41 54 41 | 42 41 53 45 2c 0a 20 44 |TER DATA|BASE,. D|
|00005050| 42 5f 4e 41 4d 45 20 69 | 6e 20 74 68 65 20 63 75 |B_NAME i|n the cu|
|00005060| 72 72 65 6e 74 20 49 4e | 49 54 2e 4f 52 41 20 66 |rrent IN|IT.ORA f|
|00005070| 69 6c 65 20 69 73 20 61 | 73 73 75 6d 65 64 2e 0a |ile is a|ssumed..|
|00005080| 20 32 31 2c 41 4c 54 45 | 52 20 44 41 54 41 42 41 | 21,ALTE|R DATABA|
|00005090| 53 45 2c 0a 0a 20 32 32 | 2c 41 4c 54 45 52 20 44 |SE,.. 22|,ALTER D|
|000050a0| 41 54 41 42 41 53 45 2c | 0a 0a 20 32 33 2c 41 4c |ATABASE,|.. 23,AL|
|000050b0| 54 45 52 20 44 41 54 41 | 42 41 53 45 2c 0a 20 53 |TER DATA|BASE,. S|
|000050c0| 65 65 20 61 6c 73 6f 3a | 20 63 72 65 61 74 65 20 |ee also:| create |
|000050d0| 64 61 74 61 62 61 73 65 | 2c 20 63 6f 6d 6d 61 6e |database|, comman|
|000050e0| 64 73 2c 20 6d 65 6e 75 | 2e 0a 20 20 31 2c 41 4c |ds, menu|.. 1,AL|
|000050f0| 54 45 52 20 49 4e 44 45 | 58 2c 0a 0a 20 20 32 2c |TER INDE|X,.. 2,|
|00005100| 41 4c 54 45 52 20 49 4e | 44 45 58 2c 0a 0a 20 20 |ALTER IN|DEX,.. |
|00005110| 33 2c 41 4c 54 45 52 20 | 49 4e 44 45 58 2c 0a 20 |3,ALTER |INDEX,. |
|00005120| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00005130| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00005140| 41 4c 54 45 52 20 49 4e | 44 45 58 0a 20 20 34 2c |ALTER IN|DEX. 4,|
|00005150| 41 4c 54 45 52 20 49 4e | 44 45 58 2c 0a 20 20 20 |ALTER IN|DEX,. |
|00005160| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00005170| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00005180| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00005190| 20 20 20 20 20 20 20 53 | 51 4c 20 73 74 61 74 65 | S|QL state|
|000051a0| 6d 65 6e 74 0a 20 20 35 | 2c 41 4c 54 45 52 20 49 |ment. 5|,ALTER I|
|000051b0| 4e 44 45 58 2c 0a 20 41 | 4c 54 45 52 20 49 4e 44 |NDEX,. A|LTER IND|
|000051c0| 45 58 20 75 73 65 72 2e | 69 6e 64 65 78 0a 20 20 |EX user.|index. |
|000051d0| 36 2c 41 4c 54 45 52 20 | 49 4e 44 45 58 2c 0a 20 |6,ALTER |INDEX,. |
|000051e0| 20 20 20 49 4e 49 54 52 | 41 4e 53 20 69 6e 74 65 | INITR|ANS inte|
|000051f0| 67 65 72 0a 20 20 37 2c | 41 4c 54 45 52 20 49 4e |ger. 7,|ALTER IN|
|00005200| 44 45 58 2c 0a 20 20 20 | 20 4d 41 58 54 52 41 4e |DEX,. | MAXTRAN|
|00005210| 53 20 69 6e 74 65 67 65 | 72 0a 20 20 38 2c 41 4c |S intege|r. 8,AL|
|00005220| 54 45 52 20 49 4e 44 45 | 58 2c 0a 20 20 20 20 53 |TER INDE|X,. S|
|00005230| 54 4f 52 41 47 45 20 63 | 6c 61 75 73 65 0a 20 20 |TORAGE c|lause. |
|00005240| 39 2c 41 4c 54 45 52 20 | 49 4e 44 45 58 2c 0a 0a |9,ALTER |INDEX,..|
|00005250| 20 31 30 2c 41 4c 54 45 | 52 20 49 4e 44 45 58 2c | 10,ALTE|R INDEX,|
|00005260| 0a 20 55 73 65 20 74 68 | 65 20 41 4c 54 45 52 20 |. Use th|e ALTER |
|00005270| 49 4e 44 45 58 20 73 74 | 61 74 65 6d 65 6e 74 20 |INDEX st|atement |
|00005280| 74 6f 20 63 68 61 6e 67 | 65 20 66 75 74 75 72 65 |to chang|e future|
|00005290| 20 73 74 6f 72 61 67 65 | 20 61 6c 6c 6f 63 61 74 | storage| allocat|
|000052a0| 69 6f 6e 73 20 66 6f 72 | 0a 20 31 31 2c 41 4c 54 |ions for|. 11,ALT|
|000052b0| 45 52 20 49 4e 44 45 58 | 2c 0a 20 69 6e 64 65 78 |ER INDEX|,. index|
|000052c0| 20 62 6c 6f 63 6b 73 2e | 20 20 49 4e 49 54 52 41 | blocks.| INITRA|
|000052d0| 4e 53 2c 20 4d 41 58 54 | 52 41 4e 53 2c 20 61 6e |NS, MAXT|RANS, an|
|000052e0| 64 20 53 54 4f 52 41 47 | 45 20 77 6f 72 6b 20 74 |d STORAG|E work t|
|000052f0| 68 65 20 73 61 6d 65 20 | 77 61 79 20 74 68 65 79 |he same |way they|
|00005300| 0a 20 31 32 2c 41 4c 54 | 45 52 20 49 4e 44 45 58 |. 12,ALT|ER INDEX|
|00005310| 2c 0a 20 64 6f 20 69 6e | 20 74 68 65 20 43 52 45 |,. do in| the CRE|
|00005320| 41 54 45 20 54 41 42 4c | 45 20 73 74 61 74 65 6d |ATE TABL|E statem|
|00005330| 65 6e 74 2e 0a 20 31 33 | 2c 41 4c 54 45 52 20 49 |ent.. 13|,ALTER I|
|00005340| 4e 44 45 58 2c 0a 0a 20 | 31 34 2c 41 4c 54 45 52 |NDEX,.. |14,ALTER|
|00005350| 20 49 4e 44 45 58 2c 0a | 0a 20 31 35 2c 41 4c 54 | INDEX,.|. 15,ALT|
|00005360| 45 52 20 49 4e 44 45 58 | 2c 0a 20 53 65 65 20 61 |ER INDEX|,. See a|
|00005370| 6c 73 6f 3a 20 63 72 65 | 61 74 65 20 69 6e 64 65 |lso: cre|ate inde|
|00005380| 78 2c 20 63 72 65 61 74 | 65 20 74 61 62 6c 65 2c |x, creat|e table,|
|00005390| 20 63 6f 6d 6d 61 6e 64 | 73 2c 20 6d 65 6e 75 2e | command|s, menu.|
|000053a0| 0a 20 20 31 2c 41 4c 54 | 45 52 20 52 4f 4c 4c 42 |. 1,ALT|ER ROLLB|
|000053b0| 41 43 4b 20 53 45 47 4d | 45 4e 54 2c 0a 0a 20 20 |ACK SEGM|ENT,.. |
|000053c0| 32 2c 41 4c 54 45 52 20 | 52 4f 4c 4c 42 41 43 4b |2,ALTER |ROLLBACK|
|000053d0| 20 53 45 47 4d 45 4e 54 | 2c 0a 0a 20 20 33 2c 41 | SEGMENT|,.. 3,A|
|000053e0| 4c 54 45 52 20 52 4f 4c | 4c 42 41 43 4b 20 53 45 |LTER ROL|LBACK SE|
|000053f0| 47 4d 45 4e 54 2c 0a 20 | 20 20 20 20 20 20 20 20 |GMENT,. | |
|00005400| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00005410| 20 20 20 20 41 4c 54 45 | 52 20 52 4f 4c 4c 42 41 | ALTE|R ROLLBA|
|00005420| 43 4b 20 53 45 47 4d 45 | 4e 54 0a 20 20 34 2c 41 |CK SEGME|NT. 4,A|
|00005430| 4c 54 45 52 20 52 4f 4c | 4c 42 41 43 4b 20 53 45 |LTER ROL|LBACK SE|
|00005440| 47 4d 45 4e 54 2c 0a 20 | 20 20 20 20 20 20 20 20 |GMENT,. | |
|00005450| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00005460| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00005470| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00005480| 20 20 20 53 51 4c 20 73 | 74 61 74 65 6d 65 6e 74 | SQL s|tatement|
|00005490| 0a 20 20 35 2c 41 4c 54 | 45 52 20 52 4f 4c 4c 42 |. 5,ALT|ER ROLLB|
|000054a0| 41 43 4b 20 53 45 47 4d | 45 4e 54 2c 0a 20 41 4c |ACK SEGM|ENT,. AL|
|000054b0| 54 45 52 20 50 55 42 4c | 49 43 20 52 4f 4c 4c 42 |TER PUBL|IC ROLLB|
|000054c0| 41 43 4b 20 53 45 47 4d | 45 4e 54 20 73 65 67 6d |ACK SEGM|ENT segm|
|000054d0| 65 6e 74 0a 20 20 36 2c | 41 4c 54 45 52 20 52 4f |ent. 6,|ALTER RO|
|000054e0| 4c 4c 42 41 43 4b 20 53 | 45 47 4d 45 4e 54 2c 0a |LLBACK S|EGMENT,.|
|000054f0| 20 20 20 53 54 4f 52 41 | 47 45 20 63 6c 61 75 73 | STORA|GE claus|
|00005500| 65 0a 20 20 37 2c 41 4c | 54 45 52 20 52 4f 4c 4c |e. 7,AL|TER ROLL|
|00005510| 42 41 43 4b 20 53 45 47 | 4d 45 4e 54 2c 0a 0a 20 |BACK SEG|MENT,.. |
|00005520| 20 38 2c 41 4c 54 45 52 | 20 52 4f 4c 4c 42 41 43 | 8,ALTER| ROLLBAC|
|00005530| 4b 20 53 45 47 4d 45 4e | 54 2c 0a 0a 20 20 39 2c |K SEGMEN|T,.. 9,|
|00005540| 41 4c 54 45 52 20 52 4f | 4c 4c 42 41 43 4b 20 53 |ALTER RO|LLBACK S|
|00005550| 45 47 4d 45 4e 54 2c 0a | 20 55 73 65 20 41 4c 54 |EGMENT,.| Use ALT|
|00005560| 45 52 20 52 4f 4c 4c 42 | 41 43 4b 20 53 45 47 4d |ER ROLLB|ACK SEGM|
|00005570| 45 4e 54 20 74 6f 20 6d | 61 6b 65 20 61 20 72 6f |ENT to m|ake a ro|
|00005580| 6c 6c 62 61 63 6b 20 73 | 65 67 6d 65 6e 74 20 70 |llback s|egment p|
|00005590| 75 62 6c 69 63 20 6f 72 | 20 61 6c 74 65 72 20 69 |ublic or| alter i|
|000055a0| 74 73 0a 20 31 30 2c 41 | 4c 54 45 52 20 52 4f 4c |ts. 10,A|LTER ROL|
|000055b0| 4c 42 41 43 4b 20 53 45 | 47 4d 45 4e 54 2c 0a 20 |LBACK SE|GMENT,. |
|000055c0| 73 74 6f 72 61 67 65 20 | 70 61 72 61 6d 65 74 65 |storage |paramete|
|000055d0| 72 73 2e 20 20 55 73 65 | 20 50 55 42 4c 49 43 20 |rs. Use| PUBLIC |
|000055e0| 74 6f 20 6d 61 6b 65 20 | 61 20 72 6f 6c 6c 62 61 |to make |a rollba|
|000055f0| 63 6b 20 73 65 67 6d 65 | 6e 74 20 61 76 61 69 6c |ck segme|nt avail|
|00005600| 61 62 6c 65 20 66 6f 72 | 0a 20 31 31 2c 41 4c 54 |able for|. 11,ALT|
|00005610| 45 52 20 52 4f 4c 4c 42 | 41 43 4b 20 53 45 47 4d |ER ROLLB|ACK SEGM|
|00005620| 45 4e 54 2c 0a 20 75 73 | 65 20 69 6e 20 61 6e 79 |ENT,. us|e in any|
|00005630| 20 69 6e 73 74 61 6e 63 | 65 2e 20 20 54 6f 20 6d | instanc|e. To m|
|00005640| 61 6b 65 20 61 20 70 75 | 62 6c 69 63 20 72 6f 6c |ake a pu|blic rol|
|00005650| 6c 62 61 63 6b 20 73 65 | 67 6d 65 6e 74 20 70 72 |lback se|gment pr|
|00005660| 69 76 61 74 65 2c 20 79 | 6f 75 20 6d 75 73 74 0a |ivate, y|ou must.|
|00005670| 20 31 32 2c 41 4c 54 45 | 52 20 52 4f 4c 4c 42 41 | 12,ALTE|R ROLLBA|
|00005680| 43 4b 20 53 45 47 4d 45 | 4e 54 2c 0a 20 44 52 4f |CK SEGME|NT,. DRO|
|00005690| 50 20 69 74 2c 20 74 68 | 65 6e 20 43 52 45 41 54 |P it, th|en CREAT|
|000056a0| 45 20 69 74 20 61 67 61 | 69 6e 2e 0a 20 31 33 2c |E it aga|in.. 13,|
|000056b0| 41 4c 54 45 52 20 52 4f | 4c 4c 42 41 43 4b 20 53 |ALTER RO|LLBACK S|
|000056c0| 45 47 4d 45 4e 54 2c 0a | 0a 20 31 34 2c 41 4c 54 |EGMENT,.|. 14,ALT|
|000056d0| 45 52 20 52 4f 4c 4c 42 | 41 43 4b 20 53 45 47 4d |ER ROLLB|ACK SEGM|
|000056e0| 45 4e 54 2c 0a 20 54 68 | 65 20 53 54 4f 52 41 47 |ENT,. Th|e STORAG|
|000056f0| 45 20 63 6c 61 75 73 65 | 20 61 66 66 65 63 74 73 |E clause| affects|
|00005700| 20 66 75 74 75 72 65 20 | 73 70 61 63 65 20 61 6c | future |space al|
|00005710| 6c 6f 63 61 74 69 6f 6e | 20 69 6e 20 61 20 72 6f |location| in a ro|
|00005720| 6c 6c 62 61 63 6b 20 73 | 65 67 6d 65 6e 74 2e 0a |llback s|egment..|
|00005730| 20 31 35 2c 41 4c 54 45 | 52 20 52 4f 4c 4c 42 41 | 15,ALTE|R ROLLBA|
|00005740| 43 4b 20 53 45 47 4d 45 | 4e 54 2c 0a 20 59 6f 75 |CK SEGME|NT,. You|
|00005750| 20 63 61 6e 27 74 20 75 | 73 65 20 49 4e 49 54 49 | can't u|se INITI|
|00005760| 41 4c 20 6f 72 20 4d 49 | 4e 45 58 54 45 4e 54 53 |AL or MI|NEXTENTS|
|00005770| 20 74 6f 20 61 6c 74 65 | 72 20 61 6e 20 65 78 69 | to alte|r an exi|
|00005780| 73 74 69 6e 67 20 72 6f | 6c 6c 62 61 63 6b 20 73 |sting ro|llback s|
|00005790| 65 67 6d 65 6e 74 2e 0a | 20 31 36 2c 41 4c 54 45 |egment..| 16,ALTE|
|000057a0| 52 20 52 4f 4c 4c 42 41 | 43 4b 20 53 45 47 4d 45 |R ROLLBA|CK SEGME|
|000057b0| 4e 54 2c 0a 0a 20 31 37 | 2c 41 4c 54 45 52 20 52 |NT,.. 17|,ALTER R|
|000057c0| 4f 4c 4c 42 41 43 4b 20 | 53 45 47 4d 45 4e 54 2c |OLLBACK |SEGMENT,|
|000057d0| 0a 0a 20 31 38 2c 41 4c | 54 45 52 20 52 4f 4c 4c |.. 18,AL|TER ROLL|
|000057e0| 42 41 43 4b 20 53 45 47 | 4d 45 4e 54 2c 0a 20 53 |BACK SEG|MENT,. S|
|000057f0| 65 65 20 61 6c 73 6f 3a | 20 63 72 65 61 74 65 20 |ee also:| create |
|00005800| 64 61 74 61 62 61 73 65 | 2c 20 63 72 65 61 74 65 |database|, create|
|00005810| 20 72 6f 6c 6c 62 61 63 | 6b 2c 20 63 72 65 61 74 | rollbac|k, creat|
|00005820| 65 20 74 61 62 6c 65 73 | 70 61 63 65 2c 20 72 6f |e tables|pace, ro|
|00005830| 6c 6c 62 61 63 6b 2c 0a | 20 31 39 2c 41 4c 54 45 |llback,.| 19,ALTE|
|00005840| 52 20 52 4f 4c 4c 42 41 | 43 4b 20 53 45 47 4d 45 |R ROLLBA|CK SEGME|
|00005850| 4e 54 2c 0a 20 20 20 20 | 20 20 20 20 20 20 20 63 |NT,. | c|
|00005860| 6f 6d 6d 61 6e 64 73 2c | 20 6d 65 6e 75 2e 0a 20 |ommands,| menu.. |
|00005870| 20 31 2c 41 4c 54 45 52 | 20 53 45 51 55 45 4e 43 | 1,ALTER| SEQUENC|
|00005880| 45 2c 0a 0a 20 20 32 2c | 41 4c 54 45 52 20 53 45 |E,.. 2,|ALTER SE|
|00005890| 51 55 45 4e 43 45 2c 0a | 0a 20 20 33 2c 41 4c 54 |QUENCE,.|. 3,ALT|
|000058a0| 45 52 20 53 45 51 55 45 | 4e 43 45 2c 0a 20 20 20 |ER SEQUE|NCE,. |
|000058b0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|000058c0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|000058d0| 41 4c 54 45 52 20 53 45 | 51 55 45 4e 43 45 0a 20 |ALTER SE|QUENCE. |
|000058e0| 20 34 2c 41 4c 54 45 52 | 20 53 45 51 55 45 4e 43 | 4,ALTER| SEQUENC|
|000058f0| 45 2c 0a 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |E,. | |
|00005900| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00005910| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00005920| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00005930| 53 51 4c 20 73 74 61 74 | 65 6d 65 6e 74 0a 20 20 |SQL stat|ement. |
|00005940| 35 2c 41 4c 54 45 52 20 | 53 45 51 55 45 4e 43 45 |5,ALTER |SEQUENCE|
|00005950| 2c 0a 20 41 4c 54 45 52 | 20 53 45 51 55 45 4e 43 |,. ALTER| SEQUENC|
|00005960| 45 20 75 73 65 72 2e 73 | 65 71 75 65 6e 63 65 0a |E user.s|equence.|
|00005970| 20 20 36 2c 41 4c 54 45 | 52 20 53 45 51 55 45 4e | 6,ALTE|R SEQUEN|
|00005980| 43 45 2c 0a 20 20 20 20 | 20 20 20 49 4e 43 52 45 |CE,. | INCRE|
|00005990| 4d 45 4e 54 20 42 59 20 | 69 6e 74 65 67 65 72 0a |MENT BY |integer.|
|000059a0| 20 20 37 2c 41 4c 54 45 | 52 20 53 45 51 55 45 4e | 7,ALTE|R SEQUEN|
|000059b0| 43 45 2c 0a 20 20 20 20 | 20 20 20 4d 41 58 56 41 |CE,. | MAXVA|
|000059c0| 4c 55 45 20 69 6e 74 65 | 67 65 72 20 7c 20 4e 4f |LUE inte|ger | NO|
|000059d0| 4d 41 58 56 41 4c 55 45 | 0a 20 20 38 2c 41 4c 54 |MAXVALUE|. 8,ALT|
|000059e0| 45 52 20 53 45 51 55 45 | 4e 43 45 2c 0a 20 20 20 |ER SEQUE|NCE,. |
|000059f0| 20 20 20 20 4d 49 4e 56 | 41 4c 55 45 20 69 6e 74 | MINV|ALUE int|
|00005a00| 65 67 65 72 20 7c 20 4e | 4f 4d 49 4e 56 41 4c 55 |eger | N|OMINVALU|
|00005a10| 45 0a 20 20 39 2c 41 4c | 54 45 52 20 53 45 51 55 |E. 9,AL|TER SEQU|
|00005a20| 45 4e 43 45 2c 0a 20 20 | 20 20 20 20 20 43 59 43 |ENCE,. | CYC|
|00005a30| 4c 45 20 7c 20 4e 4f 43 | 59 43 4c 45 0a 20 31 30 |LE | NOC|YCLE. 10|
|00005a40| 2c 41 4c 54 45 52 20 53 | 45 51 55 45 4e 43 45 2c |,ALTER S|EQUENCE,|
|00005a50| 0a 20 20 20 20 20 20 20 | 43 41 43 48 45 20 69 6e |. |CACHE in|
|00005a60| 74 65 67 65 72 20 7c 20 | 4e 4f 43 41 43 48 45 0a |teger | |NOCACHE.|
|00005a70| 20 31 31 2c 41 4c 54 45 | 52 20 53 45 51 55 45 4e | 11,ALTE|R SEQUEN|
|00005a80| 43 45 2c 0a 20 20 20 20 | 20 20 20 4f 52 44 45 52 |CE,. | ORDER|
|00005a90| 20 7c 20 4e 4f 4f 52 44 | 45 52 0a 20 31 32 2c 41 | | NOORD|ER. 12,A|
|00005aa0| 4c 54 45 52 20 53 45 51 | 55 45 4e 43 45 2c 0a 0a |LTER SEQ|UENCE,..|
|00005ab0| 20 31 33 2c 41 4c 54 45 | 52 20 53 45 51 55 45 4e | 13,ALTE|R SEQUEN|
|00005ac0| 43 45 2c 0a 20 55 73 65 | 20 41 4c 54 45 52 20 53 |CE,. Use| ALTER S|
|00005ad0| 45 51 55 45 4e 43 45 20 | 74 6f 20 63 68 61 6e 67 |EQUENCE |to chang|
|00005ae0| 65 20 74 68 65 20 66 75 | 74 75 72 65 20 69 6e 63 |e the fu|ture inc|
|00005af0| 72 65 6d 65 6e 74 20 6f | 66 20 73 65 71 75 65 6e |rement o|f sequen|
|00005b00| 63 65 20 6e 75 6d 62 65 | 72 73 2c 0a 20 31 34 2c |ce numbe|rs,. 14,|
|00005b10| 41 4c 54 45 52 20 53 45 | 51 55 45 4e 43 45 2c 0a |ALTER SE|QUENCE,.|
|00005b20| 20 74 6f 20 72 65 73 65 | 74 20 6f 72 20 72 65 6d | to rese|t or rem|
|00005b30| 6f 76 65 20 69 74 73 20 | 4d 49 4e 56 41 4c 55 45 |ove its |MINVALUE|
|00005b40| 20 6f 72 20 4d 41 58 56 | 41 4c 55 45 2c 20 6f 72 | or MAXV|ALUE, or|
|00005b50| 20 74 6f 20 74 75 72 6e | 20 43 41 43 48 45 20 61 | to turn| CACHE a|
|00005b60| 6e 64 20 4f 52 44 45 52 | 0a 20 31 35 2c 41 4c 54 |nd ORDER|. 15,ALT|
|00005b70| 45 52 20 53 45 51 55 45 | 4e 43 45 2c 0a 20 6f 6e |ER SEQUE|NCE,. on|
|00005b80| 20 6f 72 20 6f 66 66 2e | 20 54 68 65 20 43 41 43 | or off.| The CAC|
|00005b90| 48 45 20 69 6e 74 65 67 | 65 72 20 6d 75 73 74 20 |HE integ|er must |
|00005ba0| 62 65 20 73 6d 61 6c 6c | 65 72 20 74 68 61 6e 20 |be small|er than |
|00005bb0| 74 68 65 20 64 69 66 66 | 65 72 65 6e 63 65 20 62 |the diff|erence b|
|00005bc0| 65 74 77 65 65 6e 0a 20 | 31 36 2c 41 4c 54 45 52 |etween. |16,ALTER|
|00005bd0| 20 53 45 51 55 45 4e 43 | 45 2c 0a 20 4d 41 58 56 | SEQUENC|E,. MAXV|
|00005be0| 41 4c 55 45 20 61 6e 64 | 20 4d 49 4e 56 41 4c 55 |ALUE and| MINVALU|
|00005bf0| 45 2e 20 49 66 20 79 6f | 75 20 75 73 65 20 43 59 |E. If yo|u use CY|
|00005c00| 43 4c 45 2c 20 61 6e 20 | 61 73 63 65 6e 64 69 6e |CLE, an |ascendin|
|00005c10| 67 20 73 65 71 75 65 6e | 63 65 20 67 69 76 65 73 |g sequen|ce gives|
|00005c20| 20 69 74 73 0a 20 31 37 | 2c 41 4c 54 45 52 20 53 | its. 17|,ALTER S|
|00005c30| 45 51 55 45 4e 43 45 2c | 0a 20 4d 49 4e 56 41 4c |EQUENCE,|. MINVAL|
|00005c40| 55 45 20 61 66 74 65 72 | 20 72 65 61 63 68 69 6e |UE after| reachin|
|00005c50| 67 20 4d 41 58 56 41 4c | 55 45 2c 20 61 6e 64 20 |g MAXVAL|UE, and |
|00005c60| 61 20 64 65 73 63 65 6e | 64 69 6e 67 20 73 65 71 |a descen|ding seq|
|00005c70| 75 65 6e 63 65 20 67 69 | 76 65 73 20 69 74 73 0a |uence gi|ves its.|
|00005c80| 20 31 38 2c 41 4c 54 45 | 52 20 53 45 51 55 45 4e | 18,ALTE|R SEQUEN|
|00005c90| 43 45 2c 0a 20 4d 41 58 | 56 41 4c 55 45 20 61 66 |CE,. MAX|VALUE af|
|00005ca0| 74 65 72 20 72 65 61 63 | 68 69 6e 67 20 4d 49 4e |ter reac|hing MIN|
|00005cb0| 56 41 4c 55 45 2e 0a 20 | 31 39 2c 41 4c 54 45 52 |VALUE.. |19,ALTER|
|00005cc0| 20 53 45 51 55 45 4e 43 | 45 2c 0a 0a 20 32 30 2c | SEQUENC|E,.. 20,|
|00005cd0| 41 4c 54 45 52 20 53 45 | 51 55 45 4e 43 45 2c 0a |ALTER SE|QUENCE,.|
|00005ce0| 20 54 6f 20 72 65 73 74 | 61 72 74 20 61 20 73 65 | To rest|art a se|
|00005cf0| 71 75 65 6e 63 65 20 61 | 74 20 61 20 6e 65 77 20 |quence a|t a new |
|00005d00| 6e 75 6d 62 65 72 2c 20 | 44 52 4f 50 20 61 6e 64 |number, |DROP and|
|00005d10| 20 43 52 45 41 54 45 20 | 69 74 20 61 67 61 69 6e | CREATE |it again|
|00005d20| 2e 0a 20 32 31 2c 41 4c | 54 45 52 20 53 45 51 55 |.. 21,AL|TER SEQU|
|00005d30| 45 4e 43 45 2c 0a 0a 20 | 32 32 2c 41 4c 54 45 52 |ENCE,.. |22,ALTER|
|00005d40| 20 53 45 51 55 45 4e 43 | 45 2c 0a 0a 20 32 33 2c | SEQUENC|E,.. 23,|
|00005d50| 41 4c 54 45 52 20 53 45 | 51 55 45 4e 43 45 2c 0a |ALTER SE|QUENCE,.|
|00005d60| 20 53 65 65 20 61 6c 73 | 6f 3a 20 73 65 71 75 65 | See als|o: seque|
|00005d70| 6e 63 65 73 2c 20 63 72 | 65 61 74 65 20 73 65 71 |nces, cr|eate seq|
|00005d80| 75 65 6e 63 65 2c 20 64 | 72 6f 70 20 73 65 71 75 |uence, d|rop sequ|
|00005d90| 65 6e 63 65 2c 20 63 6f | 6d 6d 61 6e 64 73 2c 20 |ence, co|mmands, |
|00005da0| 6d 65 6e 75 2e 0a 20 20 | 31 2c 41 4c 54 45 52 20 |menu.. |1,ALTER |
|00005db0| 54 41 42 4c 45 2c 0a 0a | 20 20 32 2c 41 4c 54 45 |TABLE,..| 2,ALTE|
|00005dc0| 52 20 54 41 42 4c 45 2c | 0a 0a 20 20 33 2c 41 4c |R TABLE,|.. 3,AL|
|00005dd0| 54 45 52 20 54 41 42 4c | 45 2c 0a 20 20 20 20 20 |TER TABL|E,. |
|00005de0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00005df0| 20 20 20 20 20 20 20 20 | 20 20 20 20 41 4c 54 45 | | ALTE|
|00005e00| 52 20 54 41 42 4c 45 0a | 20 20 34 2c 41 4c 54 45 |R TABLE.| 4,ALTE|
|00005e10| 52 20 54 41 42 4c 45 2c | 0a 20 20 20 20 20 20 20 |R TABLE,|. |
|00005e20| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00005e30| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00005e40| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00005e50| 20 20 20 20 53 51 4c 20 | 73 74 61 74 65 6d 65 6e | SQL |statemen|
|00005e60| 74 0a 20 20 35 2c 41 4c | 54 45 52 20 54 41 42 4c |t. 5,AL|TER TABL|
|00005e70| 45 2c 0a 20 41 4c 54 45 | 52 20 54 41 42 4c 45 20 |E,. ALTE|R TABLE |
|00005e80| 75 73 65 72 2e 74 61 62 | 6c 65 0a 20 20 36 2c 41 |user.tab|le. 6,A|
|00005e90| 4c 54 45 52 20 54 41 42 | 4c 45 2c 0a 20 20 20 20 |LTER TAB|LE,. |
|00005ea0| 41 44 44 20 63 6f 6c 75 | 6d 6e 5f 65 6c 65 6d 65 |ADD colu|mn_eleme|
|00005eb0| 6e 74 20 7c 20 74 61 62 | 6c 65 5f 63 6f 6e 73 74 |nt | tab|le_const|
|00005ec0| 72 61 69 6e 74 2c 0a 20 | 20 37 2c 41 4c 54 45 52 |raint,. | 7,ALTER|
|00005ed0| 20 54 41 42 4c 45 2c 0a | 20 20 20 20 20 20 20 20 | TABLE,.| |
|00005ee0| 63 6f 6c 75 6d 6e 5f 65 | 6c 65 6d 65 6e 74 20 7c |column_e|lement ||
|00005ef0| 20 74 61 62 6c 65 5f 63 | 6f 6e 73 74 72 61 69 6e | table_c|onstrain|
|00005f00| 74 2c 2e 2e 2e 0a 20 20 | 38 2c 41 4c 54 45 52 20 |t,.... |8,ALTER |
|00005f10| 54 41 42 4c 45 2c 0a 20 | 20 20 20 4d 4f 44 49 46 |TABLE,. | MODIF|
|00005f20| 59 20 63 6f 6c 75 6d 6e | 5f 65 6c 65 6d 65 6e 74 |Y column|_element|
|00005f30| 2c 20 63 6f 6c 75 6d 6e | 5f 65 6c 65 6d 65 6e 74 |, column|_element|
|00005f40| 2c 2e 2e 2e 0a 20 20 39 | 2c 41 4c 54 45 52 20 54 |,.... 9|,ALTER T|
|00005f50| 41 42 4c 45 2c 0a 20 20 | 20 20 44 52 4f 50 20 43 |ABLE,. | DROP C|
|00005f60| 4f 4e 53 54 52 41 49 4e | 54 20 63 6f 6e 73 74 72 |ONSTRAIN|T constr|
|00005f70| 61 69 6e 74 2c 20 63 6f | 6e 73 74 72 61 69 6e 74 |aint, co|nstraint|
|00005f80| 2c 2e 2e 2e 0a 20 31 30 | 2c 41 4c 54 45 52 20 54 |,.... 10|,ALTER T|
|00005f90| 41 42 4c 45 2c 0a 20 20 | 20 20 50 43 54 46 52 45 |ABLE,. | PCTFRE|
|00005fa0| 45 20 69 6e 74 65 67 65 | 72 20 20 20 50 43 54 55 |E intege|r PCTU|
|00005fb0| 53 45 44 20 69 6e 74 65 | 67 65 72 0a 20 31 31 2c |SED inte|ger. 11,|
|00005fc0| 41 4c 54 45 52 20 54 41 | 42 4c 45 2c 0a 20 20 20 |ALTER TA|BLE,. |
|00005fd0| 20 49 4e 49 54 52 41 4e | 53 20 69 6e 74 65 67 65 | INITRAN|S intege|
|00005fe0| 72 20 20 4d 41 58 54 52 | 41 4e 53 20 69 6e 74 65 |r MAXTR|ANS inte|
|00005ff0| 67 65 72 0a 20 31 32 2c | 41 4c 54 45 52 20 54 41 |ger. 12,|ALTER TA|
|00006000| 42 4c 45 2c 0a 20 20 20 | 20 53 54 4f 52 41 47 45 |BLE,. | STORAGE|
|00006010| 20 63 6c 61 75 73 65 0a | 20 31 33 2c 41 4c 54 45 | clause.| 13,ALTE|
|00006020| 52 20 54 41 42 4c 45 2c | 0a 20 20 20 20 42 41 43 |R TABLE,|. BAC|
|00006030| 4b 55 50 0a 20 31 34 2c | 41 4c 54 45 52 20 54 41 |KUP. 14,|ALTER TA|
|00006040| 42 4c 45 2c 0a 0a 20 31 | 35 2c 41 4c 54 45 52 20 |BLE,.. 1|5,ALTER |
|00006050| 54 41 42 4c 45 2c 0a 20 | 55 73 65 20 41 4c 54 45 |TABLE,. |Use ALTE|
|00006060| 52 20 54 41 42 4c 45 20 | 74 6f 20 61 64 64 20 63 |R TABLE |to add c|
|00006070| 6f 6c 75 6d 6e 73 20 6f | 72 20 63 6f 6e 73 74 72 |olumns o|r constr|
|00006080| 61 69 6e 74 73 20 74 6f | 20 61 20 74 61 62 6c 65 |aints to| a table|
|00006090| 2c 20 63 68 61 6e 67 65 | 20 63 6f 6c 75 6d 6e 0a |, change| column.|
|000060a0| 20 31 36 2c 41 4c 54 45 | 52 20 54 41 42 4c 45 2c | 16,ALTE|R TABLE,|
|000060b0| 0a 20 64 61 74 61 74 79 | 70 65 73 2c 20 73 69 7a |. dataty|pes, siz|
|000060c0| 65 73 2c 20 61 6e 64 20 | 4e 4f 54 20 4e 55 4c 4c |es, and |NOT NULL|
|000060d0| 20 73 65 74 74 69 6e 67 | 73 2c 20 64 72 6f 70 20 | setting|s, drop |
|000060e0| 63 6f 6e 73 74 72 61 69 | 6e 74 73 2c 20 63 68 61 |constrai|nts, cha|
|000060f0| 6e 67 65 20 66 75 74 75 | 72 65 0a 20 31 37 2c 41 |nge futu|re. 17,A|
|00006100| 4c 54 45 52 20 54 41 42 | 4c 45 2c 0a 20 73 74 6f |LTER TAB|LE,. sto|
|00006110| 72 61 67 65 20 61 6c 6c | 6f 63 61 74 69 6f 6e 73 |rage all|ocations|
|00006120| 2c 20 61 6e 64 20 75 70 | 64 61 74 65 20 74 68 65 |, and up|date the|
|00006130| 20 64 61 74 61 20 64 69 | 63 74 69 6f 6e 61 72 79 | data di|ctionary|
|00006140| 20 74 6f 20 73 68 6f 77 | 20 74 68 61 74 20 61 20 | to show| that a |
|00006150| 42 41 43 4b 55 50 0a 20 | 31 38 2c 41 4c 54 45 52 |BACKUP. |18,ALTER|
|00006160| 20 54 41 42 4c 45 2c 0a | 20 6f 66 20 74 68 65 20 | TABLE,.| of the |
|00006170| 74 61 62 6c 65 20 6f 63 | 63 75 72 72 65 64 20 77 |table oc|curred w|
|00006180| 68 65 6e 20 74 68 65 20 | 73 74 61 74 65 6d 65 6e |hen the |statemen|
|00006190| 74 20 77 61 73 20 65 78 | 65 63 75 74 65 64 2e 0a |t was ex|ecuted..|
|000061a0| 20 31 39 2c 41 4c 54 45 | 52 20 54 41 42 4c 45 2c | 19,ALTE|R TABLE,|
|000061b0| 0a 0a 20 32 30 2c 41 4c | 54 45 52 20 54 41 42 4c |.. 20,AL|TER TABL|
|000061c0| 45 2c 0a 0a 20 32 31 2c | 41 4c 54 45 52 20 54 41 |E,.. 21,|ALTER TA|
|000061d0| 42 4c 45 2c 0a 20 53 65 | 65 20 61 6c 73 6f 3a 20 |BLE,. Se|e also: |
|000061e0| 74 61 62 6c 65 73 2c 20 | 63 72 65 61 74 65 20 74 |tables, |create t|
|000061f0| 61 62 6c 65 2c 20 63 6f | 6e 73 74 72 61 69 6e 74 |able, co|nstraint|
|00006200| 2c 20 63 6f 6d 6d 61 6e | 64 73 2c 20 6d 65 6e 75 |, comman|ds, menu|
|00006210| 2e 0a 20 20 31 2c 41 4c | 54 45 52 20 54 41 42 4c |.. 1,AL|TER TABL|
|00006220| 45 53 50 41 43 45 2c 0a | 0a 20 20 32 2c 41 4c 54 |ESPACE,.|. 2,ALT|
|00006230| 45 52 20 54 41 42 4c 45 | 53 50 41 43 45 2c 0a 0a |ER TABLE|SPACE,..|
|00006240| 20 20 33 2c 41 4c 54 45 | 52 20 54 41 42 4c 45 53 | 3,ALTE|R TABLES|
|00006250| 50 41 43 45 2c 0a 20 20 | 20 20 20 20 20 20 20 20 |PACE,. | |
|00006260| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00006270| 20 20 20 20 41 4c 54 45 | 52 20 54 41 42 4c 45 53 | ALTE|R TABLES|
|00006280| 50 41 43 45 0a 20 20 34 | 2c 41 4c 54 45 52 20 54 |PACE. 4|,ALTER T|
|00006290| 41 42 4c 45 53 50 41 43 | 45 2c 0a 20 20 20 20 20 |ABLESPAC|E,. |
|000062a0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|000062b0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|000062c0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|000062d0| 20 20 20 20 53 51 4c 20 | 73 74 61 74 65 6d 65 6e | SQL |statemen|
|000062e0| 74 0a 20 20 35 2c 41 4c | 54 45 52 20 54 41 42 4c |t. 5,AL|TER TABL|
|000062f0| 45 53 50 41 43 45 2c 0a | 20 41 4c 54 45 52 20 54 |ESPACE,.| ALTER T|
|00006300| 41 42 4c 45 53 50 41 43 | 45 20 74 61 62 6c 65 73 |ABLESPAC|E tables|
|00006310| 70 61 63 65 0a 20 20 36 | 2c 41 4c 54 45 52 20 54 |pace. 6|,ALTER T|
|00006320| 41 42 4c 45 53 50 41 43 | 45 2c 0a 20 41 44 44 20 |ABLESPAC|E,. ADD |
|00006330| 44 41 54 41 46 49 4c 45 | 20 27 66 69 6c 65 6e 61 |DATAFILE| 'filena|
|00006340| 6d 65 27 20 53 49 5a 45 | 20 69 6e 74 65 67 65 72 |me' SIZE| integer|
|00006350| 20 4b 20 7c 20 4d 20 52 | 45 55 53 45 2c 2e 2e 2e | K | M R|EUSE,...|
|00006360| 0a 20 20 37 2c 41 4c 54 | 45 52 20 54 41 42 4c 45 |. 7,ALT|ER TABLE|
|00006370| 53 50 41 43 45 2c 0a 20 | 52 45 4e 41 4d 45 20 44 |SPACE,. |RENAME D|
|00006380| 41 54 41 46 49 4c 45 20 | 27 66 69 6c 65 6e 61 6d |ATAFILE |'filenam|
|00006390| 65 27 2c 20 27 66 69 6c | 65 6e 61 6d 65 27 2c 2e |e', 'fil|ename',.|
|000063a0| 2e 2e 0a 20 20 38 2c 41 | 4c 54 45 52 20 54 41 42 |... 8,A|LTER TAB|
|000063b0| 4c 45 53 50 41 43 45 2c | 0a 20 20 20 20 20 20 20 |LESPACE,|. |
|000063c0| 20 20 20 20 20 20 20 20 | 20 54 4f 20 27 66 69 6c | | TO 'fil|
|000063d0| 65 6e 61 6d 65 27 2c 20 | 27 66 69 6c 65 6e 61 6d |ename', |'filenam|
|000063e0| 65 27 2c 2e 2e 2e 0a 20 | 20 39 2c 41 4c 54 45 52 |e',.... | 9,ALTER|
|000063f0| 20 54 41 42 4c 45 53 50 | 41 43 45 2c 0a 20 44 45 | TABLESP|ACE,. DE|
+--------+-------------------------+-------------------------+--------+--------+
Only 25.0 KB of data is shown above.
