KeySQL for Microsoft Windows 6.0 2006 3 : B28350-01 Copyright 2006, Oracle Corporation All Right Reserved Oracle Oracle Oracle Corporation
KeySQL for Microsoft Windows 6.0 : B28350-01 Copyright 2006, Oracle Corporation. All rights reserved. Printed in Japan. * Oracle Corporation Oracle Corporation Restricted Rights Notice Restricted Rights Notice Programs delivered subject to the DOD FAR Supplement are "commercialcomputer software" and use,duplication, and disclosure of the Programs,including documentation, shall be subject to the licensing restrictions set forth in the applicable Oracle license agreement. Otherwise, Programs delivered subject to the Federal Acquisition Regulations are "restricted computer software" and use, duplication, and disclosure of the Programs shall be subject to the restrictions in FAR 52.227-19, Commercial Computer Software - Restricted Rights (June, 1987). Oracle Corporation, 500 Oracle Parkway, Redwood City, CA 94065. 2 KeySQL for Microsoft Windows 6.0
KeySQL R6. 0 KeySQL 24 365 OTN-J Oracle Technology Network Japan OTN-J http://otn.oracle.co.jp/ KeySQL URL http://www.oracle.co.jp/ 3
... 3... 5... 6... 6... 6 Excel KeySQL... 6 KeySQLAdministrator... 6... 6 KeySQL R5.1... 8... 10 R5.0 R5.1... 10 R4.2 R5.0... 11 3.X R4.X... 11 2.5 3.X... 14 KeySQL R4.2 R5.0 R5.1 R6.0... 16... 17... 18... 18 Excel /... 18 Error 18 Error... 19... 19 4 KeySQL for Microsoft Windows 6.0
Windows 2000 Windows XP Professional (32-bit) Windows Server 2003(32-bit) Oracle9i Client R9.2.0 Oracle Oracle Client (Oracle Net Services) OS OS Microsoft Internet Explorer Version5.5 64M 128M KeySQL 30MB CD-ROM KeySQL CD-ROM 5
Windows Administrator KeySQL R6.0 KeySQL CD CD-ROM CD-ROM Setup.exe 1. KeySQL R6.0 MAC VBA KeySQL 2. KeySQL 3. KeySQL R6.0 4. KeySQL R6.0 1. MAC Excel KeySQL Excel Excel KeySQL KeySQL KeySQL KeySQLAdministrator KeySQL Administrator KeySQL KeySQL Administrator KeySQL PATH KeySQL 6 KeySQL for Microsoft Windows 6.0
7
KeySQL R5.1 KeySQL Administrator KeySQL Oracle EUL KeySQL EUL EUL KeySQL KeySQL KeySQL KeySQL KeySQL KeySQL KeySQL EUL KeySQL SQL EUL EUL KeySQL Administrator KeySQL KeySQL Administrator EUL KeySQL GUI 8 KeySQL for Microsoft Windows 6.0
KeySQL MAC V3.X Excel VBA V3.X KeySQL KeySQL R5.1 9
R5.0 R5.1 Excel KeySQL Excel KeySQL VBA Viewlet KeySQL SQL Oracle 10g NCHAR NVARCHAR ( 1) ( 1 Oracle8i ) 10 KeySQL for Microsoft Windows 6.0
KeySQL MAC V3.X Excel VBA V3.X R4.2 R5.0 Excel2003 Excel2003 TIMESTAMP TIMESTAMP INTERVAL INTERVAL Excel KeySQL Excel Excel KeySQL Excel KeySQL MAC V3.X Excel VBA V3.X 3.X R4.X Excel2000 Excel2000 11
TNSNAME Windows2000 Windows2000 6 Windows Administrator KeySQL R4.2 7 Terminal Service MS Windows Terminal Service HTML HTML CSV CSV 12 KeySQL for Microsoft Windows 6.0
SQL KeySQL SQL / Excel 97 SQL " - - " "," " Having 13
"(EMP.SAL+EMP.SAL)* 2 > 0" () KeySQL 4000 KeySQL Ctrl-C KeySQL VBA V3.X KeySQL 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 "",...)]") 14 KeySQL for Microsoft Windows 6.0
V3.X KeySQL.MAC 15
KeySQL R4.2 R5.0 R5.1 R6.0 R4.2 R5.0 R5.1 R6.0 CHAR VARCHAR2 NCHAR NVARCHAR2 CLOB NCLOB LONG ( ) ( ) NUMBER DATE TIMESTAMP TIMESTAMP WITH TIME ZONE TIMESTAMP WITH LOCAL TIME ZONE INTERVAL YEAR TO MONTH INTERVAL DAY TO SECOND RAW LONG RAW ( ) ( ) BLOB ROWID UROWID BFILE 16 KeySQL for Microsoft Windows 6.0
KeySQL SELECT o 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 S WHERE OWNER!= 'NET_CONF' AND TABLE_OWNER!= 'NET_CONF' AND EXISTS (SELECT B.OBJECT_NAME FROM ALL_OBJECTS B WHERE S.TABLE_NAME = B.OBJECT_NAME AND B.OWNER!= 'NET_CONF' AND B.OBJECT_TYPE IN ('TABLE','VIEW')) o 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 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')) 17
Excel yyyy/m/d KeySQL Excel Excel / / Excel KeySQL Excel UPDATE/DELETE WHERE Error KeySQL Excel EXCEL KeySQL KeySQL ON PEXCEL**.INI KeySQL C: KeySQL PEXCEL97.INI KeySQL PEXCEL**.INI ** Excel Excel2000 PEXCEL2000.INI Excel2002 PEXCEL2002.INI Excel2003 PEXCEL2003.INI 18 KeySQL for Microsoft Windows 6.0
Dde.Client.NeedBusyCheck= On *1 Dde.Client.BusyCheckInterval= 500 *2 Dde.Client.BusyCheckAfterWait= 500 *3 Dde.Client.BusyCheckRetryCount= 200 *4 Dde.Client.BusyCheckCommand=[MESSAGE(FALSE)] *5 *1 *2 ( ) *3 ( ) *4 *5 (*1 *4 ) Error KeySQL Excel Excel 220 220 Excel Internet Explorer Netscape 19
20 KeySQL for Microsoft Windows 6.0