home *** CD-ROM | disk | FTP | other *** search
| Unknown | 1990-04-03 | 407.5 KB |
open in: 
MacOS 8.1
|
Win98
|
DOS
view JSON data
|
view as text
This file was not able to be converted.
This format is not currently supported by dexvert.
| Confidence | Program | Detection | Match Type | Support
|
|---|
| 66%
| dexvert
| X Window Dump (image/xwd)
| ext
| Supported |
| 1%
| dexvert
| TCPDUMP Style Capture (other/tcpdumpCapture)
| ext
| Unsupported |
| 100%
| file
| data
| default
|
|
hex view+--------+-------------------------+-------------------------+--------+--------+
|00000000| 01 45 58 50 4f 52 54 3a | 56 30 36 2e 30 30 2e 32 |.EXPORT:|V06.00.2|
|00000010| 37 0a 44 53 59 53 54 45 | 4d 0a 52 54 41 42 4c 45 |7.DSYSTE|M.RTABLE|
|00000020| 53 0a 35 31 32 0a 00 20 | 20 20 20 20 20 20 20 20 |S.512.. | |
|00000030| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00000040| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00000050| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00000060| 20 20 20 20 20 20 20 20 | 54 75 65 20 41 70 72 20 | |Tue Apr |
|00000070| 30 33 20 31 31 3a 32 32 | 3a 31 34 20 31 39 39 30 |03 11:22|:14 1990|
|00000080| 0a 43 4f 4e 4e 45 43 54 | 20 53 59 53 54 45 4d 0a |.CONNECT| SYSTEM.|
|00000090| 54 41 42 4c 45 20 22 48 | 45 4c 50 22 0a 43 52 45 |TABLE "H|ELP".CRE|
|000000a0| 41 54 45 20 54 41 42 4c | 45 20 22 48 45 4c 50 22 |ATE TABL|E "HELP"|
|000000b0| 20 28 22 54 4f 50 49 43 | 22 20 43 48 41 52 28 33 | ("TOPIC|" CHAR(3|
|000000c0| 30 29 20 4e 4f 54 20 4e | 55 4c 4c 2c 20 22 53 45 |0) NOT N|ULL, "SE|
|000000d0| 51 22 20 4e 55 4d 42 45 | 52 20 4e 4f 54 20 4e 55 |Q" NUMBE|R NOT NU|
|000000e0| 4c 4c 2c 20 22 49 4e 46 | 4f 22 20 43 48 41 52 28 |LL, "INF|O" CHAR(|
|000000f0| 38 30 29 29 20 20 50 43 | 54 46 52 45 45 20 31 30 |80)) PC|TFREE 10|
|00000100| 20 50 43 54 55 53 45 44 | 20 34 30 20 49 4e 49 54 | PCTUSED| 40 INIT|
|00000110| 52 41 4e 53 20 31 20 4d | 41 58 54 52 41 4e 53 20 |RANS 1 M|AXTRANS |
|00000120| 32 35 35 20 53 54 4f 52 | 41 47 45 28 49 4e 49 54 |255 STOR|AGE(INIT|
|00000130| 49 41 4c 20 35 35 35 30 | 30 38 20 4e 45 58 54 20 |IAL 5550|08 NEXT |
|00000140| 31 30 32 34 30 20 4d 49 | 4e 45 58 54 45 4e 54 53 |10240 MI|NEXTENTS|
|00000150| 20 31 20 4d 41 58 45 58 | 54 45 4e 54 53 20 39 39 | 1 MAXEX|TENTS 99|
|00000160| 20 50 43 54 49 4e 43 52 | 45 41 53 45 20 35 30 29 | PCTINCR|EASE 50)|
|00000170| 20 54 41 42 4c 45 53 50 | 41 43 45 20 22 53 59 53 | TABLESP|ACE "SYS|
|00000180| 54 45 4d 22 0a 49 4e 53 | 45 52 54 20 49 4e 54 4f |TEM".INS|ERT INTO|
|00000190| 20 22 48 45 4c 50 22 20 | 28 22 54 4f 50 49 43 22 | "HELP" |("TOPIC"|
|000001a0| 2c 20 22 53 45 51 22 2c | 20 22 49 4e 46 4f 22 29 |, "SEQ",| "INFO")|
|000001b0| 20 56 41 4c 55 45 53 20 | 28 3a 31 2c 20 3a 32 2c | VALUES |(:1, :2,|
|000001c0| 20 3a 33 29 0a 03 00 01 | 00 1e 00 02 00 16 00 01 | :3)....|........|
|000001d0| 00 50 00 01 00 2f 02 00 | c1 02 fe ff 01 00 2f 02 |.P.../..|....../.|
|000001e0| 00 c1 03 fe ff 01 00 2f | 02 00 c1 04 29 00 20 20 |......./|....). |
|000001f0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00000200| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 2f 20 | | / |
|00000210| 28 73 6c 61 73 68 29 01 | 00 2f 02 00 c1 05 fe ff |(slash).|./......|
|00000220| 01 00 2f 02 00 c1 06 02 | 00 20 2f 01 00 2f 02 00 |../.....|. /../..|
|00000230| c1 07 fe ff 01 00 2f 02 | 00 c1 08 46 00 20 45 6e |....../.|...F. En|
|00000240| 74 65 72 20 61 20 73 6c | 61 73 68 20 28 2f 29 20 |ter a sl|ash (/) |
|00000250| 61 74 20 74 68 65 20 63 | 6f 6d 6d 61 6e 64 20 70 |at the c|ommand p|
|00000260| 72 6f 6d 70 74 20 6f 72 | 20 61 74 20 61 20 6c 69 |rompt or| at a li|
|00000270| 6e 65 20 6e 75 6d 62 65 | 72 20 70 72 6f 6d 70 74 |ne numbe|r prompt|
|00000280| 20 74 6f 01 00 2f 02 00 | c1 09 44 00 20 65 78 65 | to../..|..D. exe|
|00000290| 63 75 74 65 20 61 20 53 | 51 4c 20 63 6f 6d 6d 61 |cute a S|QL comma|
|000002a0| 6e 64 20 6f 72 20 50 4c | 2f 53 51 4c 20 62 6c 6f |nd or PL|/SQL blo|
|000002b0| 63 6b 20 69 6e 20 74 68 | 65 20 53 51 4c 20 62 75 |ck in th|e SQL bu|
|000002c0| 66 66 65 72 2e 20 20 54 | 68 65 20 73 6c 61 73 68 |ffer. T|he slash|
|000002d0| 01 00 2f 02 00 c1 0a 45 | 00 20 63 6f 6d 6d 61 6e |../....E|. comman|
|000002e0| 64 20 77 6f 72 6b 73 20 | 6c 69 6b 65 20 52 55 4e |d works |like RUN|
|000002f0| 2c 20 62 75 74 20 64 6f | 65 73 20 6e 6f 74 20 6c |, but do|es not l|
|00000300| 69 73 74 20 74 68 65 20 | 63 6f 6d 6d 61 6e 64 20 |ist the |command |
|00000310| 6f 6e 20 79 6f 75 72 20 | 73 63 72 65 65 6e 01 00 |on your |screen..|
|00000320| 2f 02 00 c1 0b 08 00 20 | 62 75 66 66 65 72 2e 01 |/...... |buffer..|
|00000330| 00 2f 02 00 c1 0c fe ff | 01 00 2f 02 00 c1 0d 4b |./......|../....K|
|00000340| 00 20 45 78 65 63 75 74 | 69 6e 67 20 61 20 53 51 |. Execut|ing a SQ|
|00000350| 4c 20 63 6f 6d 6d 61 6e | 64 20 6f 72 20 50 4c 2f |L comman|d or PL/|
|00000360| 53 51 4c 20 62 6c 6f 63 | 6b 20 77 69 74 68 20 74 |SQL bloc|k with t|
|00000370| 68 65 20 73 6c 61 73 68 | 20 64 6f 65 73 20 6e 6f |he slash| does no|
|00000380| 74 20 63 68 61 6e 67 65 | 20 74 68 65 01 00 2f 02 |t change| the../.|
|00000390| 00 c1 0e 4b 00 20 63 75 | 72 72 65 6e 74 20 6c 69 |...K. cu|rrent li|
|000003a0| 6e 65 20 6e 75 6d 62 65 | 72 20 69 6e 20 74 68 65 |ne numbe|r in the|
|000003b0| 20 53 51 4c 20 62 75 66 | 66 65 72 20 75 6e 6c 65 | SQL buf|fer unle|
|000003c0| 73 73 20 74 68 65 20 63 | 6f 6d 6d 61 6e 64 20 69 |ss the c|ommand i|
|000003d0| 6e 20 74 68 65 20 62 75 | 66 66 65 72 20 68 61 73 |n the bu|ffer has|
|000003e0| 01 00 2f 02 00 c1 0f 4b | 00 20 61 6e 20 65 72 72 |../....K|. an err|
|000003f0| 6f 72 2e 20 20 49 66 20 | 73 6f 2c 20 53 51 4c 2a |or. If |so, SQL*|
|00000400| 50 6c 75 73 20 6d 61 6b | 65 73 20 74 68 65 20 6c |Plus mak|es the l|
|00000410| 69 6e 65 20 77 69 74 68 | 20 74 68 65 20 65 72 72 |ine with| the err|
|00000420| 6f 72 20 74 68 65 20 63 | 75 72 72 65 6e 74 20 6c |or the c|urrent l|
|00000430| 69 6e 65 2e 01 00 2f 02 | 00 c1 10 fe ff 01 00 2f |ine.../.|......./|
|00000440| 02 00 c1 11 37 00 20 45 | 78 61 6d 70 6c 65 73 3a |....7. E|xamples:|
|00000450| 20 54 79 70 65 20 4c 49 | 53 54 20 74 6f 20 73 65 | Type LI|ST to se|
|00000460| 65 20 74 68 65 20 63 6f | 6e 74 65 6e 74 73 20 6f |e the co|ntents o|
|00000470| 66 20 74 68 65 20 62 75 | 66 66 65 72 3a 01 00 2f |f the bu|ffer:../|
|00000480| 02 00 c1 12 fe ff 01 00 | 2f 02 00 c1 13 18 00 20 |........|/...... |
|00000490| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 53 51 | | SQ|
|000004a0| 4c 3e 20 4c 49 53 54 01 | 00 2f 02 00 c1 14 44 00 |L> LIST.|./....D.|
|000004b0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|000004c0| 20 31 2a 20 53 45 4c 45 | 43 54 20 45 4e 41 4d 45 | 1* SELE|CT ENAME|
|000004d0| 2c 20 4a 4f 42 20 46 52 | 4f 4d 20 45 4d 50 20 57 |, JOB FR|OM EMP W|
|000004e0| 48 45 52 45 20 45 4e 41 | 4d 45 20 3d 20 27 4a 41 |HERE ENA|ME = 'JA|
|000004f0| 4d 45 53 27 01 00 2f 02 | 00 c1 15 fe ff 01 00 2f |MES'../.|......./|
|00000500| 02 00 c1 16 40 00 20 20 | 20 20 20 20 20 20 20 20 |....@. | |
|00000510| 20 45 6e 74 65 72 20 2f | 20 28 73 6c 61 73 68 29 | Enter /| (slash)|
|00000520| 20 74 6f 20 65 78 65 63 | 75 74 65 20 74 68 65 20 | to exec|ute the |
|00000530| 63 6f 6d 6d 61 6e 64 20 | 69 6e 20 74 68 65 20 62 |command |in the b|
|00000540| 75 66 66 65 72 3a 01 00 | 2f 02 00 c1 17 fe ff 01 |uffer:..|/.......|
|00000550| 00 2f 02 00 c1 18 32 00 | 20 20 20 20 20 20 20 20 |./....2.| |
|00000560| 20 20 20 20 20 20 20 53 | 51 4c 3e 20 2f 20 20 20 | S|QL> / |
|00000570| 20 20 20 20 20 20 4f 75 | 74 70 75 74 3a 20 20 45 | Ou|tput: E|
|00000580| 4e 41 4d 45 20 20 20 4a | 4f 42 01 00 2f 02 00 c1 |NAME J|OB../...|
|00000590| 19 34 00 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |.4. | |
|000005a0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|000005b0| 20 20 20 20 20 20 20 20 | 20 20 2d 2d 2d 2d 2d 2d | | ------|
|000005c0| 20 20 2d 2d 2d 2d 2d 01 | 00 2f 02 00 c1 1a 34 00 | -----.|./....4.|
|000005d0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|000005e0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|000005f0| 20 20 20 20 20 20 20 4a | 41 4d 45 53 20 20 20 43 | J|AMES C|
|00000600| 4c 45 52 4b 01 00 2f 02 | 00 c1 1b fe ff 01 00 2f |LERK../.|......./|
|00000610| 02 00 c1 1c 47 00 20 53 | 65 65 20 61 6c 73 6f 3a |....G. S|ee also:|
|00000620| 20 40 2c 20 65 64 69 74 | 2c 20 67 65 74 2c 20 6c | @, edit|, get, l|
|00000630| 69 73 74 2c 20 72 75 6e | 2c 20 73 61 76 65 2c 20 |ist, run|, save, |
|00000640| 70 61 72 61 6d 65 74 65 | 72 73 2c 20 73 65 74 20 |paramete|rs, set |
|00000650| 28 53 51 4c 20 62 75 66 | 66 65 72 29 2c 01 00 2f |(SQL buf|fer),../|
|00000660| 02 00 c1 1d 28 00 20 20 | 20 20 20 20 20 20 20 20 |....(. | |
|00000670| 20 73 70 6f 6f 6c 2c 20 | 73 74 61 72 74 2c 20 63 | spool, |start, c|
|00000680| 6f 6d 6d 61 6e 64 73 2c | 20 6d 65 6e 75 2e 14 00 |ommands,| menu...|
|00000690| 31 20 52 6f 77 20 43 68 | 61 72 20 46 75 6e 63 74 |1 Row Ch|ar Funct|
|000006a0| 69 6f 6e 73 02 00 c1 02 | fe ff 14 00 31 20 52 6f |ions....|....1 Ro|
|000006b0| 77 20 43 68 61 72 20 46 | 75 6e 63 74 69 6f 6e 73 |w Char F|unctions|
|000006c0| 02 00 c1 03 fe ff 14 00 | 31 20 52 6f 77 20 43 68 |........|1 Row Ch|
|000006d0| 61 72 20 46 75 6e 63 74 | 69 6f 6e 73 02 00 c1 04 |ar Funct|ions....|
|000006e0| 2f 00 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |/. | |
|000006f0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 31 20 52 | | 1 R|
|00000700| 6f 77 20 43 68 61 72 20 | 46 75 6e 63 74 69 6f 6e |ow Char |Function|
|00000710| 73 14 00 31 20 52 6f 77 | 20 43 68 61 72 20 46 75 |s..1 Row| Char Fu|
|00000720| 6e 63 74 69 6f 6e 73 02 | 00 c1 05 fe ff 14 00 31 |nctions.|.......1|
|00000730| 20 52 6f 77 20 43 68 61 | 72 20 46 75 6e 63 74 69 | Row Cha|r Functi|
|00000740| 6f 6e 73 02 00 c1 06 4a | 00 20 41 53 43 49 49 28 |ons....J|. ASCII(|
|00000750| 73 74 72 69 6e 67 29 20 | 20 20 20 20 52 65 74 75 |string) | Retu|
|00000760| 72 6e 73 20 63 6f 6c 6c | 61 74 69 6e 67 20 73 65 |rns coll|ating se|
|00000770| 71 75 65 6e 63 65 20 76 | 61 6c 75 65 20 6f 66 20 |quence v|alue of |
|00000780| 31 73 74 20 63 68 61 72 | 20 6f 66 20 73 74 72 69 |1st char| of stri|
|00000790| 6e 67 2e 14 00 31 20 52 | 6f 77 20 43 68 61 72 20 |ng...1 R|ow Char |
|000007a0| 46 75 6e 63 74 69 6f 6e | 73 02 00 c1 07 47 00 20 |Function|s....G. |
|000007b0| 43 48 52 28 6e 29 20 20 | 20 20 20 20 20 20 20 20 |CHR(n) | |
|000007c0| 20 20 52 65 74 75 72 6e | 73 20 63 68 61 72 61 63 | Return|s charac|
|000007d0| 74 65 72 20 68 61 76 69 | 6e 67 20 41 53 43 49 49 |ter havi|ng ASCII|
|000007e0| 20 6f 72 20 45 42 43 44 | 49 43 20 76 61 6c 75 65 | or EBCD|IC value|
|000007f0| 20 6f 66 20 6e 2e 14 00 | 31 20 52 6f 77 20 43 68 | of n...|1 Row Ch|
|00000800| 61 72 20 46 75 6e 63 74 | 69 6f 6e 73 02 00 c1 08 |ar Funct|ions....|
|00000810| 4a 00 20 49 4e 49 54 43 | 41 50 28 63 68 61 72 29 |J. INITC|AP(char)|
|00000820| 20 20 20 20 20 43 61 70 | 69 74 61 6c 69 7a 65 73 | Cap|italizes|
|00000830| 20 65 61 63 68 20 77 6f | 72 64 27 73 20 66 69 72 | each wo|rd's fir|
|00000840| 73 74 20 6c 65 74 74 65 | 72 2c 20 6f 74 68 65 72 |st lette|r, other|
|00000850| 73 20 6c 6f 77 65 72 63 | 61 73 65 2e 14 00 31 20 |s lowerc|ase...1 |
|00000860| 52 6f 77 20 43 68 61 72 | 20 46 75 6e 63 74 69 6f |Row Char| Functio|
|00000870| 6e 73 02 00 c1 09 47 00 | 20 49 4e 53 54 52 28 63 |ns....G.| INSTR(c|
|00000880| 68 61 72 31 2c 20 20 20 | 20 20 20 42 65 67 69 6e |har1, | Begin|
|00000890| 6e 69 6e 67 20 61 74 20 | 70 6f 73 69 74 69 6f 6e |ning at |position|
|000008a0| 20 6d 2c 20 72 65 74 75 | 72 6e 73 20 74 68 65 20 | m, retu|rns the |
|000008b0| 70 6f 73 69 74 69 6f 6e | 20 6f 66 20 74 68 65 14 |position| of the.|
|000008c0| 00 31 20 52 6f 77 20 43 | 68 61 72 20 46 75 6e 63 |.1 Row C|har Func|
|000008d0| 74 69 6f 6e 73 02 00 c1 | 0a 4c 00 20 20 20 63 68 |tions...|.L. ch|
|000008e0| 61 72 32 2c 20 6d 2c 20 | 6e 29 20 20 20 20 20 20 |ar2, m, |n) |
|000008f0| 20 6e 74 68 20 6f 63 63 | 75 72 72 65 6e 63 65 20 | nth occ|urrence |
|00000900| 6f 66 20 63 68 61 72 32 | 20 69 6e 20 63 68 61 72 |of char2| in char|
|00000910| 31 3b 20 6d 20 26 20 6e | 20 3d 20 30 20 69 66 20 |1; m & n| = 0 if |
|00000920| 61 62 73 65 6e 74 2e 14 | 00 31 20 52 6f 77 20 43 |absent..|.1 Row C|
|00000930| 68 61 72 20 46 75 6e 63 | 74 69 6f 6e 73 02 00 c1 |har Func|tions...|
|00000940| 0b 2e 00 20 4c 45 4e 47 | 54 48 28 63 68 61 72 29 |... LENG|TH(char)|
|00000950| 20 20 20 20 20 20 52 65 | 74 75 72 6e 73 20 74 68 | Re|turns th|
|00000960| 65 20 6c 65 6e 67 74 68 | 20 6f 66 20 63 68 61 72 |e length| of char|
|00000970| 2e 14 00 31 20 52 6f 77 | 20 43 68 61 72 20 46 75 |...1 Row| Char Fu|
|00000980| 6e 63 74 69 6f 6e 73 02 | 00 c1 0c 2d 00 20 4c 4f |nctions.|...-. LO|
|00000990| 57 45 52 28 63 68 61 72 | 29 20 20 20 20 20 20 20 |WER(char|) |
|000009a0| 52 65 74 75 72 6e 73 20 | 63 68 61 72 20 69 6e 20 |Returns |char in |
|000009b0| 6c 6f 77 65 72 63 61 73 | 65 2e 14 00 31 20 52 6f |lowercas|e...1 Ro|
|000009c0| 77 20 43 68 61 72 20 46 | 75 6e 63 74 69 6f 6e 73 |w Char F|unctions|
|000009d0| 02 00 c1 0d 42 00 20 4c | 50 41 44 28 63 68 61 72 |....B. L|PAD(char|
|000009e0| 31 2c 20 20 20 20 20 20 | 20 41 64 64 73 20 63 68 |1, | Adds ch|
|000009f0| 61 72 32 20 6e 20 6e 75 | 6d 62 65 72 20 6f 66 20 |ar2 n nu|mber of |
|00000a00| 74 69 6d 65 73 20 69 6e | 20 66 72 6f 6e 74 20 6f |times in| front o|
|00000a10| 66 20 63 68 61 72 31 2e | 14 00 31 20 52 6f 77 20 |f char1.|..1 Row |
|00000a20| 43 68 61 72 20 46 75 6e | 63 74 69 6f 6e 73 02 00 |Char Fun|ctions..|
|00000a30| c1 0e 0c 00 20 20 20 6e | 2c 20 63 68 61 72 32 29 |.... n|, char2)|
|00000a40| 14 00 31 20 52 6f 77 20 | 43 68 61 72 20 46 75 6e |..1 Row |Char Fun|
|00000a50| 63 74 69 6f 6e 73 02 00 | c1 0f 4a 00 20 4c 54 52 |ctions..|..J. LTR|
|00000a60| 49 4d 28 63 68 61 72 2c | 20 73 29 20 20 20 20 52 |IM(char,| s) R|
|00000a70| 65 6d 6f 76 65 73 20 62 | 65 67 69 6e 6e 69 6e 67 |emoves b|eginning|
|00000a80| 20 63 68 61 72 61 63 74 | 65 72 73 20 66 72 6f 6d | charact|ers from|
|00000a90| 20 63 68 61 72 2c 20 75 | 70 20 74 6f 20 74 68 65 | char, u|p to the|
|00000aa0| 20 66 69 72 73 74 14 00 | 31 20 52 6f 77 20 43 68 | first..|1 Row Ch|
|00000ab0| 61 72 20 46 75 6e 63 74 | 69 6f 6e 73 02 00 c1 10 |ar Funct|ions....|
|00000ac0| 42 00 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |B. | |
|00000ad0| 20 20 20 20 20 20 20 20 | 63 68 61 72 61 63 74 65 | |characte|
|00000ae0| 72 20 6e 6f 74 20 69 6e | 20 74 68 65 20 73 20 73 |r not in| the s s|
|00000af0| 65 74 3b 20 73 20 3d 20 | 27 27 69 66 20 61 62 73 |et; s = |''if abs|
|00000b00| 65 6e 74 2e 14 00 31 20 | 52 6f 77 20 43 68 61 72 |ent...1 |Row Char|
|00000b10| 20 46 75 6e 63 74 69 6f | 6e 73 02 00 c1 11 45 00 | Functio|ns....E.|
|00000b20| 20 4e 4c 53 53 4f 52 54 | 28 63 68 61 72 29 20 20 | NLSSORT|(char) |
|00000b30| 20 20 20 47 69 76 65 73 | 20 63 68 61 72 27 73 20 | Gives| char's |
|00000b40| 4e 61 74 69 6f 6e 61 6c | 20 4c 61 6e 67 75 61 67 |National| Languag|
|00000b50| 65 20 63 6f 6c 6c 61 74 | 69 6e 67 20 73 65 71 75 |e collat|ing sequ|
|00000b60| 65 6e 63 65 2e 14 00 31 | 20 52 6f 77 20 43 68 61 |ence...1| Row Cha|
|00000b70| 72 20 46 75 6e 63 74 69 | 6f 6e 73 02 00 c1 12 46 |r Functi|ons....F|
|00000b80| 00 20 52 45 50 4c 41 43 | 45 28 63 68 61 72 2c 20 |. REPLAC|E(char, |
|00000b90| 20 20 20 20 43 68 61 6e | 67 65 73 20 65 61 63 68 | Chan|ges each|
|00000ba0| 20 66 69 6e 64 20 69 6e | 20 63 68 61 72 20 74 6f | find in| char to|
|00000bb0| 20 6e 65 77 3b 20 6f 6d | 69 74 20 6e 65 77 20 74 | new; om|it new t|
|00000bc0| 6f 20 65 72 61 73 65 14 | 00 31 20 52 6f 77 20 43 |o erase.|.1 Row C|
|00000bd0| 68 61 72 20 46 75 6e 63 | 74 69 6f 6e 73 02 00 c1 |har Func|tions...|
|00000be0| 13 41 00 20 20 20 66 69 | 6e 64 2c 20 6e 65 77 29 |.A. fi|nd, new)|
|00000bf0| 20 20 20 20 20 20 20 20 | 20 66 69 6e 64 2e 20 20 | | find. |
|00000c00| 55 73 65 20 54 52 41 4e | 53 4c 41 54 45 20 66 6f |Use TRAN|SLATE fo|
|00000c10| 72 20 73 69 6e 67 6c 65 | 20 63 68 61 72 61 63 74 |r single| charact|
|00000c20| 65 72 73 2e 14 00 31 20 | 52 6f 77 20 43 68 61 72 |ers...1 |Row Char|
|00000c30| 20 46 75 6e 63 74 69 6f | 6e 73 02 00 c1 14 3c 00 | Functio|ns....<.|
|00000c40| 20 52 50 41 44 28 63 68 | 61 72 31 2c 20 6e 2c 20 | RPAD(ch|ar1, n, |
|00000c50| 20 20 20 41 64 64 73 20 | 63 68 61 72 32 20 6e 20 | Adds |char2 n |
|00000c60| 6e 75 6d 62 65 72 20 6f | 66 20 74 69 6d 65 73 20 |number o|f times |
|00000c70| 61 66 74 65 72 20 63 68 | 61 72 31 2e 14 00 31 20 |after ch|ar1...1 |
|00000c80| 52 6f 77 20 43 68 61 72 | 20 46 75 6e 63 74 69 6f |Row Char| Functio|
|00000c90| 6e 73 02 00 c1 15 09 00 | 20 20 20 63 68 61 72 32 |ns......| char2|
|00000ca0| 29 14 00 31 20 52 6f 77 | 20 43 68 61 72 20 46 75 |)..1 Row| Char Fu|
|00000cb0| 6e 63 74 69 6f 6e 73 02 | 00 c1 16 44 00 20 52 54 |nctions.|...D. RT|
|00000cc0| 52 49 4d 28 63 68 61 72 | 2c 20 73 65 74 29 20 20 |RIM(char|, set) |
|00000cd0| 52 65 6d 6f 76 65 73 20 | 63 68 61 72 61 63 74 65 |Removes |characte|
|00000ce0| 72 73 20 66 72 6f 6d 20 | 74 68 65 20 65 6e 64 20 |rs from |the end |
|00000cf0| 6f 66 20 63 68 61 72 20 | 75 6e 74 69 6c 20 74 68 |of char |until th|
|00000d00| 65 14 00 31 20 52 6f 77 | 20 43 68 61 72 20 46 75 |e..1 Row| Char Fu|
|00000d10| 6e 63 74 69 6f 6e 73 02 | 00 c1 17 44 00 20 20 20 |nctions.|...D. |
|00000d20| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00000d30| 20 20 20 66 69 72 73 74 | 20 63 68 61 72 61 63 74 | first| charact|
|00000d40| 65 72 20 6e 6f 74 20 69 | 6e 20 73 65 74 3b 20 73 |er not i|n set; s|
|00000d50| 65 74 20 3d 20 27 27 69 | 66 20 61 62 73 65 6e 74 |et = ''i|f absent|
|00000d60| 2e 14 00 31 20 52 6f 77 | 20 43 68 61 72 20 46 75 |...1 Row| Char Fu|
|00000d70| 6e 63 74 69 6f 6e 73 02 | 00 c1 18 42 00 20 53 4f |nctions.|...B. SO|
|00000d80| 55 4e 44 45 58 28 63 68 | 61 72 29 20 20 20 20 20 |UNDEX(ch|ar) |
|00000d90| 52 65 74 75 72 6e 73 20 | 73 74 72 69 6e 67 20 70 |Returns |string p|
|00000da0| 68 6f 6e 65 74 69 63 61 | 6c 6c 79 20 65 71 75 69 |honetica|lly equi|
|00000db0| 76 61 6c 65 6e 74 20 74 | 6f 20 63 68 61 72 2e 14 |valent t|o char..|
|00000dc0| 00 31 20 52 6f 77 20 43 | 68 61 72 20 46 75 6e 63 |.1 Row C|har Func|
|00000dd0| 74 69 6f 6e 73 02 00 c1 | 19 44 00 20 53 55 42 53 |tions...|.D. SUBS|
|00000de0| 54 52 28 63 68 61 72 2c | 20 20 20 20 20 20 52 65 |TR(char,| Re|
|00000df0| 74 75 72 6e 73 20 6e 20 | 63 68 61 72 61 63 74 65 |turns n |characte|
|00000e00| 72 73 20 69 6e 20 63 68 | 61 72 2c 20 73 74 61 72 |rs in ch|ar, star|
|00000e10| 74 69 6e 67 20 61 74 20 | 63 68 61 72 20 63 2e 14 |ting at |char c..|
|00000e20| 00 31 20 52 6f 77 20 43 | 68 61 72 20 46 75 6e 63 |.1 Row C|har Func|
|00000e30| 74 69 6f 6e 73 02 00 c1 | 1a 08 00 20 20 20 63 2c |tions...|... c,|
|00000e40| 20 6e 29 14 00 31 20 52 | 6f 77 20 43 68 61 72 20 | n)..1 R|ow Char |
|00000e50| 46 75 6e 63 74 69 6f 6e | 73 02 00 c1 1b 3e 00 20 |Function|s....>. |
|00000e60| 54 52 41 4e 53 4c 41 54 | 45 28 63 68 61 72 2c 20 |TRANSLAT|E(char, |
|00000e70| 20 20 52 65 74 75 72 6e | 73 20 63 68 61 72 20 77 | Return|s char w|
|00000e80| 69 74 68 20 65 61 63 68 | 20 66 69 6e 64 20 63 68 |ith each| find ch|
|00000e90| 61 6e 67 65 64 20 74 6f | 20 6e 65 77 2e 14 00 31 |anged to| new...1|
|00000ea0| 20 52 6f 77 20 43 68 61 | 72 20 46 75 6e 63 74 69 | Row Cha|r Functi|
|00000eb0| 6f 6e 73 02 00 c1 1c 0d | 00 20 20 20 66 69 6e 64 |ons.....|. find|
|00000ec0| 2c 20 6e 65 77 29 14 00 | 31 20 52 6f 77 20 43 68 |, new)..|1 Row Ch|
|00000ed0| 61 72 20 46 75 6e 63 74 | 69 6f 6e 73 02 00 c1 1d |ar Funct|ions....|
|00000ee0| 2d 00 20 55 50 50 45 52 | 28 63 68 61 72 29 20 20 |-. UPPER|(char) |
|00000ef0| 20 20 20 20 20 52 65 74 | 75 72 6e 73 20 63 68 61 | Ret|urns cha|
|00000f00| 72 20 69 6e 20 55 50 50 | 45 52 43 41 53 45 2e 14 |r in UPP|ERCASE..|
|00000f10| 00 31 20 52 6f 77 20 43 | 68 61 72 20 46 75 6e 63 |.1 Row C|har Func|
|00000f20| 74 69 6f 6e 73 02 00 c1 | 1e fe ff 14 00 31 20 52 |tions...|.....1 R|
|00000f30| 6f 77 20 43 68 61 72 20 | 46 75 6e 63 74 69 6f 6e |ow Char |Function|
|00000f40| 73 02 00 c1 1f fe ff 14 | 00 31 20 52 6f 77 20 43 |s.......|.1 Row C|
|00000f50| 68 61 72 20 46 75 6e 63 | 74 69 6f 6e 73 02 00 c1 |har Func|tions...|
|00000f60| 20 45 00 20 53 65 65 20 | 61 6c 73 6f 3a 20 31 20 | E. See |also: 1 |
|00000f70| 72 6f 77 20 6e 75 6d 62 | 65 72 2c 20 63 6f 6e 76 |row numb|er, conv|
|00000f80| 65 72 73 69 6f 6e 2c 20 | 64 61 74 65 20 66 75 6e |ersion, |date fun|
|00000f90| 63 74 69 6f 6e 73 2c 20 | 65 72 72 6f 72 20 72 65 |ctions, |error re|
|00000fa0| 70 6f 72 74 69 6e 67 2c | 14 00 31 20 52 6f 77 20 |porting,|..1 Row |
|00000fb0| 43 68 61 72 20 46 75 6e | 63 74 69 6f 6e 73 02 00 |Char Fun|ctions..|
|00000fc0| c1 21 38 00 20 20 20 20 | 20 20 20 20 20 20 20 20 |.!8. | |
|00000fd0| 20 20 20 20 20 67 72 6f | 75 70 2c 20 6f 74 68 65 | gro|up, othe|
|00000fe0| 72 20 66 75 6e 63 74 69 | 6f 6e 73 2c 20 63 6f 6d |r functi|ons, com|
|00000ff0| 6d 61 6e 64 73 2c 20 6d | 65 6e 75 2e 16 00 31 20 |mands, m|enu...1 |
|00001000| 52 6f 77 20 4e 75 6d 62 | 65 72 20 46 75 6e 63 74 |Row Numb|er Funct|
|00001010| 69 6f 6e 73 02 00 c1 02 | fe ff 16 00 31 20 52 6f |ions....|....1 Ro|
|00001020| 77 20 4e 75 6d 62 65 72 | 20 46 75 6e 63 74 69 6f |w Number| Functio|
|00001030| 6e 73 02 00 c1 03 fe ff | 16 00 31 20 52 6f 77 20 |ns......|..1 Row |
|00001040| 4e 75 6d 62 65 72 20 46 | 75 6e 63 74 69 6f 6e 73 |Number F|unctions|
|00001050| 02 00 c1 04 29 00 20 20 | 20 20 20 20 20 20 20 20 |....). | |
|00001060| 20 20 20 20 20 20 20 20 | 20 31 20 52 6f 77 20 4e | | 1 Row N|
|00001070| 75 6d 62 65 72 20 46 75 | 6e 63 74 69 6f 6e 73 16 |umber Fu|nctions.|
|00001080| 00 31 20 52 6f 77 20 4e | 75 6d 62 65 72 20 46 75 |.1 Row N|umber Fu|
|00001090| 6e 63 74 69 6f 6e 73 02 | 00 c1 05 fe ff 16 00 31 |nctions.|.......1|
|000010a0| 20 52 6f 77 20 4e 75 6d | 62 65 72 20 46 75 6e 63 | Row Num|ber Func|
|000010b0| 74 69 6f 6e 73 02 00 c1 | 06 2f 00 20 41 42 53 28 |tions...|./. ABS(|
|000010c0| 6e 29 20 20 20 20 20 20 | 20 20 52 65 74 75 72 6e |n) | Return|
|000010d0| 73 20 74 68 65 20 61 62 | 73 6f 6c 75 74 65 20 76 |s the ab|solute v|
|000010e0| 61 6c 75 65 20 6f 66 20 | 6e 2e 16 00 31 20 52 6f |alue of |n...1 Ro|
|000010f0| 77 20 4e 75 6d 62 65 72 | 20 46 75 6e 63 74 69 6f |w Number| Functio|
|00001100| 6e 73 02 00 c1 07 fe ff | 16 00 31 20 52 6f 77 20 |ns......|..1 Row |
|00001110| 4e 75 6d 62 65 72 20 46 | 75 6e 63 74 69 6f 6e 73 |Number F|unctions|
|00001120| 02 00 c1 08 47 00 20 43 | 45 49 4c 28 6e 29 20 20 |....G. C|EIL(n) |
|00001130| 20 20 20 20 20 52 65 74 | 75 72 6e 73 20 74 68 65 | Ret|urns the|
|00001140| 20 73 6d 61 6c 6c 65 73 | 74 20 69 6e 74 65 67 65 | smalles|t intege|
|00001150| 72 20 67 72 65 61 74 65 | 72 20 74 68 61 6e 20 6f |r greate|r than o|
|00001160| 72 20 65 71 75 61 6c 20 | 74 6f 20 6e 2e 16 00 31 |r equal |to n...1|
|00001170| 20 52 6f 77 20 4e 75 6d | 62 65 72 20 46 75 6e 63 | Row Num|ber Func|
|00001180| 74 69 6f 6e 73 02 00 c1 | 09 fe ff 16 00 31 20 52 |tions...|.....1 R|
|00001190| 6f 77 20 4e 75 6d 62 65 | 72 20 46 75 6e 63 74 69 |ow Numbe|r Functi|
|000011a0| 6f 6e 73 02 00 c1 0a 43 | 00 20 46 4c 4f 4f 52 28 |ons....C|. FLOOR(|
|000011b0| 6e 29 20 20 20 20 20 20 | 52 65 74 75 72 6e 73 20 |n) |Returns |
|000011c0| 74 68 65 20 6c 61 72 67 | 65 73 74 20 69 6e 74 65 |the larg|est inte|
|000011d0| 67 65 72 20 6c 65 73 73 | 20 74 68 61 6e 20 6f 72 |ger less| than or|
|000011e0| 20 65 71 75 61 6c 20 74 | 6f 20 6e 2e 16 00 31 20 | equal t|o n...1 |
|000011f0| 52 6f 77 20 4e 75 6d 62 | 65 72 20 46 75 6e 63 74 |Row Numb|er Funct|
|00001200| 69 6f 6e 73 02 00 c1 0b | fe ff 16 00 31 20 52 6f |ions....|....1 Ro|
|00001210| 77 20 4e 75 6d 62 65 72 | 20 46 75 6e 63 74 69 6f |w Number| Functio|
|00001220| 6e 73 02 00 c1 0c 47 00 | 20 4d 4f 44 28 6d 2c 6e |ns....G.| MOD(m,n|
|00001230| 29 20 20 20 20 20 20 52 | 65 74 75 72 6e 73 20 72 |) R|eturns r|
|00001240| 65 73 75 6c 74 20 6f 66 | 20 6d 20 64 69 76 69 64 |esult of| m divid|
|00001250| 65 64 20 62 79 20 6e 3b | 20 6f 72 20 69 66 20 6e |ed by n;| or if n|
|00001260| 3d 30 2c 20 6d 20 72 65 | 74 75 72 6e 65 64 2e 16 |=0, m re|turned..|
|00001270| 00 31 20 52 6f 77 20 4e | 75 6d 62 65 72 20 46 75 |.1 Row N|umber Fu|
|00001280| 6e 63 74 69 6f 6e 73 02 | 00 c1 0d fe ff 16 00 31 |nctions.|.......1|
|00001290| 20 52 6f 77 20 4e 75 6d | 62 65 72 20 46 75 6e 63 | Row Num|ber Func|
|000012a0| 74 69 6f 6e 73 02 00 c1 | 0e 47 00 20 50 4f 57 45 |tions...|.G. POWE|
|000012b0| 52 28 6d 2c 6e 29 20 20 | 20 20 52 65 74 75 72 6e |R(m,n) | Return|
|000012c0| 73 20 6d 20 72 61 69 73 | 65 64 20 74 6f 20 74 68 |s m rais|ed to th|
|000012d0| 65 20 6e 74 68 20 70 6f | 77 65 72 3b 20 6e 20 6d |e nth po|wer; n m|
|000012e0| 75 73 74 20 62 65 20 61 | 6e 20 69 6e 74 65 67 65 |ust be a|n intege|
|000012f0| 72 2e 16 00 31 20 52 6f | 77 20 4e 75 6d 62 65 72 |r...1 Ro|w Number|
|00001300| 20 46 75 6e 63 74 69 6f | 6e 73 02 00 c1 0f fe ff | Functio|ns......|
|00001310| 16 00 31 20 52 6f 77 20 | 4e 75 6d 62 65 72 20 46 |..1 Row |Number F|
|00001320| 75 6e 63 74 69 6f 6e 73 | 02 00 c1 10 40 00 20 52 |unctions|....@. R|
|00001330| 4f 55 4e 44 28 6d 2c 6e | 29 20 20 20 20 52 65 74 |OUND(m,n|) Ret|
|00001340| 75 72 6e 73 20 6d 20 72 | 6f 75 6e 64 65 64 20 74 |urns m r|ounded t|
|00001350| 6f 20 6e 20 28 6f 70 74 | 69 6f 6e 61 6c 29 20 64 |o n (opt|ional) d|
|00001360| 65 63 69 6d 61 6c 20 70 | 6c 61 63 65 73 2e 16 00 |ecimal p|laces...|
|00001370| 31 20 52 6f 77 20 4e 75 | 6d 62 65 72 20 46 75 6e |1 Row Nu|mber Fun|
|00001380| 63 74 69 6f 6e 73 02 00 | c1 11 fe ff 16 00 31 20 |ctions..|......1 |
|00001390| 52 6f 77 20 4e 75 6d 62 | 65 72 20 46 75 6e 63 74 |Row Numb|er Funct|
|000013a0| 69 6f 6e 73 02 00 c1 12 | 49 00 20 53 49 47 4e 28 |ions....|I. SIGN(|
|000013b0| 6e 29 20 20 20 20 20 20 | 20 52 65 74 75 72 6e 73 |n) | Returns|
|000013c0| 20 2d 31 20 69 66 20 6e | 20 69 73 20 6e 65 67 61 | -1 if n| is nega|
|000013d0| 74 69 76 65 2c 20 31 20 | 69 66 20 6e 20 69 73 20 |tive, 1 |if n is |
|000013e0| 70 6f 73 69 74 69 76 65 | 2c 20 30 20 69 66 20 6e |positive|, 0 if n|
|000013f0| 3d 30 2e 16 00 31 20 52 | 6f 77 20 4e 75 6d 62 65 |=0...1 R|ow Numbe|
|00001400| 72 20 46 75 6e 63 74 69 | 6f 6e 73 02 00 c1 13 fe |r Functi|ons.....|
|00001410| ff 16 00 31 20 52 6f 77 | 20 4e 75 6d 62 65 72 20 |...1 Row| Number |
|00001420| 46 75 6e 63 74 69 6f 6e | 73 02 00 c1 14 2c 00 20 |Function|s....,. |
|00001430| 53 51 52 54 28 6e 29 20 | 20 20 20 20 20 20 52 65 |SQRT(n) | Re|
|00001440| 74 75 72 6e 73 20 74 68 | 65 20 73 71 75 61 72 65 |turns th|e square|
|00001450| 20 72 6f 6f 74 20 6f 66 | 20 6e 2e 16 00 31 20 52 | root of| n...1 R|
|00001460| 6f 77 20 4e 75 6d 62 65 | 72 20 46 75 6e 63 74 69 |ow Numbe|r Functi|
|00001470| 6f 6e 73 02 00 c1 15 fe | ff 16 00 31 20 52 6f 77 |ons.....|...1 Row|
|00001480| 20 4e 75 6d 62 65 72 20 | 46 75 6e 63 74 69 6f 6e | Number |Function|
|00001490| 73 02 00 c1 16 49 00 20 | 54 52 55 4e 43 28 6d 2c |s....I. |TRUNC(m,|
|000014a0| 6e 29 20 20 20 20 53 74 | 72 69 70 73 20 6d 20 74 |n) St|rips m t|
|000014b0| 6f 20 6e 20 28 6f 70 74 | 29 20 70 6c 61 63 65 73 |o n (opt|) places|
|000014c0| 3b 20 2d 6e 20 61 64 64 | 73 20 6e 20 7a 65 72 6f |; -n add|s n zero|
|000014d0| 73 20 74 6f 20 61 6e 20 | 69 6e 74 65 67 65 72 2e |s to an |integer.|
|000014e0| 16 00 31 20 52 6f 77 20 | 4e 75 6d 62 65 72 20 46 |..1 Row |Number F|
|000014f0| 75 6e 63 74 69 6f 6e 73 | 02 00 c1 17 fe ff 16 00 |unctions|........|
|00001500| 31 20 52 6f 77 20 4e 75 | 6d 62 65 72 20 46 75 6e |1 Row Nu|mber Fun|
|00001510| 63 74 69 6f 6e 73 02 00 | c1 18 fe ff 16 00 31 20 |ctions..|......1 |
|00001520| 52 6f 77 20 4e 75 6d 62 | 65 72 20 46 75 6e 63 74 |Row Numb|er Funct|
|00001530| 69 6f 6e 73 02 00 c1 19 | 43 00 20 53 65 65 20 61 |ions....|C. See a|
|00001540| 6c 73 6f 3a 20 31 20 72 | 6f 77 20 63 68 61 72 2c |lso: 1 r|ow char,|
|00001550| 20 63 6f 6e 76 65 72 73 | 69 6f 6e 2c 20 64 61 74 | convers|ion, dat|
|00001560| 65 20 66 75 6e 63 74 69 | 6f 6e 73 2c 20 65 72 72 |e functi|ons, err|
|00001570| 6f 72 20 72 65 70 6f 72 | 74 69 6e 67 2c 16 00 31 |or repor|ting,..1|
|00001580| 20 52 6f 77 20 4e 75 6d | 62 65 72 20 46 75 6e 63 | Row Num|ber Func|
|00001590| 74 69 6f 6e 73 02 00 c1 | 1a 39 00 20 20 20 20 20 |tions...|.9. |
|000015a0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 67 72 6f | | gro|
|000015b0| 75 70 2c 20 6f 74 68 65 | 72 20 66 75 6e 63 74 69 |up, othe|r functi|
|000015c0| 6f 6e 73 2c 20 63 6f 6d | 6d 61 6e 64 73 2c 20 6d |ons, com|mands, m|
|000015d0| 65 6e 75 2e 01 00 40 02 | 00 c1 02 02 00 20 40 01 |enu...@.|..... @.|
|000015e0| 00 40 02 00 c1 03 2c 00 | 20 20 20 20 20 20 20 20 |.@....,.| |
|000015f0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00001600| 20 20 20 20 20 20 20 40 | 20 28 22 61 74 22 20 73 | @| ("at" s|
|00001610| 69 67 6e 29 01 00 40 02 | 00 c1 04 fe ff 01 00 40 |ign)..@.|.......@|
|00001620| 02 00 c1 05 13 00 20 40 | 20 66 69 6c 65 5f 6e 61 |...... @| file_na|
|00001630| 6d 65 5b 2e 65 78 74 20 | 5d 01 00 40 02 00 c1 06 |me[.ext |]..@....|
|00001640| fe ff 01 00 40 02 00 c1 | 07 21 00 20 52 75 6e 73 |....@...|.!. Runs|
|00001650| 20 74 68 65 20 73 70 65 | 63 69 66 69 65 64 20 63 | the spe|cified c|
|00001660| 6f 6d 6d 61 6e 64 20 66 | 69 6c 65 2e 01 00 40 02 |ommand f|ile...@.|
|00001670| 00 c1 08 fe ff 01 00 40 | 02 00 c1 09 15 00 20 20 |.......@|...... |
|00001680| 20 20 20 66 69 6c 65 5f | 6e 61 6d 65 5b 2e 65 78 | file_|name[.ex|
|00001690| 74 20 5d 01 00 40 02 00 | c1 0a 47 00 20 20 20 20 |t ]..@..|..G. |
|000016a0| 20 20 20 20 20 69 73 20 | 74 68 65 20 63 6f 6d 6d | is |the comm|
|000016b0| 61 6e 64 20 66 69 6c 65 | 20 79 6f 75 20 77 69 73 |and file| you wis|
|000016c0| 68 20 74 6f 20 72 75 6e | 2e 20 49 66 20 79 6f 75 |h to run|. If you|
|000016d0| 20 6f 6d 69 74 20 65 78 | 74 2c 20 53 51 4c 2a 50 | omit ex|t, SQL*P|
|000016e0| 6c 75 73 01 00 40 02 00 | c1 0b 46 00 20 20 20 20 |lus..@..|..F. |
|000016f0| 20 20 20 20 20 61 73 73 | 75 6d 65 73 20 74 68 65 | ass|umes the|
|00001700| 20 64 65 66 61 75 6c 74 | 20 63 6f 6d 6d 61 6e 64 | default| command|
|00001710| 2d 66 69 6c 65 20 65 78 | 74 65 6e 73 69 6f 6e 20 |-file ex|tension |
|00001720| 28 75 73 75 61 6c 6c 79 | 20 53 51 4c 29 2e 20 20 |(usually| SQL). |
|00001730| 54 6f 01 00 40 02 00 c1 | 0c 47 00 20 20 20 20 20 |To..@...|.G. |
|00001740| 20 20 20 20 63 68 61 6e | 67 65 20 74 68 65 20 64 | chan|ge the d|
|00001750| 65 66 61 75 6c 74 20 65 | 78 74 65 6e 73 69 6f 6e |efault e|xtension|
|00001760| 2c 20 75 73 65 20 74 68 | 65 20 53 55 46 46 49 58 |, use th|e SUFFIX|
|00001770| 20 63 6c 61 75 73 65 20 | 6f 66 20 74 68 65 20 53 | clause |of the S|
|00001780| 45 54 01 00 40 02 00 c1 | 0d 48 00 20 20 20 20 20 |ET..@...|.H. |
|00001790| 20 20 20 20 63 6f 6d 6d | 61 6e 64 2e 20 20 55 73 | comm|and. Us|
|000017a0| 65 20 40 66 69 6c 65 5f | 6e 61 6d 65 20 6f 72 20 |e @file_|name or |
|000017b0| 40 20 66 69 6c 65 5f 6e | 61 6d 65 3b 20 74 68 65 |@ file_n|ame; the|
|000017c0| 20 73 70 61 63 65 20 69 | 73 20 6f 70 74 69 6f 6e | space i|s option|
|000017d0| 61 6c 2e 01 00 40 02 00 | c1 0e 40 00 20 20 20 20 |al...@..|..@. |
|000017e0| 20 20 20 20 20 43 61 73 | 65 20 6d 61 79 20 62 65 | Cas|e may be|
|000017f0| 20 73 69 67 6e 69 66 69 | 63 61 6e 74 20 69 6e 20 | signifi|cant in |
|00001800| 73 6f 6d 65 20 6f 70 65 | 72 61 74 69 6e 67 20 65 |some ope|rating e|
|00001810| 6e 76 69 72 6f 6e 6d 65 | 6e 74 73 2e 01 00 40 02 |nvironme|nts...@.|
|00001820| 00 c1 0f fe ff 01 00 40 | 02 00 c1 10 47 00 20 59 |.......@|....G. Y|
|00001830| 6f 75 20 63 61 6e 20 69 | 6e 63 6c 75 64 65 20 69 |ou can i|nclude i|
|00001840| 6e 20 61 20 63 6f 6d 6d | 61 6e 64 20 66 69 6c 65 |n a comm|and file|
|00001850| 20 61 6e 79 20 74 79 70 | 65 61 62 6c 65 20 63 6f | any typ|eable co|
|00001860| 6d 6d 61 6e 64 2d 2d 75 | 73 75 61 6c 6c 79 20 53 |mmand--u|sually S|
|00001870| 51 4c 20 6f 72 01 00 40 | 02 00 c1 11 47 00 20 53 |QL or..@|....G. S|
|00001880| 51 4c 2a 50 6c 75 73 20 | 63 6f 6d 6d 61 6e 64 73 |QL*Plus |commands|
|00001890| 2e 20 20 54 68 65 20 40 | 20 63 6f 6d 6d 61 6e 64 |. The @| command|
|000018a0| 20 77 6f 72 6b 73 20 6c | 69 6b 65 20 53 54 41 52 | works l|ike STAR|
|000018b0| 54 2c 20 62 75 74 20 64 | 6f 65 73 20 6e 6f 74 20 |T, but d|oes not |
|000018c0| 61 6c 6c 6f 77 01 00 40 | 02 00 c1 12 23 00 20 76 |allow..@|....#. v|
|000018d0| 61 6c 75 65 73 20 74 6f | 20 62 65 20 70 61 73 73 |alues to| be pass|
|000018e0| 65 64 20 74 6f 20 70 61 | 72 61 6d 65 74 65 72 73 |ed to pa|rameters|
|000018f0| 2e 01 00 40 02 00 c1 13 | fe ff 01 00 40 02 00 c1 |...@....|....@...|
|00001900| 14 0a 00 20 45 78 61 6d | 70 6c 65 73 3a 01 00 40 |... Exam|ples:..@|
|00001910| 02 00 c1 15 fe ff 01 00 | 40 02 00 c1 16 35 00 20 |........|@....5. |
|00001920| 20 20 20 20 54 6f 20 72 | 75 6e 20 61 20 63 6f 6d | To r|un a com|
|00001930| 6d 61 6e 64 20 66 69 6c | 65 20 6e 61 6d 65 64 20 |mand fil|e named |
|00001940| 50 52 49 4e 54 52 50 54 | 2e 53 51 4c 2c 20 65 6e |PRINTRPT|.SQL, en|
|00001950| 74 65 72 3a 01 00 40 02 | 00 c1 17 fe ff 01 00 40 |ter:..@.|.......@|
|00001960| 02 00 c1 18 17 00 20 20 | 20 20 20 20 20 20 20 53 |...... | S|
|00001970| 51 4c 3e 20 40 50 52 49 | 4e 54 52 50 54 01 00 40 |QL> @PRI|NTRPT..@|
|00001980| 02 00 c1 19 fe ff 01 00 | 40 02 00 c1 1a fe ff 01 |........|@.......|
|00001990| 00 40 02 00 c1 1b 41 00 | 20 20 20 20 20 54 6f 20 |.@....A.| To |
|000019a0| 72 75 6e 20 74 68 65 20 | 63 6f 6d 6d 61 6e 64 20 |run the |command |
|000019b0| 66 69 6c 65 20 57 4b 52 | 50 54 20 77 69 74 68 20 |file WKR|PT with |
|000019c0| 74 68 65 20 65 78 74 65 | 6e 73 69 6f 6e 20 51 52 |the exte|nsion QR|
|000019d0| 59 2c 20 65 6e 74 65 72 | 3a 01 00 40 02 00 c1 1c |Y, enter|:..@....|
|000019e0| fe ff 01 00 40 02 00 c1 | 1d 18 00 20 20 20 20 20 |....@...|... |
|000019f0| 20 20 20 20 53 51 4c 3e | 20 40 57 4b 52 50 54 2e | SQL>| @WKRPT.|
|00001a00| 51 52 59 01 00 40 02 00 | c1 1e fe ff 01 00 40 02 |QRY..@..|......@.|
|00001a10| 00 c1 1f fe ff 01 00 40 | 02 00 c1 20 45 00 20 53 |.......@|... E. S|
|00001a20| 65 65 20 61 6c 73 6f 3a | 20 73 75 66 66 69 78 2c |ee also:| suffix,|
|00001a30| 20 73 74 61 72 74 2c 20 | 2f 2c 20 65 64 69 74 2c | start, |/, edit,|
|00001a40| 20 72 75 6e 2c 20 67 65 | 74 2c 20 73 65 74 20 28 | run, ge|t, set (|
|00001a50| 53 51 4c 20 62 75 66 66 | 65 72 29 2c 20 73 70 6f |SQL buff|er), spo|
|00001a60| 6f 6c 2c 01 00 40 02 00 | c1 21 32 00 20 20 20 20 |ol,..@..|.!2. |
|00001a70| 20 20 20 20 20 20 20 6c | 69 73 74 2c 20 73 61 76 | l|ist, sav|
|00001a80| 65 2c 20 70 61 72 61 6d | 65 74 65 72 73 2c 20 63 |e, param|eters, c|
|00001a90| 6f 6d 6d 61 6e 64 73 2c | 20 6d 65 6e 75 2e 06 00 |ommands,| menu...|
|00001aa0| 41 43 43 45 50 54 02 00 | c1 02 fe ff 06 00 41 43 |ACCEPT..|......AC|
|00001ab0| 43 45 50 54 02 00 c1 03 | fe ff 06 00 41 43 43 45 |CEPT....|....ACCE|
|00001ac0| 50 54 02 00 c1 04 29 00 | 20 20 20 20 20 20 20 20 |PT....).| |
|00001ad0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00001ae0| 20 20 20 20 20 20 20 20 | 20 20 20 41 43 43 45 50 | | ACCEP|
|00001af0| 54 06 00 41 43 43 45 50 | 54 02 00 c1 05 fe ff 06 |T..ACCEP|T.......|
|00001b00| 00 41 43 43 45 50 54 02 | 00 c1 06 42 00 20 41 43 |.ACCEPT.|...B. AC|
|00001b10| 43 5b 45 50 54 5d 20 76 | 61 72 69 61 62 6c 65 20 |C[EPT] v|ariable |
|00001b20| 5b 4e 55 4d 5b 42 45 52 | 5d 7c 43 48 41 52 5d 20 |[NUM[BER|]|CHAR] |
|00001b30| 5b 50 52 4f 4d 50 54 20 | 74 65 78 74 7c 4e 4f 50 |[PROMPT |text|NOP|
|00001b40| 52 5b 4f 4d 50 54 5d 5d | 20 5b 48 49 44 45 5d 06 |R[OMPT]]| [HIDE].|
|00001b50| 00 41 43 43 45 50 54 02 | 00 c1 07 fe ff 06 00 41 |.ACCEPT.|.......A|
|00001b60| 43 43 45 50 54 02 00 c1 | 08 45 00 20 41 43 43 45 |CCEPT...|.E. ACCE|
|00001b70| 50 54 20 72 65 61 64 73 | 20 61 20 6c 69 6e 65 20 |PT reads| a line |
|00001b80| 6f 66 20 69 6e 70 75 74 | 20 61 6e 64 20 73 74 6f |of input| and sto|
|00001b90| 72 65 73 20 69 74 20 69 | 6e 20 61 20 67 69 76 65 |res it i|n a give|
|00001ba0| 6e 20 75 73 65 72 20 76 | 61 72 69 61 62 6c 65 2e |n user v|ariable.|
|00001bb0| 06 00 41 43 43 45 50 54 | 02 00 c1 09 fe ff 06 00 |..ACCEPT|........|
|00001bc0| 41 43 43 45 50 54 02 00 | c1 0a 0d 00 20 20 20 20 |ACCEPT..|.... |
|00001bd0| 20 76 61 72 69 61 62 6c | 65 06 00 41 43 43 45 50 | variabl|e..ACCEP|
|00001be0| 54 02 00 c1 0b 48 00 20 | 20 20 20 20 20 20 20 20 |T....H. | |
|00001bf0| 69 73 20 74 68 65 20 6e | 61 6d 65 20 6f 66 20 74 |is the n|ame of t|
|00001c00| 68 65 20 76 61 72 69 61 | 62 6c 65 20 69 6e 20 77 |he varia|ble in w|
|00001c10| 68 69 63 68 20 79 6f 75 | 20 77 69 73 68 20 74 6f |hich you| wish to|
|00001c20| 20 73 74 6f 72 65 20 61 | 20 76 61 6c 75 65 2e 06 | store a| value..|
|00001c30| 00 41 43 43 45 50 54 02 | 00 c1 0c 38 00 20 20 20 |.ACCEPT.|...8. |
|00001c40| 20 20 20 20 20 20 49 66 | 20 76 61 72 69 61 62 6c | If| variabl|
|00001c50| 65 20 64 6f 65 73 6e 27 | 74 20 65 78 69 73 74 2c |e doesn'|t exist,|
|00001c60| 20 53 51 4c 2a 50 6c 75 | 73 20 63 72 65 61 74 65 | SQL*Plu|s create|
|00001c70| 73 20 69 74 2e 06 00 41 | 43 43 45 50 54 02 00 c1 |s it...A|CCEPT...|
|00001c80| 0d fe ff 06 00 41 43 43 | 45 50 54 02 00 c1 0e 0d |.....ACC|EPT.....|
|00001c90| 00 20 20 20 20 20 4e 55 | 4d 5b 42 45 52 5d 06 00 |. NU|M[BER]..|
|00001ca0| 41 43 43 45 50 54 02 00 | c1 0f 4b 00 20 20 20 20 |ACCEPT..|..K. |
|00001cb0| 20 20 20 20 20 72 65 73 | 74 72 69 63 74 73 20 74 | res|tricts t|
|00001cc0| 68 65 20 64 61 74 61 74 | 79 70 65 20 6f 66 20 76 |he datat|ype of v|
|00001cd0| 61 72 69 61 62 6c 65 20 | 74 6f 20 74 68 65 20 64 |ariable |to the d|
|00001ce0| 61 74 61 74 79 70 65 20 | 4e 55 4d 42 45 52 2e 20 |atatype |NUMBER. |
|00001cf0| 20 49 66 20 74 68 65 06 | 00 41 43 43 45 50 54 02 | If the.|.ACCEPT.|
|00001d00| 00 c1 10 49 00 20 20 20 | 20 20 20 20 20 20 72 65 |...I. | re|
|00001d10| 70 6c 79 20 64 6f 65 73 | 20 6e 6f 74 20 6d 61 74 |ply does| not mat|
|00001d20| 63 68 20 74 68 65 20 64 | 61 74 61 74 79 70 65 2c |ch the d|atatype,|
|00001d30| 20 41 43 43 45 50 54 20 | 67 69 76 65 73 20 61 6e | ACCEPT |gives an|
|00001d40| 20 65 72 72 6f 72 20 6d | 65 73 73 61 67 65 06 00 | error m|essage..|
|00001d50| 41 43 43 45 50 54 02 00 | c1 11 18 00 20 20 20 20 |ACCEPT..|.... |
|00001d60| 20 20 20 20 20 61 6e 64 | 20 74 65 72 6d 69 6e 61 | and| termina|
|00001d70| 74 65 73 2e 06 00 41 43 | 43 45 50 54 02 00 c1 12 |tes...AC|CEPT....|
|00001d80| fe ff 06 00 41 43 43 45 | 50 54 02 00 c1 13 09 00 |....ACCE|PT......|
|00001d90| 20 20 20 20 20 43 48 41 | 52 06 00 41 43 43 45 50 | CHA|R..ACCEP|
|00001da0| 54 02 00 c1 14 49 00 20 | 20 20 20 20 20 20 20 20 |T....I. | |
|00001db0| 72 65 73 74 72 69 63 74 | 73 20 74 68 65 20 64 61 |restrict|s the da|
|00001dc0| 74 61 74 79 70 65 20 6f | 66 20 76 61 72 69 61 62 |tatype o|f variab|
|00001dd0| 6c 65 20 74 6f 20 74 68 | 65 20 64 61 74 61 74 79 |le to th|e dataty|
|00001de0| 70 65 20 43 48 41 52 2e | 20 20 49 66 20 74 68 65 |pe CHAR.| If the|
|00001df0| 06 00 41 43 43 45 50 54 | 02 00 c1 15 49 00 20 20 |..ACCEPT|....I. |
|00001e00| 20 20 20 20 20 20 20 72 | 65 70 6c 79 20 64 6f 65 | r|eply doe|
|00001e10| 73 20 6e 6f 74 20 6d 61 | 74 63 68 20 74 68 65 20 |s not ma|tch the |
|00001e20| 64 61 74 61 74 79 70 65 | 2c 20 41 43 43 45 50 54 |datatype|, ACCEPT|
|00001e30| 20 67 69 76 65 73 20 61 | 6e 20 65 72 72 6f 72 20 | gives a|n error |
|00001e40| 6d 65 73 73 61 67 65 06 | 00 41 43 43 45 50 54 02 |message.|.ACCEPT.|
|00001e50| 00 c1 16 18 00 20 20 20 | 20 20 20 20 20 20 61 6e |..... | an|
|00001e60| 64 20 74 65 72 6d 69 6e | 61 74 65 73 2e 06 00 41 |d termin|ates...A|
|00001e70| 43 43 45 50 54 02 00 c1 | 17 fe ff 06 00 41 43 43 |CCEPT...|.....ACC|
|00001e80| 45 50 54 02 00 c1 18 10 | 00 20 20 20 20 20 50 52 |EPT.....|. PR|
|00001e90| 4f 4d 50 54 20 74 65 78 | 74 06 00 41 43 43 45 50 |OMPT tex|t..ACCEP|
|00001ea0| 54 02 00 c1 19 47 00 20 | 20 20 20 20 20 20 20 20 |T....G. | |
|00001eb0| 64 69 73 70 6c 61 79 73 | 20 74 65 78 74 20 6f 6e |displays| text on|
|00001ec0| 2d 73 63 72 65 65 6e 20 | 62 65 66 6f 72 65 20 61 |-screen |before a|
|00001ed0| 63 63 65 70 74 69 6e 67 | 20 74 68 65 20 76 61 6c |ccepting| the val|
|00001ee0| 75 65 20 6f 66 20 76 61 | 72 69 61 62 6c 65 06 00 |ue of va|riable..|
|00001ef0| 41 43 43 45 50 54 02 00 | c1 1a 17 00 20 20 20 20 |ACCEPT..|.... |
|00001f00| 20 20 20 20 20 66 72 6f | 6d 20 74 68 65 20 75 73 | fro|m the us|
|00001f10| 65 72 2e 06 00 41 43 43 | 45 50 54 02 00 c1 1b fe |er...ACC|EPT.....|
|00001f20| ff 06 00 41 43 43 45 50 | 54 02 00 c1 1c 0f 00 20 |...ACCEP|T...... |
|00001f30| 20 20 20 20 4e 4f 50 52 | 5b 4f 4d 50 54 5d 06 00 | NOPR|[OMPT]..|
|00001f40| 41 43 43 45 50 54 02 00 | c1 1d 40 00 20 20 20 20 |ACCEPT..|..@. |
|00001f50| 20 20 20 20 20 73 6b 69 | 70 73 20 61 20 6c 69 6e | ski|ps a lin|
|00001f60| 65 20 61 6e 64 20 77 61 | 69 74 73 20 66 6f 72 20 |e and wa|its for |
|00001f70| 69 6e 70 75 74 3b 20 70 | 72 6f 6d 70 74 20 6e 6f |input; p|rompt no|
|00001f80| 74 20 64 69 73 70 6c 61 | 79 65 64 2e 06 00 41 43 |t displa|yed...AC|
|00001f90| 43 45 50 54 02 00 c1 1e | fe ff 06 00 41 43 43 45 |CEPT....|....ACCE|
|00001fa0| 50 54 02 00 c1 1f 09 00 | 20 20 20 20 20 48 49 44 |PT......| HID|
|00001fb0| 45 06 00 41 43 43 45 50 | 54 02 00 c1 20 36 00 20 |E..ACCEP|T... 6. |
|00001fc0| 20 20 20 20 20 20 20 20 | 73 75 70 70 72 65 73 73 | |suppress|
|00001fd0| 65 73 20 74 68 65 20 64 | 69 73 70 6c 61 79 20 61 |es the d|isplay a|
|00001fe0| 73 20 79 6f 75 20 74 79 | 70 65 20 74 68 65 20 72 |s you ty|pe the r|
|00001ff0| 65 70 6c 79 2e 06 00 41 | 43 43 45 50 54 02 00 c1 |eply...A|CCEPT...|
|00002000| 21 fe ff 06 00 41 43 43 | 45 50 54 02 00 c1 22 fe |!....ACC|EPT...".|
|00002010| ff 06 00 41 43 43 45 50 | 54 02 00 c1 23 49 00 20 |...ACCEP|T...#I. |
|00002020| 45 78 61 6d 70 6c 65 73 | 3a 20 54 6f 20 64 69 73 |Examples|: To dis|
|00002030| 70 6c 61 79 20 74 68 65 | 20 70 72 6f 6d 70 74 20 |play the| prompt |
|00002040| 74 65 78 74 20 22 53 61 | 6c 61 72 79 3a 20 22 20 |text "Sa|lary: " |
|00002050| 61 6e 64 20 70 6c 61 63 | 65 20 74 68 65 20 72 65 |and plac|e the re|
|00002060| 70 6c 79 20 69 6e 20 61 | 06 00 41 43 43 45 50 54 |ply in a|..ACCEPT|
|00002070| 02 00 c1 24 2f 00 20 20 | 20 20 20 20 20 20 20 20 |...$/. | |
|00002080| 20 4e 55 4d 42 45 52 20 | 76 61 72 69 61 62 6c 65 | NUMBER |variable|
|00002090| 20 6e 61 6d 65 64 20 53 | 41 4c 41 52 59 2c 20 65 | named S|ALARY, e|
|000020a0| 6e 74 65 72 3a 06 00 41 | 43 43 45 50 54 02 00 c1 |nter:..A|CCEPT...|
|000020b0| 25 fe ff 06 00 41 43 43 | 45 50 54 02 00 c1 26 3a |%....ACC|EPT...&:|
|000020c0| 00 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |. | |
|000020d0| 53 51 4c 3e 20 41 43 43 | 45 50 54 20 73 61 6c 61 |SQL> ACC|EPT sala|
|000020e0| 72 79 20 4e 55 4d 42 45 | 52 20 50 52 4f 4d 50 54 |ry NUMBE|R PROMPT|
|000020f0| 20 27 53 61 6c 61 72 79 | 3a 20 27 06 00 41 43 43 | 'Salary|: '..ACC|
|00002100| 45 50 54 02 00 c1 27 fe | ff 06 00 41 43 43 45 50 |EPT...'.|...ACCEP|
|00002110| 54 02 00 c1 28 fe ff 06 | 00 41 43 43 45 50 54 02 |T...(...|.ACCEPT.|
|00002120| 00 c1 29 49 00 20 20 20 | 20 20 20 20 20 20 20 20 |..)I. | |
|00002130| 54 6f 20 64 69 73 70 6c | 61 79 20 74 68 65 20 70 |To displ|ay the p|
|00002140| 72 6f 6d 70 74 20 22 50 | 61 73 73 77 6f 72 64 3a |rompt "P|assword:|
|00002150| 20 22 2c 20 61 6e 64 20 | 70 6c 61 63 65 20 74 68 | ", and |place th|
|00002160| 65 20 72 65 70 6c 79 20 | 69 6e 20 74 68 65 06 00 |e reply |in the..|
|00002170| 41 43 43 45 50 54 02 00 | c1 2a 44 00 20 20 20 20 |ACCEPT..|.*D. |
|00002180| 20 20 20 20 20 20 20 43 | 48 41 52 20 76 61 72 69 | C|HAR vari|
|00002190| 61 62 6c 65 20 50 53 57 | 44 2c 20 77 68 69 6c 65 |able PSW|D, while|
|000021a0| 20 73 75 70 70 72 65 73 | 73 69 6e 67 20 74 68 65 | suppres|sing the|
|000021b0| 20 64 69 73 70 6c 61 79 | 2c 20 65 6e 74 65 72 3a | display|, enter:|
|000021c0| 06 00 41 43 43 45 50 54 | 02 00 c1 2b fe ff 06 00 |..ACCEPT|...+....|
|000021d0| 41 43 43 45 50 54 02 00 | c1 2c 3d 00 20 20 20 20 |ACCEPT..|.,=. |
|000021e0| 20 20 20 20 20 20 20 20 | 20 20 20 53 51 4c 3e 20 | | SQL> |
|000021f0| 41 43 43 45 50 54 20 70 | 73 77 64 20 43 48 41 52 |ACCEPT p|swd CHAR|
|00002200| 20 50 52 4f 4d 50 54 20 | 27 50 61 73 73 77 6f 72 | PROMPT |'Passwor|
|00002210| 64 3a 20 27 20 48 49 44 | 45 06 00 41 43 43 45 50 |d: ' HID|E..ACCEP|
|00002220| 54 02 00 c1 2d fe ff 06 | 00 41 43 43 45 50 54 02 |T...-...|.ACCEPT.|
|00002230| 00 c1 2e fe ff 06 00 41 | 43 43 45 50 54 02 00 c1 |.......A|CCEPT...|
|00002240| 2f 3d 00 20 53 65 65 20 | 61 6c 73 6f 3a 20 64 65 |/=. See |also: de|
|00002250| 66 69 6e 65 2c 20 69 6e | 70 75 74 2c 20 70 72 6f |fine, in|put, pro|
|00002260| 6d 70 74 2c 20 70 61 72 | 61 6d 65 74 65 72 73 2c |mpt, par|ameters,|
|00002270| 20 63 6f 6d 6d 61 6e 64 | 73 2c 20 6d 65 6e 75 2e | command|s, menu.|
|00002280| 0d 00 41 4c 54 45 52 20 | 43 4c 55 53 54 45 52 02 |..ALTER |CLUSTER.|
|00002290| 00 c1 02 fe ff 0d 00 41 | 4c 54 45 52 20 43 4c 55 |.......A|LTER CLU|
|000022a0| 53 54 45 52 02 00 c1 03 | fe ff 0d 00 41 4c 54 45 |STER....|....ALTE|
|000022b0| 52 20 43 4c 55 53 54 45 | 52 02 00 c1 04 2d 00 20 |R CLUSTE|R....-. |
|000022c0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|000022d0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 41 | | A|
|000022e0| 4c 54 45 52 20 43 4c 55 | 53 54 45 52 0d 00 41 4c |LTER CLU|STER..AL|
|000022f0| 54 45 52 20 43 4c 55 53 | 54 45 52 02 00 c1 05 49 |TER CLUS|TER....I|
|00002300| 00 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |. | |
|00002310| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00002320| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00002330| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 53 51 4c | | SQL|
|00002340| 20 73 74 61 74 65 6d 65 | 6e 74 0d 00 41 4c 54 45 | stateme|nt..ALTE|
|00002350| 52 20 43 4c 55 53 54 45 | 52 02 00 c1 06 fe ff 0d |R CLUSTE|R.......|
|00002360| 00 41 4c 54 45 52 20 43 | 4c 55 53 54 45 52 02 00 |.ALTER C|LUSTER..|
|00002370| c1 07 43 00 20 41 4c 54 | 45 52 20 43 4c 55 53 54 |..C. ALT|ER CLUST|
|00002380| 45 52 20 75 73 65 72 2e | 63 6c 75 73 74 65 72 20 |ER user.|cluster |
|00002390| 20 20 20 20 20 2d 2d 75 | 73 65 72 2e 20 61 6e 64 | --u|ser. and|
|000023a0| 20 63 6c 61 75 73 65 73 | 20 62 65 6c 6f 77 20 6f | clauses| below o|
|000023b0| 70 74 69 6f 6e 61 6c 0d | 00 41 4c 54 45 52 20 43 |ptional.|.ALTER C|
|000023c0| 4c 55 53 54 45 52 02 00 | c1 08 49 00 20 20 20 20 |LUSTER..|..I. |
|000023d0| 50 43 54 55 53 45 44 20 | 69 6e 74 65 67 65 72 20 |PCTUSED |integer |
|000023e0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 2d 2d 6d | | --m|
|000023f0| 69 6e 20 73 70 61 63 65 | 20 75 73 65 20 70 65 72 |in space| use per|
|00002400| 20 62 6c 6f 63 6b 3b 20 | 64 65 66 61 75 6c 74 20 | block; |default |
|00002410| 69 73 20 34 30 0d 00 41 | 4c 54 45 52 20 43 4c 55 |is 40..A|LTER CLU|
|00002420| 53 54 45 52 02 00 c1 09 | 48 00 20 20 20 20 50 43 |STER....|H. PC|
|00002430| 54 46 52 45 45 20 69 6e | 74 65 67 65 72 20 20 20 |TFREE in|teger |
|00002440| 20 20 20 20 20 20 20 20 | 20 20 20 2d 2d 25 20 6f | | --% o|
|00002450| 66 20 62 6c 6f 63 6b 20 | 66 6f 72 20 75 70 64 61 |f block |for upda|
|00002460| 74 65 73 3b 20 64 65 66 | 61 75 6c 74 20 69 73 20 |tes; def|ault is |
|00002470| 31 30 0d 00 41 4c 54 45 | 52 20 43 4c 55 53 54 45 |10..ALTE|R CLUSTE|
|00002480| 52 02 00 c1 0a 44 00 20 | 20 20 20 53 49 5a 45 20 |R....D. | SIZE |
|00002490| 69 6e 74 65 67 65 72 20 | 20 20 20 20 20 20 20 20 |integer | |
|000024a0| 20 20 20 20 20 20 20 20 | 2d 2d 74 68 65 20 6e 75 | |--the nu|
|000024b0| 6d 62 65 72 20 6f 66 20 | 63 6c 75 73 74 65 72 20 |mber of |cluster |
|000024c0| 6b 65 79 73 20 73 74 6f | 72 65 64 0d 00 41 4c 54 |keys sto|red..ALT|
|000024d0| 45 52 20 43 4c 55 53 54 | 45 52 02 00 c1 0b 49 00 |ER CLUST|ER....I.|
|000024e0| 20 20 20 20 49 4e 49 54 | 52 41 4e 53 20 69 6e 74 | INIT|RANS int|
|000024f0| 65 67 65 72 20 20 20 20 | 20 20 20 20 20 20 20 20 |eger | |
|00002500| 20 2d 2d 69 6e 69 74 69 | 61 6c 20 6e 75 6d 62 65 | --initi|al numbe|
|00002510| 72 20 6f 66 20 74 72 61 | 6e 73 61 63 74 69 6f 6e |r of tra|nsaction|
|00002520| 73 20 65 6e 74 72 69 65 | 73 0d 00 41 4c 54 45 52 |s entrie|s..ALTER|
|00002530| 20 43 4c 55 53 54 45 52 | 02 00 c1 0c 49 00 20 20 | CLUSTER|....I. |
|00002540| 20 20 4d 41 58 54 52 41 | 4e 53 20 69 6e 74 65 67 | MAXTRA|NS integ|
|00002550| 65 72 20 20 20 20 20 20 | 20 20 20 20 20 20 20 2d |er | -|
|00002560| 2d 6d 61 78 69 6d 75 6d | 20 6e 75 6d 62 65 72 20 |-maximum| number |
|00002570| 6f 66 20 74 72 61 6e 73 | 61 63 74 69 6f 6e 73 20 |of trans|actions |
|00002580| 61 74 20 6f 6e 63 65 0d | 00 41 4c 54 45 52 20 43 |at once.|.ALTER C|
|00002590| 4c 55 53 54 45 52 02 00 | c1 0d 3c 00 20 20 20 20 |LUSTER..|..<. |
|000025a0| 53 54 4f 52 41 47 45 20 | 63 6c 61 75 73 65 20 20 |STORAGE |clause |
|000025b0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 2d 2d 63 | | --c|
|000025c0| 6f 6e 74 72 6f 6c 73 20 | 73 70 61 63 65 20 61 6c |ontrols |space al|
|000025d0| 6c 6f 63 61 74 69 6f 6e | 0d 00 41 4c 54 45 52 20 |location|..ALTER |
|000025e0| 43 4c 55 53 54 45 52 02 | 00 c1 0e fe ff 0d 00 41 |CLUSTER.|.......A|
|000025f0| 4c 54 45 52 20 43 4c 55 | 53 54 45 52 02 00 c1 0f |LTER CLU|STER....|
|00002600| fe ff 0d 00 41 4c 54 45 | 52 20 43 4c 55 53 54 45 |....ALTE|R CLUSTE|
|00002610| 52 02 00 c1 10 49 00 20 | 41 4c 54 45 52 20 43 4c |R....I. |ALTER CL|
|00002620| 55 53 54 45 52 20 72 65 | 64 65 66 69 6e 65 73 20 |USTER re|defines |
|00002630| 61 20 63 6c 75 73 74 65 | 72 27 73 20 66 75 74 75 |a cluste|r's futu|
|00002640| 72 65 20 73 74 6f 72 61 | 67 65 20 61 6c 6c 6f 63 |re stora|ge alloc|
|00002650| 61 74 69 6f 6e 73 2e 20 | 20 59 6f 75 20 63 61 6e |ations. | You can|
|00002660| 0d 00 41 4c 54 45 52 20 | 43 4c 55 53 54 45 52 02 |..ALTER |CLUSTER.|
|00002670| 00 c1 11 35 00 20 63 68 | 61 6e 67 65 20 61 6e 79 |...5. ch|ange any|
|00002680| 20 6f 66 20 74 68 65 20 | 70 61 72 61 6d 65 74 65 | of the |paramete|
|00002690| 72 73 20 6c 69 73 74 65 | 64 2c 20 62 75 74 20 79 |rs liste|d, but y|
|000026a0| 6f 75 20 63 61 6e 6e 6f | 74 3a 0d 00 41 4c 54 45 |ou canno|t:..ALTE|
|000026b0| 52 20 43 4c 55 53 54 45 | 52 02 00 c1 12 fe ff 0d |R CLUSTE|R.......|
|000026c0| 00 41 4c 54 45 52 20 43 | 4c 55 53 54 45 52 02 00 |.ALTER C|LUSTER..|
|000026d0| c1 13 3c 00 20 20 20 20 | 2d 20 20 63 68 61 6e 67 |..<. |- chang|
|000026e0| 65 20 74 68 65 20 6e 75 | 6d 62 65 72 20 6f 72 20 |e the nu|mber or |
|000026f0| 6e 61 6d 65 20 6f 66 20 | 63 6f 6c 75 6d 6e 73 20 |name of |columns |
|00002700| 69 6e 20 61 20 63 6c 75 | 73 74 65 72 20 6b 65 79 |in a clu|ster key|
|00002710| 0d 00 41 4c 54 45 52 20 | 43 4c 55 53 54 45 52 02 |..ALTER |CLUSTER.|
|00002720| 00 c1 14 25 00 20 20 20 | 20 2d 20 20 61 6c 74 65 |...%. | - alte|
|00002730| 72 20 74 68 65 20 4d 49 | 4e 45 58 54 45 4e 54 53 |r the MI|NEXTENTS|
|00002740| 20 70 61 72 61 6d 65 74 | 65 72 0d 00 41 4c 54 45 | paramet|er..ALTE|
|00002750| 52 20 43 4c 55 53 54 45 | 52 02 00 c1 15 3e 00 20 |R CLUSTE|R....>. |
|00002760| 20 20 20 2d 20 20 61 6c | 74 65 72 20 61 6e 79 20 | - al|ter any |
|00002770| 70 61 72 61 6d 65 74 65 | 72 73 20 61 66 66 65 63 |paramete|rs affec|
|00002780| 74 69 6e 67 20 62 6c 6f | 63 6b 73 20 61 6c 72 65 |ting blo|cks alre|
|00002790| 61 64 79 20 61 6c 6c 6f | 63 61 74 65 64 0d 00 41 |ady allo|cated..A|
|000027a0| 4c 54 45 52 20 43 4c 55 | 53 54 45 52 02 00 c1 16 |LTER CLU|STER....|
|000027b0| 45 00 20 20 20 20 2d 20 | 20 72 65 6d 6f 76 65 20 |E. - | remove |
|000027c0| 74 61 62 6c 65 73 20 66 | 72 6f 6d 20 61 20 63 6c |tables f|rom a cl|
|000027d0| 75 73 74 65 72 20 28 75 | 73 65 20 44 52 4f 50 20 |uster (u|se DROP |
|000027e0| 43 4c 55 53 54 45 52 20 | 61 6e 64 20 44 52 4f 50 |CLUSTER |and DROP|
|000027f0| 20 54 41 42 4c 45 29 0d | 00 41 4c 54 45 52 20 43 | TABLE).|.ALTER C|
|00002800| 4c 55 53 54 45 52 02 00 | c1 17 23 00 20 20 20 20 |LUSTER..|..#. |
|00002810| 2d 20 20 61 6c 74 65 72 | 20 61 20 63 6c 75 73 74 |- alter| a clust|
|00002820| 65 72 27 73 20 74 61 62 | 6c 65 73 70 61 63 65 0d |er's tab|lespace.|
|00002830| 00 41 4c 54 45 52 20 43 | 4c 55 53 54 45 52 02 00 |.ALTER C|LUSTER..|
|00002840| c1 18 fe ff 0d 00 41 4c | 54 45 52 20 43 4c 55 53 |......AL|TER CLUS|
|00002850| 54 45 52 02 00 c1 19 38 | 00 20 53 65 65 20 61 6c |TER....8|. See al|
|00002860| 73 6f 3a 20 63 72 65 61 | 74 65 20 63 6c 75 73 74 |so: crea|te clust|
|00002870| 65 72 2c 20 63 72 65 61 | 74 65 20 74 61 62 6c 65 |er, crea|te table|
|00002880| 2c 20 63 6f 6d 6d 61 6e | 64 73 2c 20 6d 65 6e 75 |, comman|ds, menu|
|00002890| 2e 0e 00 41 4c 54 45 52 | 20 44 41 54 41 42 41 53 |...ALTER| DATABAS|
|000028a0| 45 02 00 c1 02 fe ff 0e | 00 41 4c 54 45 52 20 44 |E.......|.ALTER D|
|000028b0| 41 54 41 42 41 53 45 02 | 00 c1 03 fe ff 0e 00 41 |ATABASE.|.......A|
|000028c0| 4c 54 45 52 20 44 41 54 | 41 42 41 53 45 02 00 c1 |LTER DAT|ABASE...|
|000028d0| 04 2e 00 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |... | |
|000028e0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|000028f0| 20 20 20 41 4c 54 45 52 | 20 44 41 54 41 42 41 53 | ALTER| DATABAS|
|00002900| 45 0e 00 41 4c 54 45 52 | 20 44 41 54 41 42 41 53 |E..ALTER| DATABAS|
|00002910| 45 02 00 c1 05 45 00 20 | 20 20 20 20 20 20 20 20 |E....E. | |
|00002920| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00002930| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00002940| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 53 | | S|
|00002950| 51 4c 20 73 74 61 74 65 | 6d 65 6e 74 0e 00 41 4c |QL state|ment..AL|
|00002960| 54 45 52 20 44 41 54 41 | 42 41 53 45 02 00 c1 06 |TER DATA|BASE....|
|00002970| 18 00 20 41 4c 54 45 52 | 20 44 41 54 41 42 41 53 |.. ALTER| DATABAS|
|00002980| 45 20 64 61 74 61 62 61 | 73 65 0e 00 41 4c 54 45 |E databa|se..ALTE|
|00002990| 52 20 44 41 54 41 42 41 | 53 45 02 00 c1 07 37 00 |R DATABA|SE....7.|
|000029a0| 20 20 20 20 41 44 44 20 | 4c 4f 47 46 49 4c 45 20 | ADD |LOGFILE |
|000029b0| 27 66 69 6c 65 6e 61 6d | 65 27 20 53 49 5a 45 20 |'filenam|e' SIZE |
|000029c0| 69 6e 74 65 67 65 72 20 | 4b 20 7c 20 4d 20 52 45 |integer |K | M RE|
|000029d0| 55 53 45 2c 2e 2e 2e 0e | 00 41 4c 54 45 52 20 44 |USE,....|.ALTER D|
|000029e0| 41 54 41 42 41 53 45 02 | 00 c1 08 2b 00 20 20 20 |ATABASE.|...+. |
|000029f0| 20 44 52 4f 50 20 4c 4f | 47 46 49 4c 45 20 27 66 | DROP LO|GFILE 'f|
|00002a00| 69 6c 65 6e 61 6d 65 27 | 2c 20 27 66 69 6c 65 6e |ilename'|, 'filen|
|00002a10| 61 6d 65 27 2c 2e 2e 2e | 0e 00 41 4c 54 45 52 20 |ame',...|..ALTER |
|00002a20| 44 41 54 41 42 41 53 45 | 02 00 c1 09 2a 00 20 20 |DATABASE|....*. |
|00002a30| 20 20 52 45 4e 41 4d 45 | 20 46 49 4c 45 20 27 66 | RENAME| FILE 'f|
|00002a40| 69 6c 65 6e 61 6d 65 27 | 2c 20 27 66 69 6c 65 6e |ilename'|, 'filen|
|00002a50| 61 6d 65 27 2c 2e 2e 2e | 0e 00 41 4c 54 45 52 20 |ame',...|..ALTER |
|00002a60| 44 41 54 41 42 41 53 45 | 02 00 c1 0a 2a 00 20 20 |DATABASE|....*. |
|00002a70| 20 20 20 20 20 20 20 20 | 20 20 20 54 4f 20 27 66 | | TO 'f|
|00002a80| 69 6c 65 6e 61 6d 65 27 | 2c 20 27 66 69 6c 65 6e |ilename'|, 'filen|
|00002a90| 61 6d 65 27 2c 2e 2e 2e | 0e 00 41 4c 54 45 52 20 |ame',...|..ALTER |
|00002aa0| 44 41 54 41 42 41 53 45 | 02 00 c1 0b 1d 00 20 20 |DATABASE|...... |
|00002ab0| 20 20 41 52 43 48 49 56 | 45 4c 4f 47 20 7c 20 4e | ARCHIV|ELOG | N|
|00002ac0| 4f 41 52 43 48 49 56 45 | 4c 4f 47 0e 00 41 4c 54 |OARCHIVE|LOG..ALT|
|00002ad0| 45 52 20 44 41 54 41 42 | 41 53 45 02 00 c1 0c 1c |ER DATAB|ASE.....|
|00002ae0| 00 20 20 20 20 4d 4f 55 | 4e 54 20 53 48 41 52 45 |. MOU|NT SHARE|
|00002af0| 44 20 7c 20 45 58 43 4c | 55 53 49 56 45 0e 00 41 |D | EXCL|USIVE..A|
|00002b00| 4c 54 45 52 20 44 41 54 | 41 42 41 53 45 02 00 c1 |LTER DAT|ABASE...|
|00002b10| 0d 0c 00 20 20 20 20 44 | 49 53 4d 4f 55 4e 54 0e |... D|ISMOUNT.|
|00002b20| 00 41 4c 54 45 52 20 44 | 41 54 41 42 41 53 45 02 |.ALTER D|ATABASE.|
|00002b30| 00 c1 0e 23 00 20 20 20 | 20 4f 50 45 4e 20 7c 20 |...#. | OPEN | |
|00002b40| 43 4c 4f 53 45 20 4e 4f | 52 4d 41 4c 20 7c 20 49 |CLOSE NO|RMAL | I|
|00002b50| 4d 4d 45 44 49 41 54 45 | 0e 00 41 4c 54 45 52 20 |MMEDIATE|..ALTER |
|00002b60| 44 41 54 41 42 41 53 45 | 02 00 c1 0f fe ff 0e 00 |DATABASE|........|
|00002b70| 41 4c 54 45 52 20 44 41 | 54 41 42 41 53 45 02 00 |ALTER DA|TABASE..|
|00002b80| c1 10 44 00 20 55 73 65 | 20 74 68 65 20 41 4c 54 |..D. Use| the ALT|
|00002b90| 45 52 20 44 41 54 41 42 | 41 53 45 20 73 74 61 74 |ER DATAB|ASE stat|
|00002ba0| 65 6d 65 6e 74 20 74 6f | 20 6d 6f 75 6e 74 20 61 |ement to| mount a|
|00002bb0| 20 64 61 74 61 62 61 73 | 65 2c 20 65 69 74 68 65 | databas|e, eithe|
|00002bc0| 72 20 73 68 61 72 65 64 | 0e 00 41 4c 54 45 52 20 |r shared|..ALTER |
|00002bd0| 44 41 54 41 42 41 53 45 | 02 00 c1 11 44 00 20 6f |DATABASE|....D. o|
|00002be0| 72 20 65 78 63 6c 75 73 | 69 76 65 3b 20 6f 70 65 |r exclus|ive; ope|
|00002bf0| 6e 20 6f 72 20 63 6c 6f | 73 65 20 61 20 64 61 74 |n or clo|se a dat|
|00002c00| 61 62 61 73 65 3b 20 61 | 64 64 2c 20 64 72 6f 70 |abase; a|dd, drop|
|00002c10| 2c 20 6f 72 20 72 65 6e | 61 6d 65 20 61 20 72 65 |, or ren|ame a re|
|00002c20| 64 6f 0e 00 41 4c 54 45 | 52 20 44 41 54 41 42 41 |do..ALTE|R DATABA|
|00002c30| 53 45 02 00 c1 12 44 00 | 20 6c 6f 67 20 66 69 6c |SE....D.| log fil|
|00002c40| 65 3b 20 6f 72 20 72 65 | 6e 61 6d 65 20 61 20 64 |e; or re|name a d|
|00002c50| 61 74 61 62 61 73 65 20 | 66 69 6c 65 2e 20 20 59 |atabase |file. Y|
|00002c60| 6f 75 20 63 61 6e 20 61 | 6c 73 6f 20 73 65 74 20 |ou can a|lso set |
|00002c70| 74 68 65 20 72 65 64 6f | 20 6c 6f 67 0e 00 41 4c |the redo| log..AL|
|00002c80| 54 45 52 20 44 41 54 41 | 42 41 53 45 02 00 c1 13 |TER DATA|BASE....|
|00002c90| 44 00 20 74 6f 20 62 65 | 20 61 72 63 68 69 76 65 |D. to be| archive|
|00002ca0| 64 20 28 75 73 65 66 75 | 6c 20 66 6f 72 20 6d 65 |d (usefu|l for me|
|00002cb0| 64 69 61 20 72 65 63 6f | 76 65 72 79 29 2c 20 6f |dia reco|very), o|
|00002cc0| 72 20 6e 6f 74 20 61 72 | 63 68 69 76 65 64 20 28 |r not ar|chived (|
|00002cd0| 75 73 65 66 75 6c 0e 00 | 41 4c 54 45 52 20 44 41 |useful..|ALTER DA|
|00002ce0| 54 41 42 41 53 45 02 00 | c1 14 44 00 20 6f 6e 6c |TABASE..|..D. onl|
|00002cf0| 79 20 66 6f 72 20 69 6e | 73 74 61 6e 63 65 20 72 |y for in|stance r|
|00002d00| 65 63 6f 76 65 72 79 29 | 2e 20 20 49 66 20 64 61 |ecovery)|. If da|
|00002d10| 74 61 62 61 73 65 20 69 | 73 20 6f 6d 69 74 74 65 |tabase i|s omitte|
|00002d20| 64 2c 20 74 68 65 20 76 | 61 6c 75 65 20 66 6f 72 |d, the v|alue for|
|00002d30| 0e 00 41 4c 54 45 52 20 | 44 41 54 41 42 41 53 45 |..ALTER |DATABASE|
|00002d40| 02 00 c1 15 31 00 20 44 | 42 5f 4e 41 4d 45 20 69 |....1. D|B_NAME i|
|00002d50| 6e 20 74 68 65 20 63 75 | 72 72 65 6e 74 20 49 4e |n the cu|rrent IN|
|00002d60| 49 54 2e 4f 52 41 20 66 | 69 6c 65 20 69 73 20 61 |IT.ORA f|ile is a|
|00002d70| 73 73 75 6d 65 64 2e 0e | 00 41 4c 54 45 52 20 44 |ssumed..|.ALTER D|
|00002d80| 41 54 41 42 41 53 45 02 | 00 c1 16 fe ff 0e 00 41 |ATABASE.|.......A|
|00002d90| 4c 54 45 52 20 44 41 54 | 41 42 41 53 45 02 00 c1 |LTER DAT|ABASE...|
|00002da0| 17 fe ff 0e 00 41 4c 54 | 45 52 20 44 41 54 41 42 |.....ALT|ER DATAB|
|00002db0| 41 53 45 02 00 c1 18 2b | 00 20 53 65 65 20 61 6c |ASE....+|. See al|
|00002dc0| 73 6f 3a 20 63 72 65 61 | 74 65 20 64 61 74 61 62 |so: crea|te datab|
|00002dd0| 61 73 65 2c 20 63 6f 6d | 6d 61 6e 64 73 2c 20 6d |ase, com|mands, m|
|00002de0| 65 6e 75 2e 0b 00 41 4c | 54 45 52 20 49 4e 44 45 |enu...AL|TER INDE|
|00002df0| 58 02 00 c1 02 fe ff 0b | 00 41 4c 54 45 52 20 49 |X.......|.ALTER I|
|00002e00| 4e 44 45 58 02 00 c1 03 | fe ff 0b 00 41 4c 54 45 |NDEX....|....ALTE|
|00002e10| 52 20 49 4e 44 45 58 02 | 00 c1 04 2c 00 20 20 20 |R INDEX.|...,. |
|00002e20| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00002e30| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 41 4c | | AL|
|00002e40| 54 45 52 20 49 4e 44 45 | 58 0b 00 41 4c 54 45 52 |TER INDE|X..ALTER|
|00002e50| 20 49 4e 44 45 58 02 00 | c1 05 47 00 20 20 20 20 | INDEX..|..G. |
|00002e60| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00002e70| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00002e80| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00002e90| 20 20 20 20 20 20 53 51 | 4c 20 73 74 61 74 65 6d | SQ|L statem|
|00002ea0| 65 6e 74 0b 00 41 4c 54 | 45 52 20 49 4e 44 45 58 |ent..ALT|ER INDEX|
|00002eb0| 02 00 c1 06 17 00 20 41 | 4c 54 45 52 20 49 4e 44 |...... A|LTER IND|
|00002ec0| 45 58 20 75 73 65 72 2e | 69 6e 64 65 78 0b 00 41 |EX user.|index..A|
|00002ed0| 4c 54 45 52 20 49 4e 44 | 45 58 02 00 c1 07 14 00 |LTER IND|EX......|
|00002ee0| 20 20 20 20 49 4e 49 54 | 52 41 4e 53 20 69 6e 74 | INIT|RANS int|
|00002ef0| 65 67 65 72 0b 00 41 4c | 54 45 52 20 49 4e 44 45 |eger..AL|TER INDE|
|00002f00| 58 02 00 c1 08 14 00 20 | 20 20 20 4d 41 58 54 52 |X...... | MAXTR|
|00002f10| 41 4e 53 20 69 6e 74 65 | 67 65 72 0b 00 41 4c 54 |ANS inte|ger..ALT|
|00002f20| 45 52 20 49 4e 44 45 58 | 02 00 c1 09 12 00 20 20 |ER INDEX|...... |
|00002f30| 20 20 53 54 4f 52 41 47 | 45 20 63 6c 61 75 73 65 | STORAG|E clause|
|00002f40| 0b 00 41 4c 54 45 52 20 | 49 4e 44 45 58 02 00 c1 |..ALTER |INDEX...|
|00002f50| 0a fe ff 0b 00 41 4c 54 | 45 52 20 49 4e 44 45 58 |.....ALT|ER INDEX|
|00002f60| 02 00 c1 0b 47 00 20 55 | 73 65 20 74 68 65 20 41 |....G. U|se the A|
|00002f70| 4c 54 45 52 20 49 4e 44 | 45 58 20 73 74 61 74 65 |LTER IND|EX state|
|00002f80| 6d 65 6e 74 20 74 6f 20 | 63 68 61 6e 67 65 20 66 |ment to |change f|
|00002f90| 75 74 75 72 65 20 73 74 | 6f 72 61 67 65 20 61 6c |uture st|orage al|
|00002fa0| 6c 6f 63 61 74 69 6f 6e | 73 20 66 6f 72 0b 00 41 |location|s for..A|
|00002fb0| 4c 54 45 52 20 49 4e 44 | 45 58 02 00 c1 0c 46 00 |LTER IND|EX....F.|
|00002fc0| 20 69 6e 64 65 78 20 62 | 6c 6f 63 6b 73 2e 20 20 | index b|locks. |
|00002fd0| 49 4e 49 54 52 41 4e 53 | 2c 20 4d 41 58 54 52 41 |INITRANS|, MAXTRA|
|00002fe0| 4e 53 2c 20 61 6e 64 20 | 53 54 4f 52 41 47 45 20 |NS, and |STORAGE |
|00002ff0| 77 6f 72 6b 20 74 68 65 | 20 73 61 6d 65 20 77 61 |work the| same wa|
|00003000| 79 20 74 68 65 79 0b 00 | 41 4c 54 45 52 20 49 4e |y they..|ALTER IN|
|00003010| 44 45 58 02 00 c1 0d 22 | 00 20 64 6f 20 69 6e 20 |DEX...."|. do in |
|00003020| 74 68 65 20 43 52 45 41 | 54 45 20 54 41 42 4c 45 |the CREA|TE TABLE|
|00003030| 20 73 74 61 74 65 6d 65 | 6e 74 2e 0b 00 41 4c 54 | stateme|nt...ALT|
|00003040| 45 52 20 49 4e 44 45 58 | 02 00 c1 0e fe ff 0b 00 |ER INDEX|........|
|00003050| 41 4c 54 45 52 20 49 4e | 44 45 58 02 00 c1 0f fe |ALTER IN|DEX.....|
|00003060| ff 0b 00 41 4c 54 45 52 | 20 49 4e 44 45 58 02 00 |...ALTER| INDEX..|
|00003070| c1 10 36 00 20 53 65 65 | 20 61 6c 73 6f 3a 20 63 |..6. See| also: c|
|00003080| 72 65 61 74 65 20 69 6e | 64 65 78 2c 20 63 72 65 |reate in|dex, cre|
|00003090| 61 74 65 20 74 61 62 6c | 65 2c 20 63 6f 6d 6d 61 |ate tabl|e, comma|
|000030a0| 6e 64 73 2c 20 6d 65 6e | 75 2e 16 00 41 4c 54 45 |nds, men|u...ALTE|
|000030b0| 52 20 52 4f 4c 4c 42 41 | 43 4b 20 53 45 47 4d 45 |R ROLLBA|CK SEGME|
|000030c0| 4e 54 02 00 c1 02 fe ff | 16 00 41 4c 54 45 52 20 |NT......|..ALTER |
|000030d0| 52 4f 4c 4c 42 41 43 4b | 20 53 45 47 4d 45 4e 54 |ROLLBACK| SEGMENT|
|000030e0| 02 00 c1 03 fe ff 16 00 | 41 4c 54 45 52 20 52 4f |........|ALTER RO|
|000030f0| 4c 4c 42 41 43 4b 20 53 | 45 47 4d 45 4e 54 02 00 |LLBACK S|EGMENT..|
|00003100| c1 04 33 00 20 20 20 20 | 20 20 20 20 20 20 20 20 |..3. | |
|00003110| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00003120| 20 41 4c 54 45 52 20 52 | 4f 4c 4c 42 41 43 4b 20 | ALTER R|OLLBACK |
|00003130| 53 45 47 4d 45 4e 54 16 | 00 41 4c 54 45 52 20 52 |SEGMENT.|.ALTER R|
|00003140| 4f 4c 4c 42 41 43 4b 20 | 53 45 47 4d 45 4e 54 02 |OLLBACK |SEGMENT.|
|00003150| 00 c1 05 49 00 20 20 20 | 20 20 20 20 20 20 20 20 |...I. | |
|00003160| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00003170| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00003180| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00003190| 20 53 51 4c 20 73 74 61 | 74 65 6d 65 6e 74 16 00 | SQL sta|tement..|
|000031a0| 41 4c 54 45 52 20 52 4f | 4c 4c 42 41 43 4b 20 53 |ALTER RO|LLBACK S|
|000031b0| 45 47 4d 45 4e 54 02 00 | c1 06 26 00 20 41 4c 54 |EGMENT..|..&. ALT|
|000031c0| 45 52 20 50 55 42 4c 49 | 43 20 52 4f 4c 4c 42 41 |ER PUBLI|C ROLLBA|
|000031d0| 43 4b 20 53 45 47 4d 45 | 4e 54 20 73 65 67 6d 65 |CK SEGME|NT segme|
|000031e0| 6e 74 16 00 41 4c 54 45 | 52 20 52 4f 4c 4c 42 41 |nt..ALTE|R ROLLBA|
|000031f0| 43 4b 20 53 45 47 4d 45 | 4e 54 02 00 c1 07 11 00 |CK SEGME|NT......|
|00003200| 20 20 20 53 54 4f 52 41 | 47 45 20 63 6c 61 75 73 | STORA|GE claus|
|00003210| 65 16 00 41 4c 54 45 52 | 20 52 4f 4c 4c 42 41 43 |e..ALTER| ROLLBAC|
|00003220| 4b 20 53 45 47 4d 45 4e | 54 02 00 c1 08 fe ff 16 |K SEGMEN|T.......|
|00003230| 00 41 4c 54 45 52 20 52 | 4f 4c 4c 42 41 43 4b 20 |.ALTER R|OLLBACK |
|00003240| 53 45 47 4d 45 4e 54 02 | 00 c1 09 fe ff 16 00 41 |SEGMENT.|.......A|
|00003250| 4c 54 45 52 20 52 4f 4c | 4c 42 41 43 4b 20 53 45 |LTER ROL|LBACK SE|
|00003260| 47 4d 45 4e 54 02 00 c1 | 0a 4a 00 20 55 73 65 20 |GMENT...|.J. Use |
|00003270| 41 4c 54 45 52 20 52 4f | 4c 4c 42 41 43 4b 20 53 |ALTER RO|LLBACK S|
|00003280| 45 47 4d 45 4e 54 20 74 | 6f 20 6d 61 6b 65 20 61 |EGMENT t|o make a|
|00003290| 20 72 6f 6c 6c 62 61 63 | 6b 20 73 65 67 6d 65 6e | rollbac|k segmen|
|000032a0| 74 20 70 75 62 6c 69 63 | 20 6f 72 20 61 6c 74 65 |t public| or alte|
|000032b0| 72 20 69 74 73 16 00 41 | 4c 54 45 52 20 52 4f 4c |r its..A|LTER ROL|
|000032c0| 4c 42 41 43 4b 20 53 45 | 47 4d 45 4e 54 02 00 c1 |LBACK SE|GMENT...|
|000032d0| 0b 49 00 20 73 74 6f 72 | 61 67 65 20 70 61 72 61 |.I. stor|age para|
|000032e0| 6d 65 74 65 72 73 2e 20 | 20 55 73 65 20 50 55 42 |meters. | Use PUB|
|000032f0| 4c 49 43 20 74 6f 20 6d | 61 6b 65 20 61 20 72 6f |LIC to m|ake a ro|
|00003300| 6c 6c 62 61 63 6b 20 73 | 65 67 6d 65 6e 74 20 61 |llback s|egment a|
|00003310| 76 61 69 6c 61 62 6c 65 | 20 66 6f 72 16 00 41 4c |vailable| for..AL|
|00003320| 54 45 52 20 52 4f 4c 4c | 42 41 43 4b 20 53 45 47 |TER ROLL|BACK SEG|
|00003330| 4d 45 4e 54 02 00 c1 0c | 4a 00 20 75 73 65 20 69 |MENT....|J. use i|
|00003340| 6e 20 61 6e 79 20 69 6e | 73 74 61 6e 63 65 2e 20 |n any in|stance. |
|00003350| 20 54 6f 20 6d 61 6b 65 | 20 61 20 70 75 62 6c 69 | To make| a publi|
|00003360| 63 20 72 6f 6c 6c 62 61 | 63 6b 20 73 65 67 6d 65 |c rollba|ck segme|
|00003370| 6e 74 20 70 72 69 76 61 | 74 65 2c 20 79 6f 75 20 |nt priva|te, you |
|00003380| 6d 75 73 74 16 00 41 4c | 54 45 52 20 52 4f 4c 4c |must..AL|TER ROLL|
|00003390| 42 41 43 4b 20 53 45 47 | 4d 45 4e 54 02 00 c1 0d |BACK SEG|MENT....|
|000033a0| 1f 00 20 44 52 4f 50 20 | 69 74 2c 20 74 68 65 6e |.. DROP |it, then|
|000033b0| 20 43 52 45 41 54 45 20 | 69 74 20 61 67 61 69 6e | CREATE |it again|
|000033c0| 2e 16 00 41 4c 54 45 52 | 20 52 4f 4c 4c 42 41 43 |...ALTER| ROLLBAC|
|000033d0| 4b 20 53 45 47 4d 45 4e | 54 02 00 c1 0e fe ff 16 |K SEGMEN|T.......|
|000033e0| 00 41 4c 54 45 52 20 52 | 4f 4c 4c 42 41 43 4b 20 |.ALTER R|OLLBACK |
|000033f0| 53 45 47 4d 45 4e 54 02 | 00 c1 0f 4a 00 20 54 68 |SEGMENT.|...J. Th|
|00003400| 65 20 53 54 4f 52 41 47 | 45 20 63 6c 61 75 73 65 |e STORAG|E clause|
|00003410| 20 61 66 66 65 63 74 73 | 20 66 75 74 75 72 65 20 | affects| future |
|00003420| 73 70 61 63 65 20 61 6c | 6c 6f 63 61 74 69 6f 6e |space al|location|
|00003430| 20 69 6e 20 61 20 72 6f | 6c 6c 62 61 63 6b 20 73 | in a ro|llback s|
|00003440| 65 67 6d 65 6e 74 2e 16 | 00 41 4c 54 45 52 20 52 |egment..|.ALTER R|
|00003450| 4f 4c 4c 42 41 43 4b 20 | 53 45 47 4d 45 4e 54 02 |OLLBACK |SEGMENT.|
|00003460| 00 c1 10 4b 00 20 59 6f | 75 20 63 61 6e 27 74 20 |...K. Yo|u can't |
|00003470| 75 73 65 20 49 4e 49 54 | 49 41 4c 20 6f 72 20 4d |use INIT|IAL or M|
|00003480| 49 4e 45 58 54 45 4e 54 | 53 20 74 6f 20 61 6c 74 |INEXTENT|S to alt|
|00003490| 65 72 20 61 6e 20 65 78 | 69 73 74 69 6e 67 20 72 |er an ex|isting r|
|000034a0| 6f 6c 6c 62 61 63 6b 20 | 73 65 67 6d 65 6e 74 2e |ollback |segment.|
|000034b0| 16 00 41 4c 54 45 52 20 | 52 4f 4c 4c 42 41 43 4b |..ALTER |ROLLBACK|
|000034c0| 20 53 45 47 4d 45 4e 54 | 02 00 c1 11 fe ff 16 00 | SEGMENT|........|
|000034d0| 41 4c 54 45 52 20 52 4f | 4c 4c 42 41 43 4b 20 53 |ALTER RO|LLBACK S|
|000034e0| 45 47 4d 45 4e 54 02 00 | c1 12 fe ff 16 00 41 4c |EGMENT..|......AL|
|000034f0| 54 45 52 20 52 4f 4c 4c | 42 41 43 4b 20 53 45 47 |TER ROLL|BACK SEG|
|00003500| 4d 45 4e 54 02 00 c1 13 | 49 00 20 53 65 65 20 61 |MENT....|I. See a|
|00003510| 6c 73 6f 3a 20 63 72 65 | 61 74 65 20 64 61 74 61 |lso: cre|ate data|
|00003520| 62 61 73 65 2c 20 63 72 | 65 61 74 65 20 72 6f 6c |base, cr|eate rol|
|00003530| 6c 62 61 63 6b 2c 20 63 | 72 65 61 74 65 20 74 61 |lback, c|reate ta|
|00003540| 62 6c 65 73 70 61 63 65 | 2c 20 72 6f 6c 6c 62 61 |blespace|, rollba|
|00003550| 63 6b 2c 16 00 41 4c 54 | 45 52 20 52 4f 4c 4c 42 |ck,..ALT|ER ROLLB|
|00003560| 41 43 4b 20 53 45 47 4d | 45 4e 54 02 00 c1 14 1a |ACK SEGM|ENT.....|
|00003570| 00 20 20 20 20 20 20 20 | 20 20 20 20 63 6f 6d 6d |. | comm|
|00003580| 61 6e 64 73 2c 20 6d 65 | 6e 75 2e 0e 00 41 4c 54 |ands, me|nu...ALT|
|00003590| 45 52 20 53 45 51 55 45 | 4e 43 45 02 00 c1 02 fe |ER SEQUE|NCE.....|
|000035a0| ff 0e 00 41 4c 54 45 52 | 20 53 45 51 55 45 4e 43 |...ALTER| SEQUENC|
|000035b0| 45 02 00 c1 03 fe ff 0e | 00 41 4c 54 45 52 20 53 |E.......|.ALTER S|
|000035c0| 45 51 55 45 4e 43 45 02 | 00 c1 04 31 00 20 20 20 |EQUENCE.|...1. |
|000035d0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|000035e0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|000035f0| 41 4c 54 45 52 20 53 45 | 51 55 45 4e 43 45 0e 00 |ALTER SE|QUENCE..|
|00003600| 41 4c 54 45 52 20 53 45 | 51 55 45 4e 43 45 02 00 |ALTER SE|QUENCE..|
|00003610| c1 05 4a 00 20 20 20 20 | 20 20 20 20 20 20 20 20 |..J. | |
|00003620| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00003630| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00003640| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00003650| 20 53 51 4c 20 73 74 61 | 74 65 6d 65 6e 74 0e 00 | SQL sta|tement..|
|00003660| 41 4c 54 45 52 20 53 45 | 51 55 45 4e 43 45 02 00 |ALTER SE|QUENCE..|
|00003670| c1 06 1d 00 20 41 4c 54 | 45 52 20 53 45 51 55 45 |.... ALT|ER SEQUE|
|00003680| 4e 43 45 20 75 73 65 72 | 2e 73 65 71 75 65 6e 63 |NCE user|.sequenc|
|00003690| 65 0e 00 41 4c 54 45 52 | 20 53 45 51 55 45 4e 43 |e..ALTER| SEQUENC|
|000036a0| 45 02 00 c1 07 1b 00 20 | 20 20 20 20 20 20 49 4e |E...... | IN|
|000036b0| 43 52 45 4d 45 4e 54 20 | 42 59 20 69 6e 74 65 67 |CREMENT |BY integ|
|000036c0| 65 72 0e 00 41 4c 54 45 | 52 20 53 45 51 55 45 4e |er..ALTE|R SEQUEN|
|000036d0| 43 45 02 00 c1 08 24 00 | 20 20 20 20 20 20 20 4d |CE....$.| M|
|000036e0| 41 58 56 41 4c 55 45 20 | 69 6e 74 65 67 65 72 20 |AXVALUE |integer |
|000036f0| 7c 20 4e 4f 4d 41 58 56 | 41 4c 55 45 0e 00 41 4c || NOMAXV|ALUE..AL|
|00003700| 54 45 52 20 53 45 51 55 | 45 4e 43 45 02 00 c1 09 |TER SEQU|ENCE....|
|00003710| 24 00 20 20 20 20 20 20 | 20 4d 49 4e 56 41 4c 55 |$. | MINVALU|
|00003720| 45 20 69 6e 74 65 67 65 | 72 20 7c 20 4e 4f 4d 49 |E intege|r | NOMI|
|00003730| 4e 56 41 4c 55 45 0e 00 | 41 4c 54 45 52 20 53 45 |NVALUE..|ALTER SE|
|00003740| 51 55 45 4e 43 45 02 00 | c1 0a 16 00 20 20 20 20 |QUENCE..|.... |
|00003750| 20 20 20 43 59 43 4c 45 | 20 7c 20 4e 4f 43 59 43 | CYCLE| | NOCYC|
|00003760| 4c 45 0e 00 41 4c 54 45 | 52 20 53 45 51 55 45 4e |LE..ALTE|R SEQUEN|
|00003770| 43 45 02 00 c1 0b 1e 00 | 20 20 20 20 20 20 20 43 |CE......| C|
|00003780| 41 43 48 45 20 69 6e 74 | 65 67 65 72 20 7c 20 4e |ACHE int|eger | N|
|00003790| 4f 43 41 43 48 45 0e 00 | 41 4c 54 45 52 20 53 45 |OCACHE..|ALTER SE|
|000037a0| 51 55 45 4e 43 45 02 00 | c1 0c 16 00 20 20 20 20 |QUENCE..|.... |
|000037b0| 20 20 20 4f 52 44 45 52 | 20 7c 20 4e 4f 4f 52 44 | ORDER| | NOORD|
|000037c0| 45 52 0e 00 41 4c 54 45 | 52 20 53 45 51 55 45 4e |ER..ALTE|R SEQUEN|
|000037d0| 43 45 02 00 c1 0d fe ff | 0e 00 41 4c 54 45 52 20 |CE......|..ALTER |
|000037e0| 53 45 51 55 45 4e 43 45 | 02 00 c1 0e 47 00 20 55 |SEQUENCE|....G. U|
|000037f0| 73 65 20 41 4c 54 45 52 | 20 53 45 51 55 45 4e 43 |se ALTER| SEQUENC|
|00003800| 45 20 74 6f 20 63 68 61 | 6e 67 65 20 74 68 65 20 |E to cha|nge the |
|00003810| 66 75 74 75 72 65 20 69 | 6e 63 72 65 6d 65 6e 74 |future i|ncrement|
|00003820| 20 6f 66 20 73 65 71 75 | 65 6e 63 65 20 6e 75 6d | of sequ|ence num|
|00003830| 62 65 72 73 2c 0e 00 41 | 4c 54 45 52 20 53 45 51 |bers,..A|LTER SEQ|
|00003840| 55 45 4e 43 45 02 00 c1 | 0f 48 00 20 74 6f 20 72 |UENCE...|.H. to r|
|00003850| 65 73 65 74 20 6f 72 20 | 72 65 6d 6f 76 65 20 69 |eset or |remove i|
|00003860| 74 73 20 4d 49 4e 56 41 | 4c 55 45 20 6f 72 20 4d |ts MINVA|LUE or M|
|00003870| 41 58 56 41 4c 55 45 2c | 20 6f 72 20 74 6f 20 74 |AXVALUE,| or to t|
|00003880| 75 72 6e 20 43 41 43 48 | 45 20 61 6e 64 20 4f 52 |urn CACH|E and OR|
|00003890| 44 45 52 0e 00 41 4c 54 | 45 52 20 53 45 51 55 45 |DER..ALT|ER SEQUE|
|000038a0| 4e 43 45 02 00 c1 10 49 | 00 20 6f 6e 20 6f 72 20 |NCE....I|. on or |
|000038b0| 6f 66 66 2e 20 54 68 65 | 20 43 41 43 48 45 20 69 |off. The| CACHE i|
|000038c0| 6e 74 65 67 65 72 20 6d | 75 73 74 20 62 65 20 73 |nteger m|ust be s|
|000038d0| 6d 61 6c 6c 65 72 20 74 | 68 61 6e 20 74 68 65 20 |maller t|han the |
|000038e0| 64 69 66 66 65 72 65 6e | 63 65 20 62 65 74 77 65 |differen|ce betwe|
|000038f0| 65 6e 0e 00 41 4c 54 45 | 52 20 53 45 51 55 45 4e |en..ALTE|R SEQUEN|
|00003900| 43 45 02 00 c1 11 49 00 | 20 4d 41 58 56 41 4c 55 |CE....I.| MAXVALU|
|00003910| 45 20 61 6e 64 20 4d 49 | 4e 56 41 4c 55 45 2e 20 |E and MI|NVALUE. |
|00003920| 49 66 20 79 6f 75 20 75 | 73 65 20 43 59 43 4c 45 |If you u|se CYCLE|
|00003930| 2c 20 61 6e 20 61 73 63 | 65 6e 64 69 6e 67 20 73 |, an asc|ending s|
|00003940| 65 71 75 65 6e 63 65 20 | 67 69 76 65 73 20 69 74 |equence |gives it|
|00003950| 73 0e 00 41 4c 54 45 52 | 20 53 45 51 55 45 4e 43 |s..ALTER| SEQUENC|
|00003960| 45 02 00 c1 12 46 00 20 | 4d 49 4e 56 41 4c 55 45 |E....F. |MINVALUE|
|00003970| 20 61 66 74 65 72 20 72 | 65 61 63 68 69 6e 67 20 | after r|eaching |
|00003980| 4d 41 58 56 41 4c 55 45 | 2c 20 61 6e 64 20 61 20 |MAXVALUE|, and a |
|00003990| 64 65 73 63 65 6e 64 69 | 6e 67 20 73 65 71 75 65 |descendi|ng seque|
|000039a0| 6e 63 65 20 67 69 76 65 | 73 20 69 74 73 0e 00 41 |nce give|s its..A|
|000039b0| 4c 54 45 52 20 53 45 51 | 55 45 4e 43 45 02 00 c1 |LTER SEQ|UENCE...|
|000039c0| 13 22 00 20 4d 41 58 56 | 41 4c 55 45 20 61 66 74 |.". MAXV|ALUE aft|
|000039d0| 65 72 20 72 65 61 63 68 | 69 6e 67 20 4d 49 4e 56 |er reach|ing MINV|
|000039e0| 41 4c 55 45 2e 0e 00 41 | 4c 54 45 52 20 53 45 51 |ALUE...A|LTER SEQ|
|000039f0| 55 45 4e 43 45 02 00 c1 | 14 fe ff 0e 00 41 4c 54 |UENCE...|.....ALT|
|00003a00| 45 52 20 53 45 51 55 45 | 4e 43 45 02 00 c1 15 41 |ER SEQUE|NCE....A|
|00003a10| 00 20 54 6f 20 72 65 73 | 74 61 72 74 20 61 20 73 |. To res|tart a s|
|00003a20| 65 71 75 65 6e 63 65 20 | 61 74 20 61 20 6e 65 77 |equence |at a new|
|00003a30| 20 6e 75 6d 62 65 72 2c | 20 44 52 4f 50 20 61 6e | number,| DROP an|
|00003a40| 64 20 43 52 45 41 54 45 | 20 69 74 20 61 67 61 69 |d CREATE| it agai|
|00003a50| 6e 2e 0e 00 41 4c 54 45 | 52 20 53 45 51 55 45 4e |n...ALTE|R SEQUEN|
|00003a60| 43 45 02 00 c1 16 fe ff | 0e 00 41 4c 54 45 52 20 |CE......|..ALTER |
|00003a70| 53 45 51 55 45 4e 43 45 | 02 00 c1 17 fe ff 0e 00 |SEQUENCE|........|
|00003a80| 41 4c 54 45 52 20 53 45 | 51 55 45 4e 43 45 02 00 |ALTER SE|QUENCE..|
|00003a90| c1 18 45 00 20 53 65 65 | 20 61 6c 73 6f 3a 20 73 |..E. See| also: s|
|00003aa0| 65 71 75 65 6e 63 65 73 | 2c 20 63 72 65 61 74 65 |equences|, create|
|00003ab0| 20 73 65 71 75 65 6e 63 | 65 2c 20 64 72 6f 70 20 | sequenc|e, drop |
|00003ac0| 73 65 71 75 65 6e 63 65 | 2c 20 63 6f 6d 6d 61 6e |sequence|, comman|
|00003ad0| 64 73 2c 20 6d 65 6e 75 | 2e 0b 00 41 4c 54 45 52 |ds, menu|...ALTER|
|00003ae0| 20 54 41 42 4c 45 02 00 | c1 02 fe ff 0b 00 41 4c | TABLE..|......AL|
|00003af0| 54 45 52 20 54 41 42 4c | 45 02 00 c1 03 fe ff 0b |TER TABL|E.......|
|00003b00| 00 41 4c 54 45 52 20 54 | 41 42 4c 45 02 00 c1 04 |.ALTER T|ABLE....|
|00003b10| 2c 00 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |,. | |
|00003b20| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00003b30| 20 20 20 41 4c 54 45 52 | 20 54 41 42 4c 45 0b 00 | ALTER| TABLE..|
|00003b40| 41 4c 54 45 52 20 54 41 | 42 4c 45 02 00 c1 05 48 |ALTER TA|BLE....H|
|00003b50| 00 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |. | |
|00003b60| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00003b70| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00003b80| 20 20 20 20 20 20 20 20 | 20 20 20 20 53 51 4c 20 | | SQL |
|00003b90| 73 74 61 74 65 6d 65 6e | 74 0b 00 41 4c 54 45 52 |statemen|t..ALTER|
|00003ba0| 20 54 41 42 4c 45 02 00 | c1 06 17 00 20 41 4c 54 | TABLE..|.... ALT|
|00003bb0| 45 52 20 54 41 42 4c 45 | 20 75 73 65 72 2e 74 61 |ER TABLE| user.ta|
|00003bc0| 62 6c 65 0b 00 41 4c 54 | 45 52 20 54 41 42 4c 45 |ble..ALT|ER TABLE|
|00003bd0| 02 00 c1 07 2a 00 20 20 | 20 20 41 44 44 20 63 6f |....*. | ADD co|
|00003be0| 6c 75 6d 6e 5f 65 6c 65 | 6d 65 6e 74 20 7c 20 74 |lumn_ele|ment | t|
|00003bf0| 61 62 6c 65 5f 63 6f 6e | 73 74 72 61 69 6e 74 2c |able_con|straint,|
|00003c00| 0b 00 41 4c 54 45 52 20 | 54 41 42 4c 45 02 00 c1 |..ALTER |TABLE...|
|00003c10| 08 2d 00 20 20 20 20 20 | 20 20 20 63 6f 6c 75 6d |.-. | colum|
|00003c20| 6e 5f 65 6c 65 6d 65 6e | 74 20 7c 20 74 61 62 6c |n_elemen|t | tabl|
|00003c30| 65 5f 63 6f 6e 73 74 72 | 61 69 6e 74 2c 2e 2e 2e |e_constr|aint,...|
|00003c40| 0b 00 41 4c 54 45 52 20 | 54 41 42 4c 45 02 00 c1 |..ALTER |TABLE...|
|00003c50| 09 2d 00 20 20 20 20 4d | 4f 44 49 46 59 20 63 6f |.-. M|ODIFY co|
|00003c60| 6c 75 6d 6e 5f 65 6c 65 | 6d 65 6e 74 2c 20 63 6f |lumn_ele|ment, co|
|00003c70| 6c 75 6d 6e 5f 65 6c 65 | 6d 65 6e 74 2c 2e 2e 2e |lumn_ele|ment,...|
|00003c80| 0b 00 41 4c 54 45 52 20 | 54 41 42 4c 45 02 00 c1 |..ALTER |TABLE...|
|00003c90| 0a 2e 00 20 20 20 20 44 | 52 4f 50 20 43 4f 4e 53 |... D|ROP CONS|
|00003ca0| 54 52 41 49 4e 54 20 63 | 6f 6e 73 74 72 61 69 6e |TRAINT c|onstrain|
|00003cb0| 74 2c 20 63 6f 6e 73 74 | 72 61 69 6e 74 2c 2e 2e |t, const|raint,..|
|00003cc0| 2e 0b 00 41 4c 54 45 52 | 20 54 41 42 4c 45 02 00 |...ALTER| TABLE..|
|00003cd0| c1 0b 25 00 20 20 20 20 | 50 43 54 46 52 45 45 20 |..%. |PCTFREE |
|00003ce0| 69 6e 74 65 67 65 72 20 | 20 20 50 43 54 55 53 45 |integer | PCTUSE|
|00003cf0| 44 20 69 6e 74 65 67 65 | 72 0b 00 41 4c 54 45 52 |D intege|r..ALTER|
|00003d00| 20 54 41 42 4c 45 02 00 | c1 0c 26 00 20 20 20 20 | TABLE..|..&. |
|00003d10| 49 4e 49 54 52 41 4e 53 | 20 69 6e 74 65 67 65 72 |INITRANS| integer|
|00003d20| 20 20 4d 41 58 54 52 41 | 4e 53 20 69 6e 74 65 67 | MAXTRA|NS integ|
|00003d30| 65 72 0b 00 41 4c 54 45 | 52 20 54 41 42 4c 45 02 |er..ALTE|R TABLE.|
|00003d40| 00 c1 0d 12 00 20 20 20 | 20 53 54 4f 52 41 47 45 |..... | STORAGE|
|00003d50| 20 63 6c 61 75 73 65 0b | 00 41 4c 54 45 52 20 54 | clause.|.ALTER T|
|00003d60| 41 42 4c 45 02 00 c1 0e | 0a 00 20 20 20 20 42 41 |ABLE....|.. BA|
|00003d70| 43 4b 55 50 0b 00 41 4c | 54 45 52 20 54 41 42 4c |CKUP..AL|TER TABL|
|00003d80| 45 02 00 c1 0f fe ff 0b | 00 41 4c 54 45 52 20 54 |E.......|.ALTER T|
|00003d90| 41 42 4c 45 02 00 c1 10 | 48 00 20 55 73 65 20 41 |ABLE....|H. Use A|
|00003da0| 4c 54 45 52 20 54 41 42 | 4c 45 20 74 6f 20 61 64 |LTER TAB|LE to ad|
|00003db0| 64 20 63 6f 6c 75 6d 6e | 73 20 6f 72 20 63 6f 6e |d column|s or con|
|00003dc0| 73 74 72 61 69 6e 74 73 | 20 74 6f 20 61 20 74 61 |straints| to a ta|
|00003dd0| 62 6c 65 2c 20 63 68 61 | 6e 67 65 20 63 6f 6c 75 |ble, cha|nge colu|
|00003de0| 6d 6e 0b 00 41 4c 54 45 | 52 20 54 41 42 4c 45 02 |mn..ALTE|R TABLE.|
|00003df0| 00 c1 11 49 00 20 64 61 | 74 61 74 79 70 65 73 2c |...I. da|tatypes,|
|00003e00| 20 73 69 7a 65 73 2c 20 | 61 6e 64 20 4e 4f 54 20 | sizes, |and NOT |
|00003e10| 4e 55 4c 4c 20 73 65 74 | 74 69 6e 67 73 2c 20 64 |NULL set|tings, d|
|00003e20| 72 6f 70 20 63 6f 6e 73 | 74 72 61 69 6e 74 73 2c |rop cons|traints,|
|00003e30| 20 63 68 61 6e 67 65 20 | 66 75 74 75 72 65 0b 00 | change |future..|
|00003e40| 41 4c 54 45 52 20 54 41 | 42 4c 45 02 00 c1 12 4a |ALTER TA|BLE....J|
|00003e50| 00 20 73 74 6f 72 61 67 | 65 20 61 6c 6c 6f 63 61 |. storag|e alloca|
|00003e60| 74 69 6f 6e 73 2c 20 61 | 6e 64 20 75 70 64 61 74 |tions, a|nd updat|
|00003e70| 65 20 74 68 65 20 64 61 | 74 61 20 64 69 63 74 69 |e the da|ta dicti|
|00003e80| 6f 6e 61 72 79 20 74 6f | 20 73 68 6f 77 20 74 68 |onary to| show th|
|00003e90| 61 74 20 61 20 42 41 43 | 4b 55 50 0b 00 41 4c 54 |at a BAC|KUP..ALT|
|00003ea0| 45 52 20 54 41 42 4c 45 | 02 00 c1 13 37 00 20 6f |ER TABLE|....7. o|
|00003eb0| 66 20 74 68 65 20 74 61 | 62 6c 65 20 6f 63 63 75 |f the ta|ble occu|
|00003ec0| 72 72 65 64 20 77 68 65 | 6e 20 74 68 65 20 73 74 |rred whe|n the st|
|00003ed0| 61 74 65 6d 65 6e 74 20 | 77 61 73 20 65 78 65 63 |atement |was exec|
|00003ee0| 75 74 65 64 2e 0b 00 41 | 4c 54 45 52 20 54 41 42 |uted...A|LTER TAB|
|00003ef0| 4c 45 02 00 c1 14 fe ff | 0b 00 41 4c 54 45 52 20 |LE......|..ALTER |
|00003f00| 54 41 42 4c 45 02 00 c1 | 15 fe ff 0b 00 41 4c 54 |TABLE...|.....ALT|
|00003f10| 45 52 20 54 41 42 4c 45 | 02 00 c1 16 3c 00 20 53 |ER TABLE|....<. S|
|00003f20| 65 65 20 61 6c 73 6f 3a | 20 74 61 62 6c 65 73 2c |ee also:| tables,|
|00003f30| 20 63 72 65 61 74 65 20 | 74 61 62 6c 65 2c 20 63 | create |table, c|
|00003f40| 6f 6e 73 74 72 61 69 6e | 74 2c 20 63 6f 6d 6d 61 |onstrain|t, comma|
|00003f50| 6e 64 73 2c 20 6d 65 6e | 75 2e 10 00 41 4c 54 45 |nds, men|u...ALTE|
|00003f60| 52 20 54 41 42 4c 45 53 | 50 41 43 45 02 00 c1 02 |R TABLES|PACE....|
|00003f70| fe ff 10 00 41 4c 54 45 | 52 20 54 41 42 4c 45 53 |....ALTE|R TABLES|
|00003f80| 50 41 43 45 02 00 c1 03 | fe ff 10 00 41 4c 54 45 |PACE....|....ALTE|
|00003f90| 52 20 54 41 42 4c 45 53 | 50 41 43 45 02 00 c1 04 |R TABLES|PACE....|
|00003fa0| 2e 00 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |.. | |
|00003fb0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00003fc0| 41 4c 54 45 52 20 54 41 | 42 4c 45 53 50 41 43 45 |ALTER TA|BLESPACE|
|00003fd0| 10 00 41 4c 54 45 52 20 | 54 41 42 4c 45 53 50 41 |..ALTER |TABLESPA|
|00003fe0| 43 45 02 00 c1 05 46 00 | 20 20 20 20 20 20 20 20 |CE....F.| |
|00003ff0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00004000| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00004010| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00004020| 20 53 51 4c 20 73 74 61 | 74 65 6d 65 6e 74 10 00 | SQL sta|tement..|
|00004030| 41 4c 54 45 52 20 54 41 | 42 4c 45 53 50 41 43 45 |ALTER TA|BLESPACE|
|00004040| 02 00 c1 06 1c 00 20 41 | 4c 54 45 52 20 54 41 42 |...... A|LTER TAB|
|00004050| 4c 45 53 50 41 43 45 20 | 74 61 62 6c 65 73 70 61 |LESPACE |tablespa|
|00004060| 63 65 10 00 41 4c 54 45 | 52 20 54 41 42 4c 45 53 |ce..ALTE|R TABLES|
|00004070| 50 41 43 45 02 00 c1 07 | 35 00 20 41 44 44 20 44 |PACE....|5. ADD D|
|00004080| 41 54 41 46 49 4c 45 20 | 27 66 69 6c 65 6e 61 6d |ATAFILE |'filenam|
|00004090| 65 27 20 53 49 5a 45 20 | 69 6e 74 65 67 65 72 20 |e' SIZE |integer |
|000040a0| 4b 20 7c 20 4d 20 52 45 | 55 53 45 2c 2e 2e 2e 10 |K | M RE|USE,....|
|000040b0| 00 41 4c 54 45 52 20 54 | 41 42 4c 45 53 50 41 43 |.ALTER T|ABLESPAC|
|000040c0| 45 02 00 c1 08 2b 00 20 | 52 45 4e 41 4d 45 20 44 |E....+. |RENAME D|
|000040d0| 41 54 41 46 49 4c 45 20 | 27 66 69 6c 65 6e 61 6d |ATAFILE |'filenam|
|000040e0| 65 27 2c 20 27 66 69 6c | 65 6e 61 6d 65 27 2c 2e |e', 'fil|ename',.|
|000040f0| 2e 2e 10 00 41 4c 54 45 | 52 20 54 41 42 4c 45 53 |....ALTE|R TABLES|
|00004100| 50 41 43 45 02 00 c1 09 | 2d 00 20 20 20 20 20 20 |PACE....|-. |
|00004110| 20 20 20 20 20 20 20 20 | 20 20 54 4f 20 27 66 69 | | TO 'fi|
|00004120| 6c 65 6e 61 6d 65 27 2c | 20 27 66 69 6c 65 6e 61 |lename',| 'filena|
|00004130| 6d 65 27 2c 2e 2e 2e 10 | 00 41 4c 54 45 52 20 54 |me',....|.ALTER T|
|00004140| 41 42 4c 45 53 50 41 43 | 45 02 00 c1 0a 17 00 20 |ABLESPAC|E...... |
|00004150| 44 45 46 41 55 4c 54 20 | 53 54 4f 52 41 47 45 20 |DEFAULT |STORAGE |
|00004160| 63 6c 61 75 73 65 10 00 | 41 4c 54 45 52 20 54 41 |clause..|ALTER TA|
|00004170| 42 4c 45 53 50 41 43 45 | 02 00 c1 0b 24 00 20 4f |BLESPACE|....$. O|
|00004180| 4e 4c 49 4e 45 20 7c 20 | 4f 46 46 4c 49 4e 45 20 |NLINE | |OFFLINE |
|00004190| 4e 4f 52 4d 41 4c 20 7c | 20 49 4d 4d 45 44 49 41 |NORMAL || IMMEDIA|
|000041a0| 54 45 10 00 41 4c 54 45 | 52 20 54 41 42 4c 45 53 |TE..ALTE|R TABLES|
|000041b0| 50 41 43 45 02 00 c1 0c | 1a 00 20 42 45 47 49 4e |PACE....|.. BEGIN|
|000041c0| 20 42 41 43 4b 55 50 20 | 7c 20 45 4e 44 20 42 41 | BACKUP || END BA|
|000041d0| 43 4b 55 50 10 00 41 4c | 54 45 52 20 54 41 42 4c |CKUP..AL|TER TABL|
|000041e0| 45 53 50 41 43 45 02 00 | c1 0d fe ff 10 00 41 4c |ESPACE..|......AL|
|000041f0| 54 45 52 20 54 41 42 4c | 45 53 50 41 43 45 02 00 |TER TABL|ESPACE..|
|00004200| c1 0e 45 00 20 55 73 65 | 20 41 4c 54 45 52 20 54 |..E. Use| ALTER T|
|00004210| 41 42 4c 45 53 50 41 43 | 45 20 74 6f 20 61 64 64 |ABLESPAC|E to add|
|00004220| 20 6f 72 20 72 65 6e 61 | 6d 65 20 64 61 74 61 62 | or rena|me datab|
|00004230| 61 73 65 20 66 69 6c 65 | 73 2c 20 63 68 61 6e 67 |ase file|s, chang|
|00004240| 65 20 64 65 66 61 75 6c | 74 10 00 41 4c 54 45 52 |e defaul|t..ALTER|
|00004250| 20 54 41 42 4c 45 53 50 | 41 43 45 02 00 c1 0f 45 | TABLESP|ACE....E|
|00004260| 00 20 74 61 62 6c 65 73 | 70 61 63 65 20 73 74 6f |. tables|pace sto|
|00004270| 72 61 67 65 20 70 61 72 | 61 6d 65 74 65 72 73 2c |rage par|ameters,|
|00004280| 20 70 75 74 20 74 68 65 | 20 74 61 62 6c 65 73 70 | put the| tablesp|
|00004290| 61 63 65 20 6f 6e 6c 69 | 6e 65 20 6f 72 20 6f 66 |ace onli|ne or of|
|000042a0| 66 6c 69 6e 65 2c 10 00 | 41 4c 54 45 52 20 54 41 |fline,..|ALTER TA|
|000042b0| 42 4c 45 53 50 41 43 45 | 02 00 c1 10 3d 00 20 61 |BLESPACE|....=. a|
|000042c0| 6e 64 20 73 74 61 72 74 | 20 6f 72 20 73 74 6f 70 |nd start| or stop|
|000042d0| 20 62 61 63 6b 75 70 2e | 20 20 54 6f 20 72 65 6e | backup.| To ren|
|000042e0| 61 6d 65 20 6f 6e 65 20 | 6f 72 20 6d 6f 72 65 20 |ame one |or more |
|000042f0| 64 61 74 61 20 66 69 6c | 65 73 3a 10 00 41 4c 54 |data fil|es:..ALT|
|00004300| 45 52 20 54 41 42 4c 45 | 53 50 41 43 45 02 00 c1 |ER TABLE|SPACE...|
|00004310| 11 fe ff 10 00 41 4c 54 | 45 52 20 54 41 42 4c 45 |.....ALT|ER TABLE|
|00004320| 53 50 41 43 45 02 00 c1 | 12 24 00 20 20 20 20 31 |SPACE...|.$. 1|
|00004330| 2e 20 20 54 61 6b 65 20 | 74 68 65 20 74 61 62 6c |. Take |the tabl|
|00004340| 65 73 70 61 63 65 20 6f | 66 66 6c 69 6e 65 2e 10 |espace o|ffline..|
|00004350| 00 41 4c 54 45 52 20 54 | 41 42 4c 45 53 50 41 43 |.ALTER T|ABLESPAC|
|00004360| 45 02 00 c1 13 37 00 20 | 20 20 20 32 2e 20 20 52 |E....7. | 2. R|
|00004370| 65 6e 61 6d 65 20 74 68 | 65 20 66 69 6c 65 73 20 |ename th|e files |
|00004380| 61 74 20 74 68 65 20 6f | 70 65 72 61 74 69 6e 67 |at the o|perating|
|00004390| 20 73 79 73 74 65 6d 20 | 6c 65 76 65 6c 2e 10 00 | system |level...|
|000043a0| 41 4c 54 45 52 20 54 41 | 42 4c 45 53 50 41 43 45 |ALTER TA|BLESPACE|
|000043b0| 02 00 c1 14 3d 00 20 20 | 20 20 33 2e 20 20 52 65 |....=. | 3. Re|
|000043c0| 6e 61 6d 65 20 74 68 65 | 20 64 61 74 61 62 61 73 |name the| databas|
|000043d0| 65 20 66 69 6c 65 73 20 | 77 69 74 68 20 77 69 74 |e files |with wit|
|000043e0| 68 20 41 4c 54 45 52 20 | 54 41 42 4c 45 53 50 41 |h ALTER |TABLESPA|
|000043f0| 43 45 2e 10 00 41 4c 54 | 45 52 20 54 41 42 4c 45 |CE...ALT|ER TABLE|
|00004400| 53 50 41 43 45 02 00 c1 | 15 29 00 20 20 20 20 34 |SPACE...|.). 4|
|00004410| 2e 20 20 42 72 69 6e 67 | 20 74 68 65 20 74 61 62 |. Bring| the tab|
|00004420| 6c 65 73 70 61 63 65 20 | 62 61 63 6b 20 6f 6e 6c |lespace |back onl|
|00004430| 69 6e 65 2e 10 00 41 4c | 54 45 52 20 54 41 42 4c |ine...AL|TER TABL|
|00004440| 45 53 50 41 43 45 02 00 | c1 16 fe ff 10 00 41 4c |ESPACE..|......AL|
|00004450| 54 45 52 20 54 41 42 4c | 45 53 50 41 43 45 02 00 |TER TABL|ESPACE..|
|00004460| c1 17 fe ff 10 00 41 4c | 54 45 52 20 54 41 42 4c |......AL|TER TABL|
|00004470| 45 53 50 41 43 45 02 00 | c1 18 44 00 20 53 65 65 |ESPACE..|..D. See|
|00004480| 20 61 6c 73 6f 3a 20 63 | 72 65 61 74 65 20 74 61 | also: c|reate ta|
|00004490| 62 6c 65 73 70 61 63 65 | 2c 20 63 72 65 61 74 65 |blespace|, create|
|000044a0| 20 64 61 74 61 62 61 73 | 65 2c 20 64 72 6f 70 20 | databas|e, drop |
|000044b0| 74 61 62 6c 65 73 70 61 | 63 65 2c 20 64 62 61 2c |tablespa|ce, dba,|
|000044c0| 10 00 41 4c 54 45 52 20 | 54 41 42 4c 45 53 50 41 |..ALTER |TABLESPA|
|000044d0| 43 45 02 00 c1 19 1a 00 | 20 20 20 20 20 20 20 20 |CE......| |
|000044e0| 20 20 20 63 6f 6d 6d 61 | 6e 64 73 2c 20 6d 65 6e | comma|nds, men|
|000044f0| 75 2e 0a 00 41 4c 54 45 | 52 20 55 53 45 52 02 00 |u...ALTE|R USER..|
|00004500| c1 02 fe ff 0a 00 41 4c | 54 45 52 20 55 53 45 52 |......AL|TER USER|
|00004510| 02 00 c1 03 fe ff 0a 00 | 41 4c 54 45 52 20 55 53 |........|ALTER US|
|00004520| 45 52 02 00 c1 04 2c 00 | 20 20 20 20 20 20 20 20 |ER....,.| |
|00004530| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00004540| 20 20 20 20 20 20 20 20 | 20 20 41 4c 54 45 52 20 | | ALTER |
|00004550| 55 53 45 52 0a 00 41 4c | 54 45 52 20 55 53 45 52 |USER..AL|TER USER|
|00004560| 02 00 c1 05 4a 00 20 20 | 20 20 20 20 20 20 20 20 |....J. | |
|00004570| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00004580| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00004590| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|000045a0| 20 20 20 53 51 4c 20 73 | 74 61 74 65 6d 65 6e 74 | SQL s|tatement|
|000045b0| 0a 00 41 4c 54 45 52 20 | 55 53 45 52 02 00 c1 06 |..ALTER |USER....|
|000045c0| 2b 00 20 41 4c 54 45 52 | 20 55 53 45 52 20 75 73 |+. ALTER| USER us|
|000045d0| 65 72 6e 61 6d 65 20 49 | 44 45 4e 54 49 46 49 45 |ername I|DENTIFIE|
|000045e0| 44 20 42 59 20 70 61 73 | 73 77 6f 72 64 0a 00 41 |D BY pas|sword..A|
|000045f0| 4c 54 45 52 20 55 53 45 | 52 02 00 c1 07 21 00 20 |LTER USE|R....!. |
|00004600| 20 20 20 44 45 46 41 55 | 4c 54 20 54 41 42 4c 45 | DEFAU|LT TABLE|
|00004610| 53 50 41 43 45 20 74 61 | 62 6c 65 73 70 61 63 65 |SPACE ta|blespace|
|00004620| 0a 00 41 4c 54 45 52 20 | 55 53 45 52 02 00 c1 08 |..ALTER |USER....|
|00004630| 23 00 20 20 20 20 54 45 | 4d 50 4f 52 41 52 59 20 |#. TE|MPORARY |
|00004640| 54 41 42 4c 45 53 50 41 | 43 45 20 74 61 62 6c 65 |TABLESPA|CE table|
|00004650| 73 70 61 63 65 0a 00 41 | 4c 54 45 52 20 55 53 45 |space..A|LTER USE|
|00004660| 52 02 00 c1 09 fe ff 0a | 00 41 4c 54 45 52 20 55 |R.......|.ALTER U|
|00004670| 53 45 52 02 00 c1 0a 47 | 00 20 55 73 65 20 41 4c |SER....G|. Use AL|
|00004680| 54 45 52 20 55 53 45 52 | 20 74 6f 20 63 68 61 6e |TER USER| to chan|
|00004690| 67 65 20 61 20 75 73 65 | 72 27 73 20 70 61 73 73 |ge a use|r's pass|
|000046a0| 77 6f 72 64 2c 20 74 68 | 65 20 64 65 66 61 75 6c |word, th|e defaul|
|000046b0| 74 20 74 61 62 6c 65 73 | 70 61 63 65 20 66 6f 72 |t tables|pace for|
|000046c0| 0a 00 41 4c 54 45 52 20 | 55 53 45 52 02 00 c1 0b |..ALTER |USER....|
|000046d0| 43 00 20 6f 62 6a 65 63 | 74 20 63 72 65 61 74 69 |C. objec|t creati|
|000046e0| 6f 6e 2c 20 6f 72 20 74 | 68 65 20 64 65 66 61 75 |on, or t|he defau|
|000046f0| 6c 74 20 74 65 6d 70 6f | 72 61 72 79 20 74 61 62 |lt tempo|rary tab|
|00004700| 6c 65 73 70 61 63 65 20 | 66 6f 72 20 74 65 6d 70 |lespace |for temp|
|00004710| 6f 72 61 72 79 0a 00 41 | 4c 54 45 52 20 55 53 45 |orary..A|LTER USE|
|00004720| 52 02 00 c1 0c 1f 00 20 | 73 65 67 6d 65 6e 74 73 |R...... |segments|
|00004730| 20 63 72 65 61 74 65 64 | 20 66 6f 72 20 74 68 65 | created| for the|
|00004740| 20 75 73 65 72 2e 0a 00 | 41 4c 54 45 52 20 55 53 | user...|ALTER US|
|00004750| 45 52 02 00 c1 0d fe ff | 0a 00 41 4c 54 45 52 20 |ER......|..ALTER |
|00004760| 55 53 45 52 02 00 c1 0e | 4b 00 20 41 20 70 61 73 |USER....|K. A pas|
|00004770| 73 77 6f 72 64 20 6d 61 | 79 20 61 6c 73 6f 20 62 |sword ma|y also b|
|00004780| 65 20 63 68 61 6e 67 65 | 64 20 77 69 74 68 20 74 |e change|d with t|
|00004790| 68 65 20 47 52 41 4e 54 | 20 73 74 61 74 65 6d 65 |he GRANT| stateme|
|000047a0| 6e 74 2e 20 20 41 20 75 | 73 65 72 27 73 20 64 65 |nt. A u|ser's de|
|000047b0| 66 61 75 6c 74 0a 00 41 | 4c 54 45 52 20 55 53 45 |fault..A|LTER USE|
|000047c0| 52 02 00 c1 0f 4b 00 20 | 74 61 62 6c 65 73 70 61 |R....K. |tablespa|
|000047d0| 63 65 20 69 73 20 61 6c | 73 6f 20 73 65 74 20 77 |ce is al|so set w|
|000047e0| 68 65 6e 20 74 68 61 74 | 20 75 73 65 72 20 69 73 |hen that| user is|
|000047f0| 20 67 72 61 6e 74 65 64 | 20 72 65 73 6f 75 72 63 | granted| resourc|
|00004800| 65 20 74 6f 20 61 20 74 | 61 62 6c 65 73 70 61 63 |e to a t|ablespac|
|00004810| 65 2c 0a 00 41 4c 54 45 | 52 20 55 53 45 52 02 00 |e,..ALTE|R USER..|
|00004820| c1 10 4a 00 20 69 66 20 | 69 74 27 73 20 74 68 65 |..J. if |it's the|
|00004830| 20 66 69 72 73 74 20 74 | 61 62 6c 65 73 70 61 63 | first t|ablespac|
|00004840| 65 20 74 6f 20 77 68 69 | 63 68 20 74 68 65 20 75 |e to whi|ch the u|
|00004850| 73 65 72 20 68 61 73 20 | 62 65 65 6e 20 67 72 61 |ser has |been gra|
|00004860| 6e 74 65 64 20 72 65 73 | 6f 75 72 63 65 2e 0a 00 |nted res|ource...|
|00004870| 41 4c 54 45 52 20 55 53 | 45 52 02 00 c1 11 45 00 |ALTER US|ER....E.|
|00004880| 20 54 68 65 20 64 65 66 | 61 75 6c 74 20 74 65 6d | The def|ault tem|
|00004890| 70 6f 72 61 72 79 20 74 | 61 62 6c 65 73 70 61 63 |porary t|ablespac|
|000048a0| 65 20 69 73 20 61 6c 73 | 6f 20 73 65 74 20 74 6f |e is als|o set to|
|000048b0| 20 74 68 65 20 66 69 72 | 73 74 20 74 61 62 6c 65 | the fir|st table|
|000048c0| 73 70 61 63 65 0a 00 41 | 4c 54 45 52 20 55 53 45 |space..A|LTER USE|
|000048d0| 52 02 00 c1 12 13 00 20 | 67 72 61 6e 74 65 64 20 |R...... |granted |
|000048e0| 74 6f 20 61 20 75 73 65 | 72 2e 0a 00 41 4c 54 45 |to a use|r...ALTE|
|000048f0| 52 20 55 53 45 52 02 00 | c1 13 fe ff 0a 00 41 4c |R USER..|......AL|
|00004900| 54 45 52 20 55 53 45 52 | 02 00 c1 14 fe ff 0a 00 |TER USER|........|
|00004910| 41 4c 54 45 52 20 55 53 | 45 52 02 00 c1 15 3d 00 |ALTER US|ER....=.|
|00004920| 20 53 65 65 20 61 6c 73 | 6f 3a 20 75 73 65 72 20 | See als|o: user |
|00004930| 69 64 2c 20 63 72 65 61 | 74 65 20 74 61 62 6c 65 |id, crea|te table|
|00004940| 73 70 61 63 65 2c 20 67 | 72 61 6e 74 2c 20 63 6f |space, g|rant, co|
|00004950| 6d 6d 61 6e 64 73 2c 20 | 6d 65 6e 75 2e 06 00 41 |mmands, |menu...A|
|00004960| 50 50 45 4e 44 02 00 c1 | 02 fe ff 06 00 41 50 50 |PPEND...|.....APP|
|00004970| 45 4e 44 02 00 c1 03 fe | ff 06 00 41 50 50 45 4e |END.....|...APPEN|
|00004980| 44 02 00 c1 04 2b 00 20 | 20 20 20 20 20 20 20 20 |D....+. | |
|00004990| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|000049a0| 20 20 20 20 20 20 20 20 | 20 20 20 20 41 50 50 45 | | APPE|
|000049b0| 4e 44 06 00 41 50 50 45 | 4e 44 02 00 c1 05 fe ff |ND..APPE|ND......|
|000049c0| 06 00 41 50 50 45 4e 44 | 02 00 c1 06 0e 00 20 41 |..APPEND|...... A|
|000049d0| 5b 50 50 45 4e 44 5d 20 | 74 65 78 74 06 00 41 50 |[PPEND] |text..AP|
|000049e0| 50 45 4e 44 02 00 c1 07 | fe ff 06 00 41 50 50 45 |PEND....|....APPE|
|000049f0| 4e 44 02 00 c1 08 45 00 | 20 55 73 65 20 41 50 50 |ND....E.| Use APP|
|00004a00| 45 4e 44 20 74 6f 20 61 | 64 64 20 74 65 78 74 20 |END to a|dd text |
|00004a10| 74 6f 20 74 68 65 20 65 | 6e 64 20 6f 66 20 74 68 |to the e|nd of th|
|00004a20| 65 20 63 75 72 72 65 6e | 74 20 6c 69 6e 65 20 69 |e curren|t line i|
|00004a30| 6e 20 74 68 65 20 62 75 | 66 66 65 72 2e 06 00 41 |n the bu|ffer...A|
|00004a40| 50 50 45 4e 44 02 00 c1 | 09 fe ff 06 00 41 50 50 |PPEND...|.....APP|
|00004a50| 45 4e 44 02 00 c1 0a 09 | 00 20 20 20 20 20 74 65 |END.....|. te|
|00004a60| 78 74 06 00 41 50 50 45 | 4e 44 02 00 c1 0b 49 00 |xt..APPE|ND....I.|
|00004a70| 20 20 20 20 20 20 20 20 | 20 69 73 20 74 68 65 20 | | is the |
|00004a80| 74 65 78 74 20 79 6f 75 | 20 77 69 73 68 20 74 6f |text you| wish to|
|00004a90| 20 61 70 70 65 6e 64 2e | 20 20 54 6f 20 73 65 70 | append.| To sep|
|00004aa0| 61 72 61 74 65 20 74 65 | 78 74 20 66 72 6f 6d 20 |arate te|xt from |
|00004ab0| 70 72 65 63 65 64 69 6e | 67 06 00 41 50 50 45 4e |precedin|g..APPEN|
|00004ac0| 44 02 00 c1 0c 49 00 20 | 20 20 20 20 20 20 20 20 |D....I. | |
|00004ad0| 63 68 61 72 61 63 74 65 | 72 73 20 77 69 74 68 20 |characte|rs with |
|00004ae0| 61 20 73 70 61 63 65 2c | 20 65 6e 74 65 72 20 74 |a space,| enter t|
|00004af0| 77 6f 20 73 70 61 63 65 | 73 20 62 65 74 77 65 65 |wo space|s betwee|
|00004b00| 6e 20 41 50 50 45 4e 44 | 20 61 6e 64 20 74 68 65 |n APPEND| and the|
|00004b10| 06 00 41 50 50 45 4e 44 | 02 00 c1 0d 48 00 20 20 |..APPEND|....H. |
|00004b20| 20 20 20 20 20 20 20 74 | 65 78 74 2e 20 54 6f 20 | t|ext. To |
|00004b30| 41 50 50 45 4e 44 20 74 | 65 78 74 20 74 68 61 74 |APPEND t|ext that|
|00004b40| 20 65 6e 64 73 20 77 69 | 74 68 20 61 20 73 65 6d | ends wi|th a sem|
|00004b50| 69 63 6f 6c 6f 6e 2c 20 | 65 6e 64 20 74 68 65 20 |icolon, |end the |
|00004b60| 41 50 50 45 4e 44 06 00 | 41 50 50 45 4e 44 02 00 |APPEND..|APPEND..|
|00004b70| c1 0e 4a 00 20 20 20 20 | 20 20 20 20 20 63 6f 6d |..J. | com|
|00004b80| 6d 61 6e 64 20 77 69 74 | 68 20 74 77 6f 20 73 65 |mand wit|h two se|
|00004b90| 6d 69 63 6f 6c 6f 6e 73 | 20 28 53 51 4c 2a 50 6c |micolons| (SQL*Pl|
|00004ba0| 75 73 20 69 6e 74 65 72 | 70 72 65 74 73 20 6f 6e |us inter|prets on|
|00004bb0| 65 20 73 65 6d 69 63 6f | 6c 6f 6e 20 61 73 06 00 |e semico|lon as..|
|00004bc0| 41 50 50 45 4e 44 02 00 | c1 0f 29 00 20 20 20 20 |APPEND..|..). |
|00004bd0| 20 20 20 20 20 61 6e 20 | 6f 70 74 69 6f 6e 61 6c | an |optional|
|00004be0| 20 63 6f 6d 6d 61 6e 64 | 20 74 65 72 6d 69 6e 61 | command| termina|
|00004bf0| 74 6f 72 29 2e 06 00 41 | 50 50 45 4e 44 02 00 c1 |tor)...A|PPEND...|
|00004c00| 10 fe ff 06 00 41 50 50 | 45 4e 44 02 00 c1 11 fe |.....APP|END.....|
|00004c10| ff 06 00 41 50 50 45 4e | 44 02 00 c1 12 48 00 20 |...APPEN|D....H. |
|00004c20| 45 78 61 6d 70 6c 65 73 | 3a 20 54 6f 20 61 70 70 |Examples|: To app|
|00004c30| 65 6e 64 20 61 20 73 70 | 61 63 65 20 61 6e 64 20 |end a sp|ace and |
|00004c40| 74 68 65 20 63 6f 6c 75 | 6d 6e 20 6e 61 6d 65 20 |the colu|mn name |
|00004c50| 44 45 50 54 20 74 6f 20 | 74 68 65 20 73 65 63 6f |DEPT to |the seco|
|00004c60| 6e 64 20 6c 69 6e 65 06 | 00 41 50 50 45 4e 44 02 |nd line.|.APPEND.|
|00004c70| 00 c1 13 46 00 20 20 20 | 20 20 20 20 20 20 20 20 |...F. | |
|00004c80| 6f 66 20 74 68 65 20 62 | 75 66 66 65 72 2c 20 6d |of the b|uffer, m|
|00004c90| 61 6b 65 20 74 68 61 74 | 20 6c 69 6e 65 20 74 68 |ake that| line th|
|00004ca0| 65 20 63 75 72 72 65 6e | 74 20 6c 69 6e 65 20 62 |e curren|t line b|
|00004cb0| 79 20 65 6e 74 65 72 69 | 6e 67 3a 06 00 41 50 50 |y enteri|ng:..APP|
|00004cc0| 45 4e 44 02 00 c1 14 fe | ff 06 00 41 50 50 45 4e |END.....|...APPEN|
|00004cd0| 44 02 00 c1 15 15 00 20 | 20 20 20 20 20 20 20 20 |D...... | |
|00004ce0| 20 20 20 20 20 20 53 51 | 4c 3e 20 32 06 00 41 50 | SQ|L> 2..AP|
|00004cf0| 50 45 4e 44 02 00 c1 16 | 1c 00 20 20 20 20 20 20 |PEND....|.. |
|00004d00| 20 20 20 20 20 20 20 20 | 20 20 20 32 2a 20 46 52 | | 2* FR|
|00004d10| 4f 4d 20 45 4d 50 06 00 | 41 50 50 45 4e 44 02 00 |OM EMP..|APPEND..|
|00004d20| c1 17 fe ff 06 00 41 50 | 50 45 4e 44 02 00 c1 18 |......AP|PEND....|
|00004d30| 1c 00 20 20 20 20 20 20 | 20 20 20 20 20 4e 6f 77 |.. | Now|
|00004d40| 20 65 6e 74 65 72 20 41 | 50 50 45 4e 44 3a 06 00 | enter A|PPEND:..|
|00004d50| 41 50 50 45 4e 44 02 00 | c1 19 fe ff 06 00 41 50 |APPEND..|......AP|
|00004d60| 50 45 4e 44 02 00 c1 1a | 21 00 20 20 20 20 20 20 |PEND....|!. |
|00004d70| 20 20 20 20 20 20 20 20 | 20 53 51 4c 3e 20 41 50 | | SQL> AP|
|00004d80| 50 45 4e 44 20 2c 20 44 | 45 50 54 06 00 41 50 50 |PEND , D|EPT..APP|
|00004d90| 45 4e 44 02 00 c1 1b 15 | 00 20 20 20 20 20 20 20 |END.....|. |
|00004da0| 20 20 20 20 20 20 20 20 | 53 51 4c 3e 20 32 06 00 | |SQL> 2..|
|00004db0| 41 50 50 45 4e 44 02 00 | c1 1c 22 00 20 20 20 20 |APPEND..|..". |
|00004dc0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 32 2a 20 | | 2* |
|00004dd0| 46 52 4f 4d 20 45 4d 50 | 2c 20 44 45 50 54 06 00 |FROM EMP|, DEPT..|
|00004de0| 41 50 50 45 4e 44 02 00 | c1 1d fe ff 06 00 41 50 |APPEND..|......AP|
|00004df0| 50 45 4e 44 02 00 c1 1e | 48 00 20 20 20 20 20 20 |PEND....|H. |
|00004e00| 20 20 20 20 20 54 68 65 | 20 66 69 72 73 74 20 73 | The| first s|
|00004e10| 70 61 63 65 20 62 65 74 | 77 65 65 6e 20 41 50 50 |pace bet|ween APP|
|00004e20| 45 4e 44 20 61 6e 64 20 | 74 68 65 20 63 6f 6d 6d |END and |the comm|
|00004e30| 61 20 73 65 70 61 72 61 | 74 65 73 20 41 50 50 45 |a separa|tes APPE|
|00004e40| 4e 44 06 00 41 50 50 45 | 4e 44 02 00 c1 1f 46 00 |ND..APPE|ND....F.|
|00004e50| 20 20 20 20 20 20 20 20 | 20 20 20 66 72 6f 6d 20 | | from |
|00004e60| 74 68 65 20 63 68 61 72 | 61 63 74 65 72 73 20 74 |the char|acters t|
|00004e70| 6f 20 62 65 20 61 70 70 | 65 6e 64 65 64 3b 20 74 |o be app|ended; t|
|00004e80| 68 65 20 73 65 63 6f 6e | 64 20 73 70 61 63 65 20 |he secon|d space |
|00004e90| 69 73 20 74 68 65 06 00 | 41 50 50 45 4e 44 02 00 |is the..|APPEND..|
|00004ea0| c1 20 48 00 20 20 20 20 | 20 20 20 20 20 20 20 66 |. H. | f|
|00004eb0| 69 72 73 74 20 61 70 70 | 65 6e 64 65 64 20 63 68 |irst app|ended ch|
|00004ec0| 61 72 61 63 74 65 72 2e | 20 20 54 6f 20 61 70 70 |aracter.| To app|
|00004ed0| 65 6e 64 20 61 20 73 65 | 6d 69 63 6f 6c 6f 6e 20 |end a se|micolon |
|00004ee0| 74 6f 20 74 68 65 20 6c | 69 6e 65 2c 06 00 41 50 |to the l|ine,..AP|
|00004ef0| 50 45 4e 44 02 00 c1 21 | 11 00 20 20 20 20 20 20 |PEND...!|.. |
|00004f00| 20 20 20 20 20 65 6e 74 | 65 72 3a 06 00 41 50 50 | ent|er:..APP|
|00004f10| 45 4e 44 02 00 c1 22 fe | ff 06 00 41 50 50 45 4e |END...".|...APPEN|
|00004f20| 44 02 00 c1 23 1d 00 20 | 20 20 20 20 20 20 20 20 |D...#.. | |
|00004f30| 20 20 20 20 20 20 53 51 | 4c 3e 20 41 50 50 45 4e | SQ|L> APPEN|
|00004f40| 44 20 3b 3b 06 00 41 50 | 50 45 4e 44 02 00 c1 24 |D ;;..AP|PEND...$|
|00004f50| fe ff 06 00 41 50 50 45 | 4e 44 02 00 c1 25 48 00 |....APPE|ND...%H.|
|00004f60| 20 20 20 20 20 20 20 20 | 20 20 20 53 51 4c 2a 50 | | SQL*P|
|00004f70| 6c 75 73 20 61 70 70 65 | 6e 64 73 20 74 68 65 20 |lus appe|nds the |
|00004f80| 66 69 72 73 74 20 73 65 | 6d 69 63 6f 6c 6f 6e 20 |first se|micolon |
|00004f90| 74 6f 20 74 68 65 20 6c | 69 6e 65 2e 20 20 54 68 |to the l|ine. Th|
|00004fa0| 65 20 73 65 63 6f 6e 64 | 06 00 41 50 50 45 4e 44 |e second|..APPEND|
|00004fb0| 02 00 c1 26 2c 00 20 20 | 20 20 20 20 20 20 20 20 |...&,. | |
|00004fc0| 20 73 65 6d 69 63 6f 6c | 6f 6e 20 74 65 72 6d 69 | semicol|on termi|
|00004fd0| 6e 61 74 65 73 20 74 68 | 65 20 63 6f 6d 6d 61 6e |nates th|e comman|
|00004fe0| 64 2e 06 00 41 50 50 45 | 4e 44 02 00 c1 27 fe ff |d...APPE|ND...'..|
|00004ff0| 06 00 41 50 50 45 4e 44 | 02 00 c1 28 fe ff 06 00 |..APPEND|...(....|
|00005000| 41 50 50 45 4e 44 02 00 | c1 29 49 00 20 53 65 65 |APPEND..|.)I. See|
|00005010| 20 61 6c 73 6f 3a 20 63 | 68 61 6e 67 65 2c 20 64 | also: c|hange, d|
|00005020| 65 6c 2c 20 65 64 69 74 | 2c 20 69 6e 70 75 74 2c |el, edit|, input,|
|00005030| 20 6c 69 73 74 2c 20 73 | 61 76 65 2c 20 73 65 74 | list, s|ave, set|
|00005040| 20 28 53 51 4c 20 62 75 | 66 66 65 72 29 2c 20 73 | (SQL bu|ffer), s|
|00005050| 70 6f 6f 6c 2c 06 00 41 | 50 50 45 4e 44 02 00 c1 |pool,..A|PPEND...|
|00005060| 2a 1a 00 20 20 20 20 20 | 20 20 20 20 20 20 63 6f |*.. | co|
|00005070| 6d 6d 61 6e 64 73 2c 20 | 6d 65 6e 75 2e 05 00 41 |mmands, |menu...A|
|00005080| 55 44 49 54 02 00 c1 02 | fe ff 05 00 41 55 44 49 |UDIT....|....AUDI|
|00005090| 54 02 00 c1 03 fe ff 05 | 00 41 55 44 49 54 02 00 |T.......|.AUDIT..|
|000050a0| c1 04 28 00 20 20 20 20 | 20 20 20 20 20 20 20 20 |..(. | |
|000050b0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|000050c0| 20 20 20 20 20 20 20 41 | 55 44 49 54 05 00 41 55 | A|UDIT..AU|
|000050d0| 44 49 54 02 00 c1 05 49 | 00 20 20 20 20 20 20 20 |DIT....I|. |
|000050e0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|000050f0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00005100| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00005110| 20 20 20 20 20 53 51 4c | 20 73 74 61 74 65 6d 65 | SQL| stateme|
|00005120| 6e 74 05 00 41 55 44 49 | 54 02 00 c1 06 49 00 20 |nt..AUDI|T....I. |
|00005130| 54 68 65 72 65 20 61 72 | 65 20 74 77 6f 20 77 61 |There ar|e two wa|
|00005140| 79 73 20 74 6f 20 75 73 | 65 20 41 55 44 49 54 3a |ys to us|e AUDIT:|
|00005150| 20 20 6f 6e 65 20 73 65 | 74 73 20 61 75 64 69 74 | one se|ts audit|
|00005160| 69 6e 67 20 6f 70 74 69 | 6f 6e 73 20 66 6f 72 20 |ing opti|ons for |
|00005170| 64 61 74 61 62 61 73 65 | 05 00 41 55 44 49 54 02 |database|..AUDIT.|
|00005180| 00 c1 07 45 00 20 61 63 | 63 65 73 73 2c 20 74 68 |...E. ac|cess, th|
|00005190| 65 20 6f 74 68 65 72 20 | 65 6e 61 62 6c 65 73 20 |e other |enables |
|000051a0| 61 75 64 69 74 69 6e 67 | 20 6f 66 20 61 63 63 65 |auditing| of acce|
|000051b0| 73 73 20 74 6f 20 4f 52 | 41 43 4c 45 20 6f 62 6a |ss to OR|ACLE obj|
|000051c0| 65 63 74 73 20 28 6c 69 | 6b 65 05 00 41 55 44 49 |ects (li|ke..AUDI|
|000051d0| 54 02 00 c1 08 13 00 20 | 74 61 62 6c 65 73 20 61 |T...... |tables a|
|000051e0| 6e 64 20 76 69 65 77 73 | 29 2e 05 00 41 55 44 49 |nd views|)...AUDI|
|000051f0| 54 02 00 c1 09 fe ff 05 | 00 41 55 44 49 54 02 00 |T.......|.AUDIT..|
|00005200| c1 0a 0f 00 20 2a 46 69 | 72 73 74 20 4d 65 74 68 |.... *Fi|rst Meth|
|00005210| 6f 64 2a 05 00 41 55 44 | 49 54 02 00 c1 0b fe ff |od*..AUD|IT......|
|00005220| 05 00 41 55 44 49 54 02 | 00 c1 0c 2d 00 20 41 55 |..AUDIT.|...-. AU|
|00005230| 44 49 54 20 73 79 73 74 | 65 6d 5f 6f 70 74 69 6f |DIT syst|em_optio|
|00005240| 6e 2c 20 73 79 73 74 65 | 6d 5f 6f 70 74 69 6f 6e |n, syste|m_option|
|00005250| 2c 2e 2e 2e 20 7c 20 41 | 4c 4c 05 00 41 55 44 49 |,... | A|LL..AUDI|
|00005260| 54 02 00 c1 0d 17 00 20 | 20 20 20 57 48 45 4e 45 |T...... | WHENE|
|00005270| 56 45 52 20 53 55 43 43 | 45 53 53 46 55 4c 05 00 |VER SUCC|ESSFUL..|
|00005280| 41 55 44 49 54 02 00 c1 | 0e 1b 00 20 20 20 20 57 |AUDIT...|... W|
|00005290| 48 45 4e 45 56 45 52 20 | 4e 4f 54 20 53 55 43 43 |HENEVER |NOT SUCC|
|000052a0| 45 53 53 46 55 4c 05 00 | 41 55 44 49 54 02 00 c1 |ESSFUL..|AUDIT...|
|000052b0| 0f fe ff 05 00 41 55 44 | 49 54 02 00 c1 10 4b 00 |.....AUD|IT....K.|
|000052c0| 20 54 68 65 20 66 69 72 | 73 74 20 6d 65 74 68 6f | The fir|st metho|
|000052d0| 64 20 6f 66 20 41 55 44 | 49 54 20 73 65 74 73 20 |d of AUD|IT sets |
|000052e0| 61 75 64 69 74 69 6e 67 | 20 6f 70 74 69 6f 6e 73 |auditing| options|
|000052f0| 20 66 6f 72 20 64 61 74 | 61 62 61 73 65 20 61 63 | for dat|abase ac|
|00005300| 63 65 73 73 2e 20 20 54 | 68 69 73 05 00 41 55 44 |cess. T|his..AUD|
|00005310| 49 54 02 00 c1 11 13 00 | 20 41 55 44 49 54 20 66 |IT......| AUDIT f|
|00005320| 6f 72 6d 20 74 72 61 63 | 6b 73 3a 05 00 41 55 44 |orm trac|ks:..AUD|
|00005330| 49 54 02 00 c1 12 fe ff | 05 00 41 55 44 49 54 02 |IT......|..AUDIT.|
|00005340| 00 c1 13 37 00 20 20 20 | 20 2d 20 20 63 6f 6e 6e |...7. | - conn|
|00005350| 65 63 74 69 6f 6e 20 74 | 6f 20 6f 72 20 64 69 73 |ection t|o or dis|
|00005360| 63 6f 6e 6e 65 63 74 69 | 6f 6e 20 66 72 6f 6d 20 |connecti|on from |
|00005370| 74 68 65 20 64 61 74 61 | 62 61 73 65 05 00 41 55 |the data|base..AU|
|00005380| 44 49 54 02 00 c1 14 47 | 00 20 20 20 20 2d 20 20 |DIT....G|. - |
|00005390| 73 74 61 74 65 6d 65 6e | 74 73 20 72 65 71 75 69 |statemen|ts requi|
|000053a0| 72 69 6e 67 20 52 45 53 | 4f 55 52 43 45 20 70 72 |ring RES|OURCE pr|
|000053b0| 69 76 69 6c 65 67 65 20 | 28 52 45 53 4f 55 52 43 |ivilege |(RESOURC|
|000053c0| 45 20 73 79 73 74 65 6d | 20 6f 70 74 69 6f 6e 29 |E system| option)|
|000053d0| 05 00 41 55 44 49 54 02 | 00 c1 15 3e 00 20 20 20 |..AUDIT.|...>. |
|000053e0| 20 2d 20 20 73 74 61 74 | 65 6d 65 6e 74 73 20 72 | - stat|ements r|
|000053f0| 65 71 75 69 72 69 6e 67 | 20 44 42 41 20 70 72 69 |equiring| DBA pri|
|00005400| 76 69 6c 65 67 65 73 20 | 28 44 42 41 20 73 79 73 |vileges |(DBA sys|
|00005410| 74 65 6d 20 6f 70 74 69 | 6f 6e 29 05 00 41 55 44 |tem opti|on)..AUD|
|00005420| 49 54 02 00 c1 16 48 00 | 20 20 20 20 2d 20 20 73 |IT....H.| - s|
|00005430| 74 61 74 65 6d 65 6e 74 | 73 20 72 65 74 75 72 6e |tatement|s return|
|00005440| 69 6e 67 20 65 72 72 6f | 72 20 4f 52 41 2d 39 34 |ing erro|r ORA-94|
|00005450| 32 20 22 74 61 62 6c 65 | 20 6f 72 20 76 69 65 77 |2 "table| or view|
|00005460| 20 64 6f 65 73 20 6e 6f | 74 20 65 78 69 73 74 22 | does no|t exist"|
|00005470| 05 00 41 55 44 49 54 02 | 00 c1 17 25 00 20 20 20 |..AUDIT.|...%. |
|00005480| 20 20 20 20 20 20 20 20 | 28 4e 4f 54 20 45 58 49 | |(NOT EXI|
|00005490| 53 54 53 20 73 79 73 74 | 65 6d 20 6f 70 74 69 6f |STS syst|em optio|
|000054a0| 6e 29 05 00 41 55 44 49 | 54 02 00 c1 18 fe ff 05 |n)..AUDI|T.......|
|000054b0| 00 41 55 44 49 54 02 00 | c1 19 4b 00 20 41 75 64 |.AUDIT..|..K. Aud|
|000054c0| 69 74 69 6e 67 20 69 73 | 20 65 6e 61 62 6c 65 64 |iting is| enabled|
|000054d0| 20 73 79 73 74 65 6d 2d | 77 69 64 65 20 76 69 61 | system-|wide via|
|000054e0| 20 74 68 65 20 41 55 44 | 49 54 5f 54 52 41 49 4c | the AUD|IT_TRAIL|
|000054f0| 20 70 61 72 61 6d 65 74 | 65 72 20 6f 66 20 49 4e | paramet|er of IN|
|00005500| 49 54 2e 4f 52 41 2e 05 | 00 41 55 44 49 54 02 00 |IT.ORA..|.AUDIT..|
|00005510| c1 1a 4b 00 20 49 66 20 | 61 75 64 69 74 69 6e 67 |..K. If |auditing|
|00005520| 20 69 73 20 6e 6f 74 20 | 65 6e 61 62 6c 65 64 2c | is not |enabled,|
|00005530| 20 41 55 44 49 54 20 53 | 51 4c 20 73 74 61 74 65 | AUDIT S|QL state|
|00005540| 6d 65 6e 74 73 20 65 78 | 65 63 75 74 65 20 73 75 |ments ex|ecute su|
|00005550| 63 63 65 73 73 66 75 6c | 6c 79 2c 20 62 75 74 05 |ccessful|ly, but.|
|00005560| 00 41 55 44 49 54 02 00 | c1 1b 4a 00 20 6e 6f 20 |.AUDIT..|..J. no |
|00005570| 61 75 64 69 74 20 74 72 | 61 69 6c 20 72 6f 77 73 |audit tr|ail rows|
|00005580| 20 61 72 65 20 77 72 69 | 74 74 65 6e 2e 20 20 41 | are wri|tten. A|
|00005590| 6c 6c 20 61 75 64 69 74 | 20 72 65 73 75 6c 74 73 |ll audit| results|
|000055a0| 20 67 6f 20 74 6f 20 64 | 61 74 61 20 64 69 63 74 | go to d|ata dict|
|000055b0| 69 6f 6e 61 72 79 05 00 | 41 55 44 49 54 02 00 c1 |ionary..|AUDIT...|
|000055c0| 1c 49 00 20 74 61 62 6c | 65 73 2e 20 20 41 73 20 |.I. tabl|es. As |
|000055d0| 61 75 64 69 74 20 64 61 | 74 61 20 64 69 63 74 69 |audit da|ta dicti|
|000055e0| 6f 6e 61 72 79 20 74 61 | 62 6c 65 73 20 67 72 6f |onary ta|bles gro|
|000055f0| 77 2c 20 79 6f 75 20 6d | 61 79 20 61 72 63 68 69 |w, you m|ay archi|
|00005600| 76 65 20 6f 6c 64 20 61 | 75 64 69 74 05 00 41 55 |ve old a|udit..AU|
|00005610| 44 49 54 02 00 c1 1d 49 | 00 20 72 65 63 6f 72 64 |DIT....I|. record|
|00005620| 73 2c 20 74 68 65 6e 20 | 64 65 6c 65 74 65 20 74 |s, then |delete t|
|00005630| 68 65 6d 2e 20 20 4e 65 | 76 65 72 20 64 72 6f 70 |hem. Ne|ver drop|
|00005640| 20 74 68 65 20 61 75 64 | 69 74 20 64 61 74 61 20 | the aud|it data |
|00005650| 64 69 63 74 69 6f 6e 61 | 72 79 20 74 61 62 6c 65 |dictiona|ry table|
|00005660| 73 2e 05 00 41 55 44 49 | 54 02 00 c1 1e fe ff 05 |s...AUDI|T.......|
|00005670| 00 41 55 44 49 54 02 00 | c1 1f 10 00 20 2a 53 65 |.AUDIT..|.... *Se|
|00005680| 63 6f 6e 64 20 4d 65 74 | 68 6f 64 2a 05 00 41 55 |cond Met|hod*..AU|
|00005690| 44 49 54 02 00 c1 20 fe | ff 05 00 41 55 44 49 54 |DIT... .|...AUDIT|
|000056a0| 02 00 c1 21 2b 00 20 41 | 55 44 49 54 20 74 61 62 |...!+. A|UDIT tab|
|000056b0| 6c 65 5f 6f 70 74 69 6f | 6e 2c 20 74 61 62 6c 65 |le_optio|n, table|
|000056c0| 5f 6f 70 74 69 6f 6e 2c | 2e 2e 2e 20 7c 20 41 4c |_option,|... | AL|
|000056d0| 4c 05 00 41 55 44 49 54 | 02 00 c1 22 1b 00 20 20 |L..AUDIT|...".. |
|000056e0| 20 20 4f 4e 20 75 73 65 | 72 2e 74 61 62 6c 65 20 | ON use|r.table |
|000056f0| 7c 20 44 45 46 41 55 4c | 54 05 00 41 55 44 49 54 || DEFAUL|T..AUDIT|
|00005700| 02 00 c1 23 1a 00 20 20 | 20 20 42 59 20 53 45 53 |...#.. | BY SES|
|00005710| 53 49 4f 4e 20 7c 20 42 | 59 20 41 43 43 45 53 53 |SION | B|Y ACCESS|
|00005720| 05 00 41 55 44 49 54 02 | 00 c1 24 31 00 20 20 20 |..AUDIT.|..$1. |
|00005730| 20 57 48 45 4e 45 56 45 | 52 20 53 55 43 43 45 53 | WHENEVE|R SUCCES|
|00005740| 53 46 55 4c 20 7c 20 57 | 48 45 4e 45 56 45 52 20 |SFUL | W|HENEVER |
|00005750| 4e 4f 54 20 53 55 43 43 | 45 53 53 46 55 4c 05 00 |NOT SUCC|ESSFUL..|
|00005760| 41 55 44 49 54 02 00 c1 | 25 fe ff 05 00 41 55 44 |AUDIT...|%....AUD|
|00005770| 49 54 02 00 c1 26 48 00 | 20 54 68 65 20 73 65 63 |IT...&H.| The sec|
|00005780| 6f 6e 64 20 6d 65 74 68 | 6f 64 20 6f 66 20 41 55 |ond meth|od of AU|
|00005790| 44 49 54 20 65 6e 61 62 | 6c 65 73 20 61 75 64 69 |DIT enab|les audi|
|000057a0| 74 69 6e 67 20 6f 66 20 | 61 63 63 65 73 73 20 74 |ting of |access t|
|000057b0| 6f 20 4f 52 41 43 4c 45 | 20 6f 62 6a 65 63 74 73 |o ORACLE| objects|
|000057c0| 05 00 41 55 44 49 54 02 | 00 c1 27 17 00 20 6c 69 |..AUDIT.|..'.. li|
|000057d0| 6b 65 20 74 61 62 6c 65 | 73 20 61 6e 64 20 76 69 |ke table|s and vi|
|000057e0| 65 77 73 2e 05 00 41 55 | 44 49 54 02 00 c1 28 fe |ews...AU|DIT...(.|
|000057f0| ff 05 00 41 55 44 49 54 | 02 00 c1 29 1b 00 20 20 |...AUDIT|...).. |
|00005800| 20 20 42 59 20 53 45 53 | 53 49 4f 4e 20 6f 72 20 | BY SES|SION or |
|00005810| 42 59 20 41 43 43 45 53 | 53 05 00 41 55 44 49 54 |BY ACCES|S..AUDIT|
|00005820| 02 00 c1 2a 48 00 20 20 | 20 20 20 20 20 20 73 70 |...*H. | sp|
|00005830| 65 63 69 66 69 65 73 20 | 68 6f 77 20 72 6f 77 73 |ecifies |how rows|
|00005840| 20 61 72 65 20 77 72 69 | 74 74 65 6e 20 74 6f 20 | are wri|tten to |
|00005850| 74 61 62 6c 65 20 41 55 | 44 49 54 5f 54 52 41 49 |table AU|DIT_TRAI|
|00005860| 4c 2e 20 20 42 59 20 53 | 45 53 53 49 4f 4e 05 00 |L. BY S|ESSION..|
|00005870| 41 55 44 49 54 02 00 c1 | 2b 49 00 20 20 20 20 20 |AUDIT...|+I. |
|00005880| 20 20 20 72 65 63 6f 72 | 64 73 20 74 68 65 20 74 | recor|ds the t|
|00005890| 79 70 65 20 6f 66 20 61 | 63 63 65 73 73 20 6d 61 |ype of a|ccess ma|
|000058a0| 64 65 20 74 6f 20 61 6e | 20 6f 62 6a 65 63 74 20 |de to an| object |
|000058b0| 62 79 20 75 70 64 61 74 | 69 6e 67 20 61 20 73 69 |by updat|ing a si|
|000058c0| 6e 67 6c 65 05 00 41 55 | 44 49 54 02 00 c1 2c 48 |ngle..AU|DIT...,H|
|000058d0| 00 20 20 20 20 20 20 20 | 20 72 6f 77 20 66 6f 72 |. | row for|
|000058e0| 20 74 68 61 74 20 73 65 | 73 73 69 6f 6e 20 69 6e | that se|ssion in|
|000058f0| 20 41 55 44 49 54 5f 54 | 52 41 49 4c 2e 20 20 42 | AUDIT_T|RAIL. B|
|00005900| 59 20 41 43 43 45 53 53 | 20 72 65 63 6f 72 64 73 |Y ACCESS| records|
|00005910| 20 74 68 65 20 74 79 70 | 65 05 00 41 55 44 49 54 | the typ|e..AUDIT|
|00005920| 02 00 c1 2d 47 00 20 20 | 20 20 20 20 20 20 6f 66 |...-G. | of|
|00005930| 20 61 63 63 65 73 73 20 | 6d 61 64 65 20 61 6e 64 | access |made and|
|00005940| 20 68 6f 77 20 6f 66 74 | 65 6e 20 69 74 20 77 61 | how oft|en it wa|
|00005950| 73 20 6d 61 64 65 20 62 | 79 20 69 6e 73 65 72 74 |s made b|y insert|
|00005960| 69 6e 67 20 61 20 6e 65 | 77 20 72 6f 77 05 00 41 |ing a ne|w row..A|
|00005970| 55 44 49 54 02 00 c1 2e | 43 00 20 20 20 20 20 20 |UDIT....|C. |
|00005980| 20 20 69 6e 20 41 55 44 | 49 54 5f 54 52 41 49 4c | in AUD|IT_TRAIL|
|00005990| 20 66 6f 72 20 65 61 63 | 68 20 61 63 63 65 73 73 | for eac|h access|
|000059a0| 2e 20 20 54 68 65 20 64 | 65 66 61 75 6c 74 20 69 |. The d|efault i|
|000059b0| 73 20 42 59 20 53 45 53 | 53 49 4f 4e 2e 05 00 41 |s BY SES|SION...A|
|000059c0| 55 44 49 54 02 00 c1 2f | fe ff 05 00 41 55 44 49 |UDIT.../|....AUDI|
|000059d0| 54 02 00 c1 30 32 00 20 | 20 20 20 57 48 45 4e 45 |T...02. | WHENE|
|000059e0| 56 45 52 20 53 55 43 43 | 45 53 53 46 55 4c 20 6f |VER SUCC|ESSFUL o|
|000059f0| 72 20 57 48 45 4e 45 56 | 45 52 20 4e 4f 54 20 53 |r WHENEV|ER NOT S|
|00005a00| 55 43 43 45 53 53 46 55 | 4c 05 00 41 55 44 49 54 |UCCESSFU|L..AUDIT|
|00005a10| 02 00 c1 31 49 00 20 20 | 20 20 20 20 20 20 73 65 |...1I. | se|
|00005a20| 74 73 20 53 51 4c 20 73 | 74 61 74 65 6d 65 6e 74 |ts SQL s|tatement|
|00005a30| 73 20 74 6f 20 62 65 20 | 61 75 64 69 74 65 64 20 |s to be |audited |
|00005a40| 6f 6e 6c 79 20 77 68 65 | 6e 20 74 68 65 79 20 61 |only whe|n they a|
|00005a50| 72 65 20 73 75 63 63 65 | 73 73 66 75 6c 6c 79 05 |re succe|ssfully.|
|00005a60| 00 41 55 44 49 54 02 00 | c1 32 44 00 20 20 20 20 |.AUDIT..|.2D. |
|00005a70| 20 20 20 20 63 6f 6d 70 | 6c 65 74 65 64 2c 20 6f | comp|leted, o|
|00005a80| 72 20 6f 6e 6c 79 20 77 | 68 65 6e 20 74 68 65 79 |r only w|hen they|
|00005a90| 20 61 72 65 20 6e 6f 74 | 20 73 75 63 63 65 73 73 | are not| success|
|00005aa0| 66 75 6c 6c 79 20 63 6f | 6d 70 6c 65 74 65 64 2e |fully co|mpleted.|
|00005ab0| 05 00 41 55 44 49 54 02 | 00 c1 33 fe ff 05 00 41 |..AUDIT.|..3....A|
|00005ac0| 55 44 49 54 02 00 c1 34 | 23 00 20 53 65 65 20 61 |UDIT...4|#. See a|
|00005ad0| 6c 73 6f 3a 20 6e 6f 61 | 75 64 69 74 2c 20 63 6f |lso: noa|udit, co|
|00005ae0| 6d 6d 61 6e 64 73 2c 20 | 6d 65 6e 75 2e 05 00 41 |mmands, |menu...A|
|00005af0| 6c 69 61 73 02 00 c1 02 | fe ff 05 00 41 6c 69 61 |lias....|....Alia|
|00005b00| 73 02 00 c1 03 fe ff 05 | 00 41 6c 69 61 73 02 00 |s.......|.Alias..|
|00005b10| c1 04 24 00 20 20 20 20 | 20 20 20 20 20 20 20 20 |..$. | |
|00005b20| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00005b30| 20 20 20 41 6c 69 61 73 | 05 00 41 6c 69 61 73 02 | Alias|..Alias.|
|00005b40| 00 c1 05 fe ff 05 00 41 | 6c 69 61 73 02 00 c1 06 |.......A|lias....|
|00005b50| 43 00 20 41 6e 20 61 6c | 69 61 73 20 69 73 20 61 |C. An al|ias is a|
|00005b60| 6e 20 61 6c 74 65 72 6e | 61 74 69 76 65 20 6e 61 |n altern|ative na|
|00005b70| 6d 65 20 66 6f 72 20 61 | 20 63 6f 6c 75 6d 6e 20 |me for a| column |
|00005b80| 6f 72 20 74 61 62 6c 65 | 2c 20 61 63 74 69 76 65 |or table|, active|
|00005b90| 20 6f 6e 6c 79 05 00 41 | 6c 69 61 73 02 00 c1 07 | only..A|lias....|
|00005ba0| 43 00 20 77 69 74 68 69 | 6e 20 74 68 65 20 73 74 |C. withi|n the st|
|00005bb0| 61 74 65 6d 65 6e 74 20 | 69 6e 20 77 68 69 63 68 |atement |in which|
|00005bc0| 20 74 68 65 20 61 6c 69 | 61 73 20 69 73 20 61 73 | the ali|as is as|
|00005bd0| 73 69 67 6e 65 64 2e 20 | 57 68 65 6e 20 61 6e 20 |signed. |When an |
|00005be0| 61 6c 69 61 73 05 00 41 | 6c 69 61 73 02 00 c1 08 |alias..A|lias....|
|00005bf0| 43 00 20 6e 61 6d 65 20 | 66 6f 6c 6c 6f 77 73 20 |C. name |follows |
|00005c00| 74 68 65 20 6e 61 6d 65 | 20 6f 66 20 61 20 63 6f |the name| of a co|
|00005c10| 6c 75 6d 6e 20 69 6e 20 | 61 20 53 45 4c 45 43 54 |lumn in |a SELECT|
|00005c20| 20 6c 69 73 74 2c 20 74 | 68 65 20 61 6c 69 61 73 | list, t|he alias|
|00005c30| 20 6e 61 6d 65 05 00 41 | 6c 69 61 73 02 00 c1 09 | name..A|lias....|
|00005c40| 28 00 20 61 70 70 65 61 | 72 73 20 61 62 6f 76 65 |(. appea|rs above|
|00005c50| 20 74 68 65 20 63 6f 6c | 75 6d 6e 20 69 6e 20 74 | the col|umn in t|
|00005c60| 68 65 20 72 65 70 6f 72 | 74 3a 05 00 41 6c 69 61 |he repor|t:..Alia|
|00005c70| 73 02 00 c1 0a 43 00 20 | 20 20 20 20 20 20 20 20 |s....C. | |
|00005c80| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00005c90| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00005ca0| 20 20 20 20 20 20 4e 41 | 4d 45 20 20 20 20 20 4e | NA|ME N|
|00005cb0| 55 4d 20 20 53 41 4c 41 | 52 59 05 00 41 6c 69 61 |UM SALA|RY..Alia|
|00005cc0| 73 02 00 c1 0b 43 00 20 | 53 45 4c 45 43 54 20 65 |s....C. |SELECT e|
|00005cd0| 6e 61 6d 65 20 4e 41 4d | 45 2c 20 65 6d 70 6e 6f |name NAM|E, empno|
|00005ce0| 20 4e 55 4d 2c 20 73 61 | 6c 20 53 41 4c 41 52 59 | NUM, sa|l SALARY|
|00005cf0| 20 20 20 20 20 20 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d | --|--------|
|00005d00| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 05 00 41 6c 69 61 |--------|--..Alia|
|00005d10| 73 02 00 c1 0c 43 00 20 | 20 20 46 52 4f 4d 20 65 |s....C. | FROM e|
|00005d20| 6d 70 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |mp | |
|00005d30| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00005d40| 20 20 20 20 20 20 41 44 | 41 4d 53 20 20 20 37 38 | AD|AMS 78|
|00005d50| 37 36 20 20 20 20 31 31 | 30 30 05 00 41 6c 69 61 |76 11|00..Alia|
|00005d60| 73 02 00 c1 0d 43 00 20 | 20 20 57 48 45 52 45 20 |s....C. | WHERE |
|00005d70| 6a 6f 62 20 3d 20 27 41 | 4e 41 4c 59 53 54 27 20 |job = 'A|NALYST' |
|00005d80| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00005d90| 20 20 20 20 20 20 4a 41 | 4d 45 53 20 20 20 37 39 | JA|MES 79|
|00005da0| 30 30 20 20 20 20 20 39 | 35 30 05 00 41 6c 69 61 |00 9|50..Alia|
|00005db0| 73 02 00 c1 0e 43 00 20 | 20 20 4f 52 44 45 52 20 |s....C. | ORDER |
|00005dc0| 42 59 20 4e 41 4d 45 3b | 20 20 20 20 20 20 20 20 |BY NAME;| |
|00005dd0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00005de0| 20 20 20 20 20 20 4d 49 | 4c 4c 45 52 20 20 37 39 | MI|LLER 79|
|00005df0| 33 34 20 20 20 20 20 38 | 30 30 05 00 41 6c 69 61 |34 8|00..Alia|
|00005e00| 73 02 00 c1 0f fe ff 05 | 00 41 6c 69 61 73 02 00 |s.......|.Alias..|
|00005e10| c1 10 43 00 20 55 73 65 | 20 61 20 74 61 62 6c 65 |..C. Use| a table|
|00005e20| 20 61 6c 69 61 73 20 74 | 6f 20 6a 6f 69 6e 20 61 | alias t|o join a|
|00005e30| 20 74 61 62 6c 65 20 74 | 6f 20 69 74 73 65 6c 66 | table t|o itself|
|00005e40| 20 69 6e 20 61 20 63 6f | 72 72 65 6c 61 74 65 64 | in a co|rrelated|
|00005e50| 20 71 75 65 72 79 3a 05 | 00 41 6c 69 61 73 02 00 | query:.|.Alias..|
|00005e60| c1 11 fe ff 05 00 41 6c | 69 61 73 02 00 c1 12 2e |......Al|ias.....|
|00005e70| 00 20 53 45 4c 45 43 54 | 20 77 6b 72 2e 65 6e 61 |. SELECT| wkr.ena|
|00005e80| 6d 65 2c 20 77 6b 72 2e | 73 61 6c 2c 20 73 75 70 |me, wkr.|sal, sup|
|00005e90| 2e 65 6e 61 6d 65 2c 20 | 73 75 70 2e 73 61 6c 05 |.ename, |sup.sal.|
|00005ea0| 00 41 6c 69 61 73 02 00 | c1 13 43 00 20 20 20 46 |.Alias..|..C. F|
|00005eb0| 52 4f 4d 20 65 6d 70 20 | 77 6b 72 2c 20 65 6d 70 |ROM emp |wkr, emp|
|00005ec0| 20 73 75 70 20 20 20 20 | 20 20 20 20 20 20 20 20 | sup | |
|00005ed0| 20 20 20 20 20 20 20 20 | 20 45 4e 41 4d 45 20 20 | | ENAME |
|00005ee0| 53 41 4c 20 20 45 4e 41 | 4d 45 20 20 53 41 4c 05 |SAL ENA|ME SAL.|
|00005ef0| 00 41 6c 69 61 73 02 00 | c1 14 43 00 20 20 20 57 |.Alias..|..C. W|
|00005f00| 48 45 52 45 20 77 6b 72 | 2e 6d 67 72 20 3d 20 73 |HERE wkr|.mgr = s|
|00005f10| 75 70 2e 65 6d 70 6e 6f | 20 20 20 20 20 20 20 20 |up.empno| |
|00005f20| 20 20 20 20 20 20 20 20 | 20 2d 2d 2d 2d 2d 2d 2d | | -------|
|00005f30| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 05 |--------|-------.|
|00005f40| 00 41 6c 69 61 73 02 00 | c1 15 43 00 20 20 20 20 |.Alias..|..C. |
|00005f50| 20 41 4e 44 20 77 6b 72 | 2e 73 61 6c 20 3e 20 73 | AND wkr|.sal > s|
|00005f60| 75 70 2e 73 61 6c 3b 20 | 20 20 20 20 20 20 20 20 |up.sal; | |
|00005f70| 20 20 20 20 20 20 20 20 | 20 53 43 4f 54 54 20 33 | | SCOTT 3|
|00005f80| 30 30 30 20 20 4a 4f 4e | 45 53 20 32 39 37 35 05 |000 JON|ES 2975.|
|00005f90| 00 41 6c 69 61 73 02 00 | c1 16 43 00 20 20 20 20 |.Alias..|..C. |
|00005fa0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00005fb0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|00005fc0| 20 20 20 20 20 20 20 20 | 20 46 4f 52 44 20 20 33 | | FORD 3|
|00005fd0| 30 30 30 20 20 4a 4f 4e | 45 53 20 32 39 37 35 05 |000 JON|ES 2975.|
|00005fe0| 00 41 6c 69 61 73 02 00 | c1 17 fe ff 05 00 41 6c |.Alias..|......Al|
|00005ff0| 69 61 73 02 00 c1 18 fe | ff 05 00 41 6c 69 61 73 |ias.....|...Alias|
|00006000| 02 00 c1 19 3d 00 20 53 | 65 65 20 61 6c 73 6f 3a |....=. S|ee also:|
|00006010| 20 73 65 6c 65 63 74 2c | 20 73 65 6c 65 63 74 20 | select,| select |
|00006020| 6c 69 73 74 2c 20 6a 6f | 69 6e 2c 20 63 6f 72 72 |list, jo|in, corr|
|00006030| 65 6c 61 74 65 64 20 71 | 75 65 72 79 2c 20 6d 65 |elated q|uery, me|
|00006040| 6e 75 2e 14 00 41 72 69 | 74 68 6d 65 74 69 63 20 |nu...Ari|thmetic |
|00006050| 4f 70 65 72 61 74 6f 72 | 73 02 00 c1 02 fe ff 14 |Operator|s.......|
|00006060| 00 41 72 69 74 68 6d 65 | 74 69 63 20 4f 70 65 72 |.Arithme|tic Oper|
|00006070| 61 74 6f 72 73 02 00 c1 | 03 fe ff 14 00 41 72 69 |ators...|.....Ari|
|00006080| 74 68 6d 65 74 69 63 20 | 4f 70 65 72 61 74 6f 72 |thmetic |Operator|
|00006090| 73 02 00 c1 04 34 00 20 | 20 20 20 20 20 20 20 20 |s....4. | |
|000060a0| 20 20 20 20 20 20 20 20 | 20 41 72 69 74 68 6d 65 | | Arithme|
|000060b0| 74 69 63 20 61 6e 64 20 | 43 68 61 72 61 63 74 65 |tic and |Characte|
|000060c0| 72 20 4f 70 65 72 61 74 | 6f 72 73 14 00 41 72 69 |r Operat|ors..Ari|
|000060d0| 74 68 6d 65 74 69 63 20 | 4f 70 65 72 61 74 6f 72 |thmetic |Operator|
|000060e0| 73 02 00 c1 05 fe ff 14 | 00 41 72 69 74 68 6d 65 |s.......|.Arithme|
|000060f0| 74 69 63 20 4f 70 65 72 | 61 74 6f 72 73 02 00 c1 |tic Oper|ators...|
|00006100| 06 47 00 20 41 72 69 74 | 68 6d 65 74 69 63 20 6f |.G. Arit|hmetic o|
|00006110| 70 65 72 61 74 6f 72 73 | 20 69 6e 20 53 51 4c 20 |perators| in SQL |
|00006120| 6d 61 6e 69 70 75 6c 61 | 74 65 20 61 6e 64 20 72 |manipula|te and r|
|00006130| 65 74 75 72 6e 20 6e 75 | 6d 65 72 69 63 20 76 61 |eturn nu|meric va|
|00006140| 6c 75 65 73 3b 20 73 6f | 6d 65 14 00 41 72 69 74 |lues; so|me..Arit|
|00006150| 68 6d 65 74 69 63 20 4f | 70 65 72 61 74 6f 72 73 |hmetic O|perators|
|00006160| 02 00 c1 07 1d 00 20 61 | 6c 73 6f 20 68 61 6e 64 |...... a|lso hand|
|00006170| 6c 65 20 64 61 74 65 20 | 61 72 69 74 68 6d 65 74 |le date |arithmet|
|00006180| 69 63 2e 14 00 41 72 69 | 74 68 6d 65 74 69 63 20 |ic...Ari|thmetic |
|00006190| 4f 70 65 72 61 74 6f 72 | 73 02 00 c1 08 fe ff 14 |Operator|s.......|
|000061a0| 00 41 72 69 74 68 6d 65 | 74 69 63 20 4f 70 65 72 |.Arithme|tic Oper|
|000061b0| 61 74 6f 72 73 02 00 c1 | 09 33 00 20 4f 70 65 72 |ators...|.3. Oper|
|000061c0| 61 74 6f 72 20 20 20 46 | 75 6e 63 74 69 6f 6e 20 |ator F|unction |
|000061d0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|000061e0| 20 20 20 20 20 20 20 45 | 78 61 6d 70 6c 65 14 00 | E|xample..|
|000061f0| 41 72 69 74 68 6d 65 74 | 69 63 20 4f 70 65 72 61 |Arithmet|ic Opera|
|00006200| 74 6f 72 73 02 00 c1 0a | 49 00 20 2d 2d 2d 2d 2d |tors....|I. -----|
|00006210| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|00006220| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|00006230| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|00006240| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|00006250| 2d 2d 2d 14 00 41 72 69 | 74 68 6d 65 74 69 63 20 |---..Ari|thmetic |
|00006260| 4f 70 65 72 61 74 6f 72 | 73 02 00 c1 0b 3f 00 20 |Operator|s....?. |
|00006270| 20 20 28 29 20 20 20 20 | 20 20 20 4f 76 65 72 72 | () | Overr|
|00006280| 69 64 65 20 70 72 65 63 | 65 64 65 6e 63 65 20 72 |ide prec|edence r|
|00006290| 75 6c 65 73 20 20 20 20 | 20 20 20 53 45 4c 45 43 |ules | SELEC|
|000062a0| 54 20 28 78 20 2b 20 79 | 29 2f 32 2e 2e 2e 14 00 |T (x + y|)/2.....|
|000062b0| 41 72 69 74 68 6d 65 74 | 69 63 20 4f 70 65 72 61 |Arithmet|ic Opera|
|000062c0| 74 6f 72 73 02 00 c1 0c | 3f 00 20 20 20 2b 20 2d |tors....|?. + -|
|000062d0| 20 20 20 20 20 20 50 6f | 73 69 74 69 76 65 2c 20 | Po|sitive, |
|000062e0| 6e 65 67 61 74 69 76 65 | 20 76 61 6c 75 65 20 20 |negative| value |
|000062f0| 20 20 20 20 20 20 2e 2e | 2e 57 48 45 52 45 20 62 | ..|.WHERE b|
|00006300| 61 6c 20 3c 3d 20 2d 35 | 30 14 00 41 72 69 74 68 |al <= -5|0..Arith|
|00006310| 6d 65 74 69 63 20 4f 70 | 65 72 61 74 6f 72 73 02 |metic Op|erators.|
|00006320| 00 c1 0d 44 00 20 20 20 | 2a 20 2f 20 20 20 20 20 |...D. |* / |
|00006330| 20 4d 75 6c 74 69 70 6c | 79 2c 20 64 69 76 69 64 | Multipl|y, divid|
|00006340| 65 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |e | |
|00006350| 20 53 45 4c 45 43 54 20 | 64 69 73 63 6f 75 6e 74 | SELECT |discount|
|00006360| 20 2a 20 31 30 30 2e 2e | 2e 14 00 41 72 69 74 68 | * 100..|...Arith|
|00006370| 6d 65 74 69 63 20 4f 70 | 65 72 61 74 6f 72 73 02 |metic Op|erators.|
|00006380| 00 c1 0e 46 00 20 20 20 | 2b 20 2d 20 20 20 20 20 |...F. |+ - |
|00006390| 20 41 64 64 2c 20 73 75 | 62 74 72 61 63 74 20 20 | Add, su|btract |
|000063a0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | | |
|000063b0| 20 53 45 4c 45 43 54 20 | 70 72 69 63 65 20 2d 20 | SELECT |price - |
|000063c0| 64 69 73 63 6f 75 6e 74 | 2e 2e 2e 14 00 41 72 69 |discount|.....Ari|
|000063d0| 74 68 6d 65 74 69 63 20 | 4f 70 65 72 61 74 6f 72 |thmetic |Operator|
|000063e0| 73 02 00 c1 0f fe ff 14 | 00 41 72 69 74 68 6d 65 |s.......|.Arithme|
|000063f0| 74 69 63 20 4f 70 65 72 | 61 74 6f 72 73 02 00 c1 |tic Oper|ators...|
+--------+-------------------------+-------------------------+--------+--------+
Only 25.0 KB of data is shown above.
