KeySQL for Microsoft Windows 6.0 : B Copyright 2006, Oracle Corporation. All rights reserved. Printed in Japan. * Oracle Corporation Oracle Co

Size: px

Start display at page:

さわさわい
9 years ago
Views:

2 KeySQL for Microsoft Windows 6.0 : B 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 , Commercial Computer Software - Restricted Rights (June, 1987). Oracle Corporation, 500 Oracle Parkway, Redwood City, CA KeySQL for Microsoft Windows 6.0

and disclosure of the Programs,including documentation, shall be subject to the licensing restrictions set forth in the applicable Oracle license agreement.

3 KeySQL R6. 0 KeySQL OTN-J Oracle Technology Network Japan OTN-J KeySQL URL 3

4 Excel KeySQL... 6 KeySQLAdministrator KeySQL R R5.0 R R4.2 R X R4.X X KeySQL R4.2 R5.0 R5.1 R Excel / Error 18 Error KeySQL for Microsoft Windows 6.0

2 R5.0 R5.1 R6.0... 16... 17... 18... 18 Excel /... 18 Error 18 Error.

5 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

6 Windows Administrator KeySQL R6.0 KeySQL CD CD-ROM CD-ROM Setup.exe 1. KeySQL R6.0 MAC VBA KeySQL 2. KeySQL 3. KeySQL R KeySQL R MAC Excel KeySQL Excel Excel KeySQL KeySQL KeySQL KeySQLAdministrator KeySQL Administrator KeySQL KeySQL Administrator KeySQL PATH KeySQL 6 KeySQL for Microsoft Windows 6.0

MAC Excel KeySQL Excel Excel KeySQL KeySQL KeySQL KeySQLAdministrator KeySQL

7 7

8 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

9 KeySQL MAC V3.X Excel VBA V3.X KeySQL KeySQL R5.1 9

10 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

11 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 Excel

12 TNSNAME Windows2000 Windows Windows Administrator KeySQL R4.2 7 Terminal Service MS Windows Terminal Service HTML HTML CSV CSV 12 KeySQL for Microsoft Windows 6.0

13 SQL KeySQL SQL / Excel 97 SQL " - - " "," " Having 13

14 "(EMP.SAL+EMP.SAL)* 2 > 0" () KeySQL 4000 KeySQL Ctrl-C KeySQL VBA V3.X KeySQL 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

X Cn = DDEInitiate("KEYSQL","SYSTEM") KeySQL DDE [ ] V2.5 Cn = DDEExecute(Cn,"Fetch()") V3.

15 V3.X KeySQL.MAC 15

16 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

17 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

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

18 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

INI KeySQL C: KeySQL PEXCEL97.INI KeySQL PEXCEL**.

19 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 Excel Internet Explorer Netscape 19

20 20 KeySQL for Microsoft Windows 6.0

KeySQL R5.1 Release Note

KeySQL R5.1 Release Note KeySQL for Microsoft Windows 5.1 2005 10 : B19176-02 Copyright 2005, Oracle Corporation All Right Reserved Oracle Oracle Oracle Corporation KeySQL for Microsoft Windows 5.1 : B19176-02 Copyright 2005,