home *** CD-ROM | disk | FTP | other *** search
MacBinary | 1995-06-11 | 5.6 KB | [ TEXT/ALFA]
open in: MacOS 8.1
extracted
|
Win98
extracted
|
DOS
extracted
browse contents |
view JSON data
|
view as text
This file was processed as: MacBinary
(archive/macBinary ).
Confidence Program Detection Match Type Support
10%
dexvert
MacBinary (archive/macBinary)
fallback
Supported
1%
dexvert
Text File (text/txt)
fallback
Supported
100%
file
MacBinary II, inited, Sun Jun 11 23:26:55 1995, modified Sun Jun 11 23:26:55 1995, creator Alpha editor, type ASCII, 5112 bytes "sql.tcl" , at 0x1478 442 bytes resource
default (weak)
99%
file
data
default
74%
TrID
Macintosh plain text (MacBinary)
default
25%
TrID
MacBinary 2
default (weak)
100%
siegfried
fmt/1762 MacBinary (II)
default
100%
lsar
MacBinary
default
id metadata key value macFileType [ TEXT] macFileCreator [ ALFA]
hex view +--------+-------------------------+-------------------------+--------+--------+ |00000000| 00 07 73 71 6c 2e 74 63 | 6c 00 00 00 00 00 00 00 |..sql.tc|l.......| |00000010| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........| |00000020| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........| |00000030| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........| |00000040| 00 54 45 58 54 41 4c 46 | 41 01 00 00 00 00 00 00 |.TEXTALF|A.......| |00000050| 00 00 00 00 00 13 f8 00 | 00 01 ba ac 01 64 7f ac |........|.....d..| |00000060| 01 64 7f 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |.d......|........| |00000070| 00 00 00 00 00 00 00 00 | 00 00 81 81 d4 07 00 00 |........|........| |00000080| 0d 23 23 23 23 23 23 23 | 23 23 23 23 23 23 23 23 |.#######|########| |00000090| 23 23 23 23 23 23 23 23 | 23 23 23 23 23 23 23 23 |########|########| |000000a0| 23 23 23 23 23 23 23 23 | 23 23 23 23 23 23 23 23 |########|########| |000000b0| 23 23 23 23 23 23 23 23 | 23 23 23 23 23 23 23 23 |########|########| |000000c0| 23 23 23 23 23 23 23 23 | 23 23 23 23 23 23 0d 23 |########|######.#| |000000d0| 20 20 20 46 49 4c 45 3a | 20 73 71 6c 2e 74 63 6c | FILE:| sql.tcl| |000000e0| 0d 23 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |.#------|--------| |000000f0| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------| |00000100| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------| |00000110| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------| |00000120| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 0d 23 |--------|------.#| |00000130| 20 41 55 54 48 4f 52 3a | 20 20 20 20 20 4a 6f 65 | AUTHOR:| Joe| |00000140| 6c 20 44 2e 20 45 6c 6b | 69 6e 73 0d 23 20 20 20 |l D. Elk|ins.# | |00000150| 20 20 6f 66 20 20 20 20 | 20 20 4e 65 77 20 4d 65 | of | New Me| |00000160| 64 69 61 2c 20 49 6e 63 | 2e 0d 23 20 20 20 20 20 |dia, Inc|..# | |00000170| 20 20 20 20 20 20 20 20 | 32 30 30 20 53 6f 75 74 | |200 Sout| |00000180| 68 20 4d 65 72 69 64 69 | 61 6e 2c 20 53 74 65 2e |h Meridi|an, Ste.| |00000190| 20 32 32 30 0d 23 20 20 | 20 20 20 20 20 20 20 20 | 220.# | | |000001a0| 20 20 20 49 6e 64 69 61 | 6e 61 70 6f 6c 69 73 2c | India|napolis,| |000001b0| 20 49 4e 20 34 36 32 32 | 35 0d 23 0d 23 20 69 6e | IN 4622|5.#.# in| |000001c0| 74 65 72 6e 65 74 3a 20 | 20 20 6a 64 65 6c 6b 69 |ternet: | jdelki| |000001d0| 6e 73 40 69 71 75 65 73 | 74 2e 6e 65 74 20 20 28 |ns@iques|t.net (| |000001e0| 70 72 65 66 65 72 72 65 | 64 29 0d 23 20 63 6f 6d |preferre|d).# com| |000001f0| 70 75 73 65 72 76 65 3a | 20 37 32 35 33 31 2c 33 |puserve:| 72531,3| |00000200| 31 34 0d 23 20 41 4f 4c | 3a 20 20 20 20 20 20 20 |14.# AOL|: | |00000210| 20 6a 64 65 6c 6b 69 6e | 73 0d 23 0d 23 20 20 20 | jdelkin|s.#.# | |00000220| 43 6f 70 79 72 69 67 68 | 74 20 a9 20 31 39 39 34 |Copyrigh|t . 1994| |00000230| 2d 31 39 39 35 20 62 79 | 20 4a 6f 65 6c 20 44 2e |-1995 by| Joel D.| |00000240| 20 45 6c 6b 69 6e 73 0d | 23 20 20 20 41 6c 6c 20 | Elkins.|# All | |00000250| 72 69 67 68 74 73 20 72 | 65 73 65 72 76 65 64 2e |rights r|eserved.| |00000260| 0d 23 23 23 23 23 23 23 | 23 23 23 23 23 23 23 23 |.#######|########| |00000270| 23 23 23 23 23 23 23 23 | 23 23 23 23 23 23 23 23 |########|########| |00000280| 23 23 23 23 23 23 23 23 | 23 23 23 23 23 23 23 23 |########|########| |00000290| 23 23 23 23 23 23 23 23 | 23 23 23 23 23 23 23 23 |########|########| |000002a0| 23 23 23 23 23 23 23 23 | 23 23 23 23 23 23 0d 23 |########|######.#| |000002b0| 0d 23 20 20 41 6c 70 68 | 61 20 6d 6f 64 65 20 66 |.# Alph|a mode f| |000002c0| 6f 72 20 53 51 4c 20 61 | 6e 64 20 4f 72 61 63 6c |or SQL a|nd Oracl| |000002d0| 65 27 73 20 50 4c 2f 53 | 51 4c 20 70 72 6f 67 72 |e's PL/S|QL progr| |000002e0| 61 6d 6d 69 6e 67 20 6c | 61 6e 67 75 61 67 65 0d |amming l|anguage.| |000002f0| 23 20 20 43 6f 6e 76 65 | 72 74 73 20 53 51 4c 20 |# Conve|rts SQL | |00000300| 61 6e 64 20 50 4c 2f 53 | 51 4c 20 6b 65 79 77 6f |and PL/S|QL keywo| |00000310| 72 64 73 20 74 6f 20 75 | 70 70 65 72 63 61 73 65 |rds to u|ppercase| |00000320| 20 6f 6e 20 74 68 65 20 | 66 6c 79 20 61 6e 64 20 | on the |fly and | |00000330| 63 6f 6c 6f 72 69 7a 65 | 73 0d 23 0d 23 23 23 23 |colorize|s.#.####| |00000340| 23 23 23 23 23 23 23 23 | 23 23 23 23 23 23 23 23 |########|########| |00000350| 23 23 23 23 23 23 23 23 | 23 23 23 23 23 23 23 23 |########|########| |00000360| 23 23 23 23 23 23 23 23 | 23 23 23 23 23 23 23 23 |########|########| |00000370| 23 23 23 23 23 23 23 23 | 23 23 23 23 23 23 23 23 |########|########| |00000380| 23 23 23 23 23 23 23 23 | 23 0d 23 20 48 49 53 54 |########|#.# HIST| |00000390| 4f 52 59 0d 23 20 20 20 | 20 20 20 20 20 20 20 20 |ORY.# | | |000003a0| 20 20 20 20 20 20 20 0d | 23 20 6d 6f 64 69 66 69 | .|# modifi| |000003b0| 65 64 20 77 68 6f 20 72 | 65 76 20 72 65 61 73 6f |ed who r|ev reaso| |000003c0| 6e 0d 23 20 2d 2d 2d 2d | 2d 2d 2d 2d 20 2d 2d 2d |n.# ----|---- ---| |000003d0| 20 2d 2d 2d 20 2d 2d 2d | 2d 2d 2d 20 0d 23 20 37 | --- ---|--- .# 7| |000003e0| 2f 32 39 2f 39 34 20 20 | 4a 44 45 20 31 2e 30 20 |/29/94 |JDE 1.0 | |000003f0| 4f 72 69 67 69 6e 61 6c | 20 0d 23 20 32 2f 38 2f |Original| .# 2/8/| |00000400| 39 35 20 20 20 4a 44 45 | 20 31 2e 31 20 41 64 64 |95 JDE| 1.1 Add| |00000410| 65 64 20 65 6c 65 63 74 | 55 70 70 65 72 20 66 6f |ed elect|Upper fo| |00000420| 72 20 74 61 62 2c 20 63 | 72 2c 20 61 6e 64 20 27 |r tab, c|r, and '| |00000430| 3b 27 0d 23 23 23 23 23 | 23 23 23 23 23 23 23 23 |;'.#####|########| |00000440| 23 23 23 23 23 23 23 23 | 23 23 23 23 23 23 23 23 |########|########| |00000450| 23 23 23 23 23 23 23 23 | 23 23 23 23 23 23 23 23 |########|########| |00000460| 23 23 23 23 23 23 23 23 | 23 23 23 23 23 23 23 23 |########|########| |00000470| 23 23 23 23 23 23 23 23 | 23 23 23 23 23 23 23 23 |########|########| |00000480| 0d 0d 70 72 6f 63 20 64 | 75 6d 6d 79 53 51 4c 20 |..proc d|ummySQL | |00000490| 7b 7d 20 7b 7d 0d 0d 23 | 23 23 23 23 23 23 23 23 |{} {}..#|########| |000004a0| 23 23 23 23 23 23 23 23 | 23 23 23 23 23 23 23 23 |########|########| |000004b0| 23 23 23 23 23 23 23 23 | 23 23 23 23 23 23 23 23 |########|########| |000004c0| 23 23 23 23 23 23 23 23 | 23 23 23 23 23 23 23 23 |########|########| |000004d0| 23 23 23 23 23 23 23 23 | 23 23 23 23 23 23 23 23 |########|########| |000004e0| 23 23 23 23 0d 23 20 50 | 4c 2f 53 51 4c 20 6d 6f |####.# P|L/SQL mo| |000004f0| 64 65 20 62 79 20 4a 6f | 65 6c 20 44 2e 20 45 6c |de by Jo|el D. El| |00000500| 6b 69 6e 73 0d 23 23 23 | 23 23 23 23 23 23 23 23 |kins.###|########| |00000510| 23 23 23 23 23 23 23 23 | 23 23 23 23 23 23 23 23 |########|########| |00000520| 23 23 23 23 23 23 23 23 | 23 23 23 23 23 23 23 23 |########|########| |00000530| 23 23 23 23 23 23 23 23 | 23 23 23 23 23 23 23 23 |########|########| |00000540| 23 23 23 23 23 23 23 23 | 23 23 23 23 23 23 23 23 |########|########| |00000550| 23 23 0d 6c 61 70 70 65 | 6e 64 20 6d 6f 64 65 73 |##.lappe|nd modes| |00000560| 20 53 51 4c 0d 73 65 74 | 20 6d 6f 64 65 4d 65 6e | SQL.set| modeMen| |00000570| 75 73 28 53 51 4c 29 09 | 09 09 09 09 09 7b 20 7d |us(SQL).|.....{ }| |00000580| 0d 73 65 74 20 64 75 6d | 6d 79 50 72 6f 63 28 53 |.set dum|myProc(S| |00000590| 51 4c 29 09 09 09 09 09 | 09 64 75 6d 6d 79 53 51 |QL).....|.dummySQ| |000005a0| 4c 0d 6c 61 70 70 65 6e | 64 20 6d 6f 64 65 53 75 |L.lappen|d modeSu| |000005b0| 66 66 69 78 65 73 09 09 | 09 09 09 7b 2a 2e 73 71 |ffixes..|...{*.sq| |000005c0| 6c 7d 20 7b 20 73 65 74 | 20 77 69 6e 4d 6f 64 65 |l} { set| winMode| |000005d0| 20 53 51 4c 20 7d 0d 6c | 61 70 70 65 6e 64 20 6d | SQL }.l|append m| |000005e0| 6f 64 65 53 75 66 66 69 | 78 65 73 09 09 09 09 09 |odeSuffi|xes.....| |000005f0| 7b 2a 2e 53 51 4c 7d 20 | 7b 20 73 65 74 20 77 69 |{*.SQL} |{ set wi| |00000600| 6e 4d 6f 64 65 20 53 51 | 4c 20 7d 0d 6c 61 70 70 |nMode SQ|L }.lapp| |00000610| 65 6e 64 20 6d 6f 64 65 | 53 75 66 66 69 78 65 73 |end mode|Suffixes| |00000620| 09 09 09 09 09 7b 2a 2e | 70 6b 67 7d 09 7b 20 73 |.....{*.|pkg}.{ s| |00000630| 65 74 20 77 69 6e 4d 6f | 64 65 20 53 51 4c 20 7d |et winMo|de SQL }| |00000640| 0d 6e 65 77 4d 6f 64 65 | 56 61 72 09 53 51 4c 20 |.newMode|Var.SQL | |00000650| 09 65 6c 65 63 52 42 72 | 61 63 65 09 09 09 7b 30 |.elecRBr|ace...{0| |00000660| 7d 09 31 0d 6e 65 77 4d | 6f 64 65 56 61 72 09 53 |}.1.newM|odeVar.S| |00000670| 51 4c 20 09 65 6c 65 63 | 74 72 69 63 53 65 6d 69 |QL .elec|tricSemi| |00000680| 09 09 7b 31 7d 09 31 0d | 6e 65 77 4d 6f 64 65 56 |..{1}.1.|newModeV| |00000690| 61 72 09 53 51 4c 09 09 | 77 6f 72 64 42 72 65 61 |ar.SQL..|wordBrea| |000006a0| 6b 09 09 09 7b 28 5c 24 | 29 3f 5b 61 2d 7a 41 2d |k...{(\$|)?[a-zA-| |000006b0| 5a 30 2d 39 5f 5d 2b 7d | 20 30 0d 6e 65 77 4d 6f |Z0-9_]+}| 0.newMo| |000006c0| 64 65 56 61 72 09 53 51 | 4c 09 09 70 72 65 66 69 |deVar.SQ|L..prefi| |000006d0| 78 53 74 72 69 6e 67 09 | 09 7b 2d 2d 7d 20 30 0d |xString.|.{--} 0.| |000006e0| 6e 65 77 4d 6f 64 65 56 | 61 72 09 53 51 4c 09 09 |newModeV|ar.SQL..| |000006f0| 65 6c 65 63 4c 42 72 61 | 63 65 09 09 09 7b 30 7d |elecLBra|ce...{0}| |00000700| 20 31 0d 6e 65 77 4d 6f | 64 65 56 61 72 09 53 51 | 1.newMo|deVar.SQ| |00000710| 4c 09 09 77 6f 72 64 57 | 72 61 70 09 09 09 7b 30 |L..wordW|rap...{0| |00000720| 7d 20 31 0d 6e 65 77 4d | 6f 64 65 56 61 72 09 53 |} 1.newM|odeVar.S| |00000730| 51 4c 09 09 66 75 6e 63 | 45 78 70 72 09 09 09 7b |QL..func|Expr...{| |00000740| 28 50 52 4f 43 45 44 55 | 52 45 7c 46 55 4e 43 54 |(PROCEDU|RE|FUNCT| |00000750| 49 4f 4e 29 5b 20 5c 74 | 5d 2b 28 5b 61 2d 7a 41 |ION)[ \t|]+([a-zA| |00000760| 2d 5a 30 2d 39 5f 5d 2b | 29 7d 20 30 0d 6e 65 77 |-Z0-9_]+|)} 0.new| |00000770| 4d 6f 64 65 56 61 72 09 | 53 51 4c 09 09 77 6f 72 |ModeVar.|SQL..wor| |00000780| 64 42 72 65 61 6b 50 72 | 65 66 61 63 65 09 7b 5b |dBreakPr|eface.{[| |00000790| 5e 61 2d 7a 41 2d 5a 30 | 2d 39 5f 5c 24 5d 7d 20 |^a-zA-Z0|-9_\$]} | |000007a0| 30 0d 6e 65 77 4d 6f 64 | 65 56 61 72 09 53 51 4c |0.newMod|eVar.SQL| |000007b0| 09 09 6f 70 74 69 6f 6e | 49 73 4d 65 74 61 09 09 |..option|IsMeta..| |000007c0| 7b 30 7d 20 31 0d 0d 73 | 65 74 20 73 71 6c 4b 65 |{0} 1..s|et sqlKe| |000007d0| 79 77 6f 72 64 73 20 7b | 0d 09 41 42 4f 52 54 20 |ywords {|..ABORT | |000007e0| 41 43 43 45 50 54 20 41 | 43 43 45 53 53 20 41 4c |ACCEPT A|CCESS AL| |000007f0| 54 45 52 20 41 4e 44 20 | 41 52 52 41 59 20 41 52 |TER AND |ARRAY AR| |00000800| 52 41 59 4c 45 4e 20 41 | 53 20 41 53 53 45 52 54 |RAYLEN A|S ASSERT| |00000810| 20 41 54 20 41 56 47 20 | 42 45 47 49 4e 20 42 45 | AT AVG |BEGIN BE| |00000820| 54 57 45 45 4e 20 42 4f | 44 59 0d 09 43 41 53 45 |TWEEN BO|DY..CASE| |00000830| 20 43 4f 4c 55 4d 4e 53 | 20 43 4f 4d 4d 49 54 20 | COLUMNS| COMMIT | |00000840| 43 4f 4e 53 54 41 4e 54 | 20 43 4f 55 4e 54 20 43 |CONSTANT| COUNT C| |00000850| 52 45 41 54 45 20 43 55 | 52 53 4f 52 20 44 45 43 |REATE CU|RSOR DEC| |00000860| 4c 41 52 45 20 44 45 46 | 41 55 4c 54 20 44 45 46 |LARE DEF|AULT DEF| |00000870| 49 4e 49 54 49 4f 4e 0d | 09 44 45 4c 45 54 45 20 |INITION.|.DELETE | |00000880| 44 45 53 43 20 44 49 53 | 50 4f 53 45 20 44 49 53 |DESC DIS|POSE DIS| |00000890| 54 49 4e 43 54 20 44 4f | 20 44 52 4f 50 20 45 4c |TINCT DO| DROP EL| |000008a0| 53 45 20 45 4c 53 49 46 | 20 45 4e 44 20 45 4e 54 |SE ELSIF| END ENT| |000008b0| 52 59 20 45 58 43 45 50 | 54 49 4f 4e 20 45 58 49 |RY EXCEP|TION EXI| |000008c0| 53 54 53 20 45 58 49 54 | 0d 09 46 41 4c 53 45 20 |STS EXIT|..FALSE | |000008d0| 46 45 54 43 48 20 46 4f | 52 20 46 52 4f 4d 20 46 |FETCH FO|R FROM F| |000008e0| 55 4e 43 54 49 4f 4e 20 | 47 4f 54 4f 20 49 46 20 |UNCTION |GOTO IF | |000008f0| 49 4e 20 49 4e 53 45 52 | 54 20 49 4e 54 45 52 53 |IN INSER|T INTERS| |00000900| 45 43 54 20 49 4e 54 4f | 20 49 53 20 4c 49 4b 45 |ECT INTO| IS LIKE| |00000910| 20 4c 4f 4f 50 20 4d 41 | 58 20 4d 49 4e 0d 09 4d | LOOP MA|X MIN..M| |00000920| 49 4e 55 53 20 4d 4f 44 | 20 4e 45 57 20 4f 46 20 |INUS MOD| NEW OF | |00000930| 4f 4e 20 4f 50 45 4e 20 | 4f 52 20 4f 55 54 20 50 |ON OPEN |OR OUT P| |00000940| 41 43 4b 41 47 45 20 50 | 41 52 54 49 54 49 4f 4e |ACKAGE P|ARTITION| |00000950| 20 50 4f 53 49 54 49 56 | 45 20 50 52 41 47 4d 41 | POSITIV|E PRAGMA| |00000960| 20 50 52 49 56 41 54 45 | 0d 09 50 52 4f 43 45 44 | PRIVATE|..PROCED| |00000970| 55 52 45 20 50 55 42 4c | 49 43 20 52 41 4e 47 45 |URE PUBL|IC RANGE| |00000980| 20 52 45 43 4f 52 44 20 | 52 45 4d 20 52 45 50 4c | RECORD |REM REPL| |00000990| 41 43 45 20 52 45 54 55 | 52 4e 20 52 4f 4c 4c 42 |ACE RETU|RN ROLLB| |000009a0| 41 43 4b 20 52 4f 57 54 | 59 50 45 20 52 55 4e 20 |ACK ROWT|YPE RUN | |000009b0| 53 41 56 45 50 4f 49 4e | 54 0d 09 53 45 4c 45 43 |SAVEPOIN|T..SELEC| |000009c0| 54 20 53 45 54 20 53 49 | 5a 45 20 53 54 41 52 54 |T SET SI|ZE START| |000009d0| 20 53 54 44 44 45 56 20 | 53 55 4d 20 54 48 45 4e | STDDEV |SUM THEN| |000009e0| 20 54 4f 20 54 59 50 45 | 20 55 4e 49 4f 4e 20 55 | TO TYPE| UNION U| |000009f0| 4e 49 51 55 45 20 55 50 | 44 41 54 45 20 55 53 45 |NIQUE UP|DATE USE| |00000a00| 20 56 41 4c 55 45 53 0d | 09 56 41 52 49 41 4e 43 | VALUES.|.VARIANC| |00000a10| 45 20 57 48 45 4e 20 57 | 48 45 52 45 20 57 48 49 |E WHEN W|HERE WHI| |00000a20| 4c 45 20 57 49 54 48 20 | 58 4f 52 0d 7d 0d 23 23 |LE WITH |XOR.}.##| |00000a30| 23 09 4a 75 73 74 20 63 | 6f 6c 6f 72 69 7a 65 20 |#.Just c|olorize | |00000a40| 75 70 70 65 72 63 61 73 | 65 20 6b 65 79 77 6f 72 |uppercas|e keywor| |00000a50| 64 73 0d 23 09 61 62 6f | 72 74 20 61 63 63 65 70 |ds.#.abo|rt accep| |00000a60| 74 20 61 63 63 65 73 73 | 20 61 6c 74 65 72 20 61 |t access| alter a| |00000a70| 6e 64 20 61 72 72 61 79 | 20 61 72 72 61 79 6c 65 |nd array| arrayle| |00000a80| 6e 20 61 73 20 61 73 73 | 65 72 74 20 61 74 20 61 |n as ass|ert at a| |00000a90| 76 67 20 62 65 67 69 6e | 20 62 65 74 77 65 65 6e |vg begin| between| |00000aa0| 20 62 6f 64 79 0d 23 09 | 63 61 73 65 20 63 6f 6c | body.#.|case col| |00000ab0| 75 6d 6e 73 20 63 6f 6d | 6d 69 74 20 63 6f 6e 73 |umns com|mit cons| |00000ac0| 74 61 6e 74 20 63 6f 75 | 6e 74 20 63 72 65 61 74 |tant cou|nt creat| |00000ad0| 65 20 63 75 72 73 6f 72 | 20 64 65 63 6c 61 72 65 |e cursor| declare| |00000ae0| 20 64 65 66 61 75 6c 74 | 20 64 65 66 69 6e 69 74 | default| definit| |00000af0| 69 6f 6e 0d 23 09 64 65 | 6c 65 74 65 20 64 65 73 |ion.#.de|lete des| |00000b00| 63 20 64 69 73 70 6f 73 | 65 20 64 69 73 74 69 6e |c dispos|e distin| |00000b10| 63 74 20 64 6f 20 64 72 | 6f 70 20 65 6c 73 65 20 |ct do dr|op else | |00000b20| 65 6c 73 69 66 20 65 6e | 64 20 65 6e 74 72 79 20 |elsif en|d entry | |00000b30| 65 78 63 65 70 74 69 6f | 6e 20 65 78 69 73 74 73 |exceptio|n exists| |00000b40| 20 65 78 69 74 0d 23 09 | 66 61 6c 73 65 20 66 65 | exit.#.|false fe| |00000b50| 74 63 68 20 66 6f 72 20 | 66 72 6f 6d 20 66 75 6e |tch for |from fun| |00000b60| 63 74 69 6f 6e 20 67 6f | 74 6f 20 69 66 20 69 6e |ction go|to if in| |00000b70| 20 69 6e 73 65 72 74 20 | 69 6e 74 65 72 73 65 63 | insert |intersec| |00000b80| 74 20 69 6e 74 6f 20 69 | 73 20 6c 69 6b 65 20 6c |t into i|s like l| |00000b90| 6f 6f 70 20 6d 61 78 20 | 6d 69 6e 0d 23 09 6d 69 |oop max |min.#.mi| |00000ba0| 6e 75 73 20 6d 6f 64 20 | 6e 65 77 20 6f 66 20 6f |nus mod |new of o| |00000bb0| 6e 20 6f 70 65 6e 20 6f | 72 20 6f 75 74 20 70 61 |n open o|r out pa| |00000bc0| 63 6b 61 67 65 20 70 61 | 72 74 69 74 69 6f 6e 20 |ckage pa|rtition | |00000bd0| 70 6f 73 69 74 69 76 65 | 20 70 72 61 67 6d 61 20 |positive| pragma | |00000be0| 70 72 69 76 61 74 65 0d | 23 09 70 72 6f 63 65 64 |private.|#.proced| |00000bf0| 75 72 65 20 70 75 62 6c | 69 63 20 72 61 6e 67 65 |ure publ|ic range| |00000c00| 20 72 65 63 6f 72 64 20 | 72 65 6d 20 72 65 70 6c | record |rem repl| |00000c10| 61 63 65 20 72 65 74 75 | 72 6e 20 72 6f 6c 6c 62 |ace retu|rn rollb| |00000c20| 61 63 6b 20 72 6f 77 74 | 79 70 65 20 72 75 6e 20 |ack rowt|ype run | |00000c30| 73 61 76 65 70 6f 69 6e | 74 0d 23 09 73 65 6c 65 |savepoin|t.#.sele| |00000c40| 63 74 20 73 65 74 20 73 | 69 7a 65 20 73 74 61 72 |ct set s|ize star| |00000c50| 74 20 73 74 64 64 65 76 | 20 73 75 6d 20 74 68 65 |t stddev| sum the| |00000c60| 6e 20 74 6f 20 74 79 70 | 65 20 75 6e 69 6f 6e 20 |n to typ|e union | |00000c70| 75 6e 69 71 75 65 20 75 | 70 64 61 74 65 20 75 73 |unique u|pdate us| |00000c80| 65 20 76 61 6c 75 65 73 | 0d 23 09 76 61 72 69 61 |e values|.#.varia| |00000c90| 6e 63 65 20 77 68 65 6e | 20 77 68 65 72 65 20 77 |nce when| where w| |00000ca0| 68 69 6c 65 20 77 69 74 | 68 20 78 6f 72 0d 23 23 |hile wit|h xor.##| |00000cb0| 23 0d 72 65 67 4d 6f 64 | 65 4b 65 79 77 6f 72 64 |#.regMod|eKeyword| |00000cc0| 73 20 2d 65 20 7b 2d 2d | 7d 20 2d 62 20 7b 2f 2a |s -e {--|} -b {/*| |00000cd0| 7d 20 7b 2a 2f 7d 20 2d | 63 20 72 65 64 20 2d 6b |} {*/} -|c red -k| |00000ce0| 20 62 6c 75 65 20 53 51 | 4c 20 24 73 71 6c 4b 65 | blue SQ|L $sqlKe| |00000cf0| 79 77 6f 72 64 73 0d 75 | 6e 73 65 74 20 73 71 6c |ywords.u|nset sql| |00000d00| 4b 65 79 77 6f 72 64 73 | 0d 23 3d 3d 3d 3d 3d 3d |Keywords|.#======| |00000d10| 3d 3d 3d 3d 3d 3d 3d 3d | 3d 3d 3d 3d 3d 3d 3d 3d |========|========| |00000d20| 3d 3d 3d 3d 3d 3d 3d 3d | 3d 3d 3d 3d 3d 3d 3d 3d |========|========| |00000d30| 3d 3d 3d 3d 3d 3d 3d 3d | 3d 3d 3d 3d 3d 3d 3d 3d |========|========| |00000d40| 3d 3d 3d 3d 3d 3d 3d 3d | 3d 3d 3d 3d 3d 3d 3d 3d |========|========| |00000d50| 3d 3d 3d 3d 3d 3d 3d 3d | 3d 3d 0d 0d 63 61 74 63 |========|==..catc| |00000d60| 68 20 7b 75 6e 73 65 74 | 20 70 6c 53 71 6c 4b 65 |h {unset| plSqlKe| |00000d70| 79 77 6f 72 64 73 7d 0d | 0d 6c 61 70 70 65 6e 64 |ywords}.|.lappend| |00000d80| 20 70 6c 53 71 6c 4b 65 | 79 77 6f 72 64 73 20 5c | plSqlKe|ywords \| |00000d90| 0d 09 61 62 6f 72 74 20 | 61 63 63 65 70 74 20 61 |..abort |accept a| |00000da0| 63 63 65 73 73 20 61 6c | 74 65 72 20 61 6e 64 20 |ccess al|ter and | |00000db0| 61 72 72 61 79 20 61 72 | 72 61 79 6c 65 6e 20 61 |array ar|raylen a| |00000dc0| 73 20 61 73 73 65 72 74 | 20 61 74 20 61 76 67 20 |s assert| at avg | |00000dd0| 62 65 67 69 6e 20 62 65 | 74 77 65 65 6e 20 62 6f |begin be|tween bo| |00000de0| 64 79 20 5c 0d 09 63 61 | 73 65 20 63 6f 6c 75 6d |dy \..ca|se colum| |00000df0| 6e 73 20 63 6f 6d 6d 69 | 74 20 63 6f 6e 73 74 61 |ns commi|t consta| |00000e00| 6e 74 20 63 6f 75 6e 74 | 20 63 72 65 61 74 65 20 |nt count| create | |00000e10| 63 75 72 73 6f 72 20 64 | 65 63 6c 61 72 65 20 64 |cursor d|eclare d| |00000e20| 65 66 61 75 6c 74 20 64 | 65 66 69 6e 69 74 69 6f |efault d|efinitio| |00000e30| 6e 20 5c 0d 09 64 65 6c | 65 74 65 20 64 65 73 63 |n \..del|ete desc| |00000e40| 20 64 69 73 70 6f 73 65 | 20 64 69 73 74 69 6e 63 | dispose| distinc| |00000e50| 74 20 64 6f 20 64 72 6f | 70 20 65 6c 73 65 20 65 |t do dro|p else e| |00000e60| 6c 73 69 66 20 65 6e 64 | 20 65 6e 74 72 79 20 65 |lsif end| entry e| |00000e70| 78 63 65 70 74 69 6f 6e | 20 65 78 69 73 74 73 20 |xception| exists | |00000e80| 65 78 69 74 20 5c 0d 09 | 66 61 6c 73 65 20 66 65 |exit \..|false fe| |00000e90| 74 63 68 20 66 6f 72 20 | 66 72 6f 6d 20 66 75 6e |tch for |from fun| |00000ea0| 63 74 69 6f 6e 20 67 6f | 74 6f 20 69 66 20 69 6e |ction go|to if in| |00000eb0| 20 69 6e 73 65 72 74 20 | 69 6e 74 65 72 73 65 63 | insert |intersec| |00000ec0| 74 20 69 6e 74 6f 20 69 | 73 20 6c 69 6b 65 20 6c |t into i|s like l| |00000ed0| 6f 6f 70 20 6d 61 78 20 | 6d 69 6e 20 5c 0d 09 6d |oop max |min \..m| |00000ee0| 69 6e 75 73 20 6d 6f 64 | 20 6e 65 77 20 6f 66 20 |inus mod| new of | |00000ef0| 6f 6e 20 6f 70 65 6e 20 | 6f 72 20 6f 75 74 20 70 |on open |or out p| |00000f00| 61 63 6b 61 67 65 20 70 | 61 72 74 69 74 69 6f 6e |ackage p|artition| |00000f10| 20 70 6f 73 69 74 69 76 | 65 20 70 72 61 67 6d 61 | positiv|e pragma| |00000f20| 20 70 72 69 76 61 74 65 | 20 5c 0d 09 70 72 6f 63 | private| \..proc| |00000f30| 65 64 75 72 65 20 70 75 | 62 6c 69 63 20 72 61 6e |edure pu|blic ran| |00000f40| 67 65 20 72 65 63 6f 72 | 64 20 72 65 6d 20 72 65 |ge recor|d rem re| |00000f50| 70 6c 61 63 65 20 72 65 | 74 75 72 6e 20 72 6f 6c |place re|turn rol| |00000f60| 6c 62 61 63 6b 20 72 6f | 77 74 79 70 65 20 72 75 |lback ro|wtype ru| |00000f70| 6e 20 73 61 76 65 70 6f | 69 6e 74 20 5c 0d 09 73 |n savepo|int \..s| |00000f80| 65 6c 65 63 74 20 73 65 | 74 20 73 69 7a 65 20 73 |elect se|t size s| |00000f90| 74 61 72 74 20 73 74 64 | 64 65 76 20 73 75 6d 20 |tart std|dev sum | |00000fa0| 74 68 65 6e 20 74 6f 20 | 74 79 70 65 20 75 6e 69 |then to |type uni| |00000fb0| 6f 6e 20 75 6e 69 71 75 | 65 20 75 70 64 61 74 65 |on uniqu|e update| |00000fc0| 20 75 73 65 20 76 61 6c | 75 65 73 20 5c 0d 09 76 | use val|ues \..v| |00000fd0| 61 72 69 61 6e 63 65 20 | 77 68 65 6e 20 77 68 65 |ariance |when whe| |00000fe0| 72 65 20 77 68 69 6c 65 | 20 77 69 74 68 20 78 6f |re while| with xo| |00000ff0| 72 0d 0d 0d 70 72 6f 63 | 20 65 6c 65 63 74 55 70 |r...proc| electUp| |00001000| 70 65 72 20 7b 63 68 61 | 72 7d 20 7b 0d 09 67 6c |per {cha|r} {..gl| |00001010| 6f 62 61 6c 20 70 6c 53 | 71 6c 4b 65 79 77 6f 72 |obal plS|qlKeywor| |00001020| 64 73 0d 09 0d 09 73 65 | 74 20 61 20 5b 67 65 74 |ds....se|t a [get| |00001030| 50 6f 73 5d 0d 09 62 61 | 63 6b 77 61 72 64 57 6f |Pos]..ba|ckwardWo| |00001040| 72 64 0d 09 73 65 74 20 | 62 20 5b 67 65 74 50 6f |rd..set |b [getPo| |00001050| 73 5d 0d 09 0d 09 23 6d | 61 6b 65 20 73 75 72 65 |s]....#m|ake sure| |00001060| 20 77 65 27 72 65 20 6e | 6f 74 20 69 6e 20 61 20 | we're n|ot in a | |00001070| 63 6f 6d 6d 65 6e 74 0d | 09 62 65 67 69 6e 6e 69 |comment.|.beginni| |00001080| 6e 67 4f 66 4c 69 6e 65 | 0d 09 73 65 74 20 63 6f |ngOfLine|..set co| |00001090| 6d 6d 65 6e 74 53 65 61 | 72 63 68 20 7b 28 5e 5b |mmentSea|rch {(^[| |000010a0| 20 5c 74 5d 2a 72 65 6d | 5b 20 5c 74 5d 2b 29 7c | \t]*rem|[ \t]+)|| |000010b0| 28 5e 5b 20 5c 74 5d 2a | 52 45 4d 5b 20 5c 74 5d |(^[ \t]*|REM[ \t]| |000010c0| 2b 29 7c 2d 2d 7d 0d 09 | 69 66 20 7b 5b 63 61 74 |+)|--}..|if {[cat| |000010d0| 63 68 20 7b 73 65 61 72 | 63 68 20 2d 72 20 31 20 |ch {sear|ch -r 1 | |000010e0| 2d 66 20 31 20 2d 6c 20 | 24 62 20 2d 2d 20 24 63 |-f 1 -l |$b -- $c| |000010f0| 6f 6d 6d 65 6e 74 53 65 | 61 72 63 68 20 5b 67 65 |ommentSe|arch [ge| |00001100| 74 50 6f 73 5d 7d 5d 20 | 21 3d 20 30 7d 20 7b 0d |tPos]}] |!= 0} {.| |00001110| 09 09 23 69 66 20 6e 6f | 74 2c 20 6d 61 6b 65 20 |..#if no|t, make | |00001120| 74 68 65 20 77 6f 72 64 | 20 75 70 70 65 72 63 61 |the word| upperca| |00001130| 73 65 20 69 66 20 69 74 | 27 73 20 61 20 6b 65 79 |se if it|'s a key| |00001140| 77 6f 72 64 0d 09 09 73 | 65 74 20 63 6d 64 20 5b |word...s|et cmd [| |00001150| 67 65 74 54 65 78 74 20 | 24 62 20 24 61 5d 0d 09 |getText |$b $a]..| |00001160| 09 67 6f 74 6f 20 24 62 | 0d 09 09 69 66 20 7b 5b |.goto $b|...if {[| |00001170| 6c 73 65 61 72 63 68 20 | 2d 65 78 61 63 74 20 24 |lsearch |-exact $| |00001180| 70 6c 53 71 6c 4b 65 79 | 77 6f 72 64 73 20 24 63 |plSqlKey|words $c| |00001190| 6d 64 5d 20 3e 3d 20 30 | 7d 20 7b 0d 09 09 09 75 |md] >= 0|} {....u| |000011a0| 70 63 61 73 65 57 6f 72 | 64 0d 09 09 7d 0d 09 7d |pcaseWor|d...}..}| |000011b0| 0d 09 67 6f 74 6f 20 24 | 61 0d 09 69 66 20 7b 20 |..goto $|a..if { | |000011c0| 30 20 3d 3d 20 5b 73 74 | 72 69 6e 67 20 63 6f 6d |0 == [st|ring com| |000011d0| 70 61 72 65 20 24 63 68 | 61 72 20 22 5c 72 22 5d |pare $ch|ar "\r"]| |000011e0| 20 7d 20 7b 0d 09 09 63 | 61 72 72 69 61 67 65 52 | } {...c|arriageR| |000011f0| 65 74 75 72 6e 0d 09 7d | 20 65 6c 73 65 20 7b 0d |eturn..}| else {.| |00001200| 09 09 69 6e 73 65 72 74 | 54 65 78 74 20 24 63 68 |..insert|Text $ch| |00001210| 61 72 0d 09 7d 0d 7d 0d | 0d 62 69 6e 64 20 27 5c |ar..}.}.|.bind '\| |00001220| 20 27 20 7b 65 6c 65 63 | 74 55 70 70 65 72 20 22 | ' {elec|tUpper "| |00001230| 5c 20 22 7d 20 22 53 51 | 4c 22 0d 62 69 6e 64 20 |\ "} "SQ|L".bind | |00001240| 27 5c 74 27 20 7b 65 6c | 65 63 74 55 70 70 65 72 |'\t' {el|ectUpper| |00001250| 20 22 5c 74 22 7d 20 22 | 53 51 4c 22 0d 62 69 6e | "\t"} "|SQL".bin| |00001260| 64 20 27 5c 72 27 20 7b | 65 6c 65 63 74 55 70 70 |d '\r' {|electUpp| |00001270| 65 72 20 22 5c 72 22 7d | 20 22 53 51 4c 22 0d 62 |er "\r"}| "SQL".b| |00001280| 69 6e 64 20 27 5c 3b 27 | 20 7b 65 6c 65 63 74 55 |ind '\;'| {electU| |00001290| 70 70 65 72 20 22 5c 3b | 22 7d 20 22 53 51 4c 22 |pper "\;|"} "SQL"| |000012a0| 0d 0d 70 72 6f 63 20 53 | 51 4c 4d 61 72 6b 46 69 |..proc S|QLMarkFi| |000012b0| 6c 65 20 7b 7d 20 7b 0d | 09 67 6c 6f 62 61 6c 20 |le {} {.|.global | |000012c0| 53 51 4c 6d 6f 64 65 56 | 61 72 73 0d 09 73 65 74 |SQLmodeV|ars..set| |000012d0| 20 70 6f 73 20 30 0d 09 | 77 68 69 6c 65 20 7b 21 | pos 0..|while {!| |000012e0| 5b 63 61 74 63 68 20 7b | 73 65 61 72 63 68 20 2d |[catch {|search -| |000012f0| 66 20 31 20 2d 72 20 31 | 20 2d 6d 20 30 20 2d 69 |f 1 -r 1| -m 0 -i| |00001300| 20 30 20 24 53 51 4c 6d | 6f 64 65 56 61 72 73 28 | 0 $SQLm|odeVars(| |00001310| 66 75 6e 63 45 78 70 72 | 29 20 24 70 6f 73 7d 20 |funcExpr|) $pos} | |00001320| 72 65 73 5d 7d 20 7b 0d | 09 09 73 65 74 20 73 74 |res]} {.|..set st| |00001330| 61 72 74 20 5b 6c 69 6e | 64 65 78 20 24 72 65 73 |art [lin|dex $res| |00001340| 20 30 5d 0d 09 09 73 65 | 74 20 65 6e 64 20 5b 6c | 0]...se|t end [l| |00001350| 69 6e 64 65 78 20 24 72 | 65 73 20 31 5d 0d 09 09 |index $r|es 1]...| |00001360| 73 65 74 20 74 65 78 74 | 20 5b 6c 69 6e 64 65 78 |set text| [lindex| |00001370| 20 5b 67 65 74 54 65 78 | 74 20 24 73 74 61 72 74 | [getTex|t $start| |00001380| 20 24 65 6e 64 5d 20 31 | 5d 0d 09 09 73 65 74 20 | $end] 1|]...set | |00001390| 70 6f 73 20 24 65 6e 64 | 0d 09 09 73 65 74 20 69 |pos $end|...set i| |000013a0| 6e 64 73 28 24 74 65 78 | 74 29 20 22 24 73 74 61 |nds($tex|t) "$sta| |000013b0| 72 74 20 24 65 6e 64 22 | 0d 09 7d 0d 09 0d 09 69 |rt $end"|..}....i| |000013c0| 66 20 7b 5b 69 6e 66 6f | 20 65 78 69 73 74 73 20 |f {[info| exists | |000013d0| 69 6e 64 73 5d 7d 20 7b | 0d 09 09 66 6f 72 65 61 |inds]} {|...forea| |000013e0| 63 68 20 66 20 5b 6c 73 | 6f 72 74 20 5b 61 72 72 |ch f [ls|ort [arr| |000013f0| 61 79 20 6e 61 6d 65 73 | 20 69 6e 64 73 5d 5d 20 |ay names| inds]] | |00001400| 7b 0d 09 09 09 73 65 74 | 4e 61 6d 65 64 4d 61 72 |{....set|NamedMar| |00001410| 6b 20 24 66 20 5b 6c 69 | 6e 65 53 74 61 72 74 20 |k $f [li|neStart | |00001420| 5b 6c 69 6e 65 53 74 61 | 72 74 20 5b 6c 69 6e 64 |[lineSta|rt [lind| |00001430| 65 78 20 24 69 6e 64 73 | 28 24 66 29 20 30 5d 5d |ex $inds|($f) 0]]| |00001440| 20 2d 20 31 5d 20 5b 6c | 69 6e 64 65 78 20 24 69 | - 1] [l|index $i| |00001450| 6e 64 73 28 24 66 29 20 | 30 5d 20 5b 6c 69 6e 64 |nds($f) |0] [lind| |00001460| 65 78 20 24 69 6e 64 73 | 28 24 66 29 20 31 5d 0d |ex $inds|($f) 1].| |00001470| 09 09 7d 0d 09 7d 0d 7d | 00 00 00 00 00 00 00 00 |..}..}.}|........| |00001480| 00 00 01 00 00 00 01 78 | 00 00 00 78 00 00 00 42 |.......x|...x...B| |00001490| 32 35 39 32 0d 20 48 65 | 61 70 20 7a 6f 6e 65 73 |2592. He|ap zones| |000014a0| 0d 20 20 33 32 20 20 30 | 30 30 30 32 30 30 30 20 |. 32 0|0002000 | |000014b0| 07 73 71 6c 2e 74 63 6c | 02 00 00 00 54 45 58 54 |.sql.tcl|....TEXT| |000014c0| 41 4c 46 41 00 00 00 00 | 00 00 00 00 00 01 06 0c |ALFA....|........| |000014d0| 00 00 54 45 58 54 41 4c | 46 41 00 00 00 00 00 00 |..TEXTAL|FA......| |000014e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........| |000014f0| 00 00 ac 01 2c 3f 00 00 | 13 f8 00 00 01 ba 33 0d |....,?..|......3.| |00001500| 20 20 33 32 20 20 20 30 | 30 31 41 41 45 45 43 20 | 32 0|01AAEEC | |00001510| 74 6f 20 30 30 31 43 44 | 31 43 33 0d 20 20 33 32 |to 001CD|1C3. 32| |00001520| 20 20 20 30 30 32 36 30 | 44 46 43 20 74 6f 20 30 | 00260|DFC to 0| |00001530| 30 32 36 31 39 46 33 0d | 20 20 33 32 20 20 20 30 |02619F3.| 32 0| |00001540| 30 32 36 33 33 35 43 20 | 74 6f 20 30 30 32 36 44 |026335C |to 0026D| |00001550| 30 39 33 0d 20 20 33 32 | 20 20 20 30 30 33 31 36 |093. 32| 00316| |00001560| 45 44 43 20 74 6f 20 30 | 30 33 34 36 33 35 33 0d |EDC to 0|0346353.| |00001570| 20 20 33 32 20 20 30 30 | 39 33 46 35 46 30 20 74 | 32 00|93F5F0 t| |00001580| 00 00 00 28 00 02 00 00 | 04 02 00 00 04 02 09 64 |...(....|.......d| |00001590| 75 6d 6d 79 53 51 4c 00 | 00 00 0f 74 00 00 0f 74 |ummySQL.|...t...t| |000015a0| 0b 65 6c 65 63 74 55 70 | 70 65 72 00 00 00 00 48 |.electUp|per....H| |000015b0| 00 09 4d 6f 6e 61 63 6f | 00 05 af a0 00 00 15 ac |..Monaco|........| |000015c0| 00 fe 3d 1c 01 1c e3 70 | 24 00 04 44 01 60 a7 38 |..=....p|$..D.`.8| |000015d0| 00 24 00 04 00 04 00 28 | 00 02 02 5c 02 00 00 28 |.$.....(|...\...(| |000015e0| 00 02 02 5c 02 00 ac 01 | 2c 41 00 00 00 00 00 00 |...\....|,A......| |000015f0| 00 00 00 00 00 00 01 00 | 00 00 01 00 00 00 01 78 |........|.......x| |00001600| 00 00 00 78 00 00 00 42 | 00 fc b3 68 15 ac 00 00 |...x...B|...h....| |00001610| 00 1c 00 3e 00 00 4d 50 | 53 52 00 01 00 0a 03 ef |...>..MP|SR......| |00001620| 00 00 00 00 00 00 00 00 | 00 00 03 ed ff ff 00 00 |........|........| |00001630| 00 2c 01 05 b9 7c 03 74 | 61 62 00 00 00 00 00 00 |.,...|.t|ab......| |00001640| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........| |00001650| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........| |00001660| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........| |00001670| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........| +--------+-------------------------+-------------------------+--------+--------+