1. 1) Microsoft Windows 95/98 Windows NT 4.0 Workstation Windows 2000 Net8 Oracle Net8 R8.0.4 2) CPU 80486 Microsoft Windows NT 4.0 Windows 2000 Microsoft Windows 95/98 2M 4M KeySQL 2MB CD-ROM KeySQL CD-ROM 1
2. KeySQL 1) KeySQL CD-ROM CD-ROM CD-ROM CD-ROM Setup.exe 2) OK 3) 4) Autoexec.bat 3. KeySQL for Windows 4.0 1) i. Excel2000 Excel2000 ii. iii. iv. OS OS TNSNAME 2
v. Windows2000 Windows2000 2) i. SQL ii. " - - " "," " iii. iv. Having v. "(EMP.SAL+EMP.SAL)* 2 > 0" () vi. 3) Excel VBA R4.0 4) HKEY_CURRENT_USER Software TNIK HKEY_CURRENT_USER Software TENIK 3
4. KeySQL for Windows 3.X 1) i. ii. iii. iv. HTML HTML CSV CSV v. vi. vii. SQL KeySQL SQL viii. / ix. x. 4
xi. Excel 97 xii. 2) Excel VBA V3.X 5
5. KeySQL for Windows 2.5 1) Excel Excel Excel 2) Excel VBA V2.5 Excel 5.0 Excel VBA KeySQL DDE "SYSTEM" V2.5 Cn = DDEInitiate("KEYSQL","EXECUTE") R4.0 Cn = DDEInitiate("KEYSQL","SYSTEM") KeySQL DDE [] V2.5 Cn = DDEExecute(Cn,"Fetch()") R4.0 Cn = DDEExecute(Cn,"[Fetch()]") SQL "ExecSQL" "KeyExecSQL" V2.5 Cn = DDEExecute(Cn,"ExecSQL(""SQL "",...") R4.0 Cn = DDEExecute(Cn,"[KeyExecSQL(""SQL "",...)]") R4.0 KeySQL.MAC 3) 4) 5) 6
6. KeySQL 1) -ct -ct KeySQL -ct1 -ct1 KEYSQL_OBJECT$ KEYSQL_OBJECT$ obj_name obj_owner KeySQL KEYSQL_OBJECT$ -ct2 KEYSQL_OBJECT$ -ct1 SYS SYSTEM -ct1 KEYSQL_OBJECT$ SYS SYSTEM SYS SYSTEM 7
-ct3 SYS SYSTEM WHERE OWNER!= 'NET_CONF' AND OBJECT_TYPE IN ('TABLE', 'VIEW') 2) SELECT SYNONYM_NAME FROM ALL_SYNONYMS WHERE OWNER!= 'NET_CONF' AND TABLE_OWNER!= 'NET_CONF' SYS SYSTEM WHERE OWNER NOT IN ('SYS', 'SYSTEM', 'NET_CONF') AND OBJECT_TYPE IN ('TABLE', 'VIEW') 2) SELECT SYNONYM_NAME FROM ALL_SYNONYMS WHERE OWNER NOT IN ('SYS','SYSTEM''NET_CONF') AND TABLE_OWNER NOT IN ('SYS','SYSTEM''NET_CONF') -ct4 SYS SYSTEM WHERE OWNER!= 'NET_CONF' AND OBJECT_TYPE IN ('TABLE', 'VIEW') 2) SELECT SYNONYM_NAME FROM ALL_SYNONYMS WHERE OWNER!= 'NET_CONF' SYS SYSTEM WHERE OWNER NOT IN ('SYS', 'SYSTEM','NET_CONF') AND OBJECT_TYPE IN ('TABLE', 'VIEW') 2) SELECT SYNONYM_NAME FROM ALL_SYNONYMS WHERE OWNER NOT IN ('SYS', 'SYSTEM','NET_CONF') 8
-ct5 SYS SYSTEM WHERE OWNER!= 'NET_CONF' AND OBJECT_TYPE IN ('TABLE', 'VIEW') SYS SYSTEM WHERE OWNER NOT IN ('SYS', 'SYSTEM','NET_CONF') AND OBJECT_TYPE IN ('TABLE', 'VIEW') 2) -d -d KeySQL Enable KeySQL KEYSQL.LOG 3) -dd -dd DDE 4) -df -df -d 5) -xg -xg 6) -xt -xt 9
7. KeySQL SELECT SYS SYSTEM WHERE OWNER!= 'NET_CONF' AND OBJECT_TYPE IN ('TABLE', 'VIEW') 2) SELECT SYNONYM_NAME FROM ALL_SYNONYMS S WHERE OWNER!= 'NET_CONF' AND TABLE_OWNER!= 'NET_CONF' AND EXISTS (SELECT B.OBJECT_NAME FROMALL_OBJECTS B WHERE S.TABLE_NAME =B.OBJECT_NAME AND B.OWNER!= 'NET_CONF' AND B.OBJECT_TYPE IN ('TABLE','VIEW')) SYS SYSTEM WHERE OWNER NOT IN ('SYS', 'SYSTEM', 'NET_CONF') AND OBJECT_TYPE IN ('TABLE', 'VIEW') 2) SELECT SYNONYM_NAME FROM ALL_SYNONYMS S WHERE OWNER NOT IN ('SYS', 'SYSTEM', 'NET_CONF') AND TABLE_OWNER NOT IN ('SYS', 'SYSTEM', 'NET_CONF') AND EXISTS (SELECT B.OBJECT_NAME FROM ALL_OBJECTS B WHERE S.TABLE_NAME = B.OBJECT_NAME AND B.OWNER NOT IN ('SYS', 'SYSTEM', 'NET_CONF') AND B.OBJECT_TYPE IN ('TABLE' 'VIEW')) 8. Excel yyyy/m/d KeySQL Excel 10
9. Excel Excel 97 VBA + Windows95/98 KeySQL DDEExecute 32-1 String Windows95/98 DDE 63 DDEExecute Cn, "[Select(1,""keysqldb.. 1"",,"" "",,)]" 10 20 30 40 50 60 DDEExecute Cn, "[Select(1, ""keysqldb.. 1"",,"" "",,)]" DDEExecute Cn, "[Select(1,""keysqldb.. 1"",,"" "",,)]" 11