KeySQL R4.2 R4.2 for MS-Windows 2002 6 J06414-01 Oracle Oracle Oracle Corporation Copyright 2001, Oracle Corporation All Right Reserved
KeySQL R4.2 KeySQL 2 KeySQL R4.2
... 2... 4... 5... 5... 5 KeySQL R4.1... 6... 7 3.X R4.X... 7 2.5 3.X... 10... 12... 17... 19... 19 NCHAR / NVARCHAR2 /... 19... 20 3
Microsoft Windows 95/98/ Windows NT4.0/2000/XP Professional OS Oracle (Net8 ) OS DBMS OS CD-ROM CPU 80486 Microsoft Windows NT4.0/2000/XP Professional Microsoft Windows 95/98 2M 4M KeySQL 2MB KeySQL CD-ROM 4 KeySQL R4.2
Windows Administrator KeySQL R4.2 1. KeySQL R4.2 MAC VBA KeySQL 2. KeySQL 3. KeySQL R4.2 4. KeySQL R4.2 1. MAC 5
KeySQL R4.1 Windows Administrator KeySQL R4.2 Terminal Service MS Windows Terminal Service KeySQL 4000 KeySQL Ctrl-C 6 KeySQL R4.2
3.X R4.X Excel2000 Excel2000 TNSNAME Windows2000 Windows2000 7
HTML HTML CSV CSV SQL KeySQL SQL / 8 KeySQL R4.2
Excel 97 SQL " - - " " "," " Having "(EMP.SAL+EMP.SAL)* 2 > 0" () KeySQL VBA V3.X KeySQL 9
2.5 3.X Excel Excel Excel Excel VBA V2.5 Excel 5.0 Excel VBA KeySQL DDE "SYSTEM" V2.5 Cn = DDEInitiate("KEYSQL","EXECUTE") V3.X Cn = DDEInitiate("KEYSQL","SYSTEM") KeySQL DDE [ ] V2.5 Cn = DDEExecute(Cn,"Fetch()") V3.X Cn = DDEExecute(Cn,"[Fetch()]") SQL "ExecSQL" "KeyExecSQL" V2.5 Cn = DDEExecute(Cn,"ExecSQL(""SQL "",...") V3.X Cn = DDEExecute(Cn,"[KeyExecSQL(""SQL "",...)]") V3.X KeySQL.MAC 10 KeySQL R4.2
11
KeySQL -ct -ct KeySQL -ct1 -ct1 KEYSQL_OBJECT$ KEYSQL_OBJECT$ obj_name obj_owner KeySQL KEYSQL_OBJECT$ -ct2 KEYSQL_OBJECT$ -ct1 o SYS SYSTEM -ct1 KEYSQL_OBJECT$ o SYS SYSTEM SYS SYSTEM WHERE OBJ_OWNER NOT IN ('SYS', 'SYSTEM') 12 KeySQL R4.2
-ct3 SYS SYSTEM 1) SELECT OBJECT_NAME FROM ALL_OBJECTS 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 1) SELECT OBJECT_NAME FROM ALL_OBJECTS 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') 13
-ct4 SYS SYSTEM 1) SELECT OBJECT_NAME FROM ALL_OBJECTS WHERE OWNER!= 'NET_CONF' AND OBJECT_TYPE IN ('TABLE', 'VIEW') 2) SELECT SYNONYM_NAME FROM ALL_SYNONYMS WHERE OWNER!= 'NET_CONF' SYS SYSTEM 1) SELECT OBJECT_NAME FROM ALL_OBJECTS 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') 14 KeySQL R4.2
-ct5 SYS SYSTEM 1) SELECT OBJECT_NAME FROM ALL_OBJECTS WHERE OWNER!= 'NET_CONF' AND OBJECT_TYPE IN ('TABLE', 'VIEW') SYS SYSTEM 1) SELECT OBJECT_NAME FROM ALL_OBJECTS WHERE OWNER NOT IN ('SYS', 'SYSTEM', 'NET_CONF') AND OBJECT_TYPE IN ('TABLE', 'VIEW') -d -d KeySQL Enable KeySQL KEYSQL.LOG -dd -dd DDE 15
-df -df -d -xg -xg -xt -xt 16 KeySQL R4.2
KeySQL SELECT 17
18 KeySQL R4.2
Excel yyyy/m/d KeySQL Excel NCHAR / NVARCHAR2 / 9i NCHAR / NVARCHAR2 / Oracle Net 9.0 8i NCHAR / NVARCHAR2 (ORA-12704 ) 19
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"",,"" "",,)]" 20 KeySQL R4.2