Microsoft Word - J doc

Similar documents
Microsoft Word - J doc

Oracle Change Management Pack, Oracle Diagnostics Pack, Oracle Tuning Packインストレーション・ガイド リリース2.2

Oracle8 Workgroup Server for Windows NTインストレーション・ガイド,リリース8.0.6

new_logo.eps

<Documents Title Here>

意外と簡単!?

C3印刷用.PDF

Oracle Enterprise Manager概説 リリース2.2

橡ExCtrlPDF.PDF

Oracle8 Personal Edition for Windows 95/98/NTリリース・ノート, リリース8.0.6

KWCR3.0 instration

Windowsユーザーの為のOracle Database セキュリティ入門

Oracle8i for Windowsリリース・ノート, リリース8.1.7

Oracle Objects for OLE ORAINST.LOG... 4 Oracle Objects for OLE OO4O R LONG/LONG RAW BLOB CLOB B

橡PervasiveSQL2000ReviewersGuide.PDF

rn_des_60j.PDF

<Documents Title Here>

Windows SE RAC 10g 構築手順書

Windows Oracle -Web - Copyright Oracle Corporation Japan, All rights reserved.

Oracle HTML DB 導入ガイド

RN14.PDF

new_logo.eps

Oracle Fail Safe For Windows NT and Windows 2000 リリース・ノート、リリース 3.1.2

Oracleコール・インタフェース for Windows スタート・ガイド リリース8.1.6

Oracle Diagnostics, Tuning, Change Management Pack日本語リリース・ノート, リリース2.2

OM.indd

Oracle Application Server 10g(9

Install.PDF

untitled

Visual Studio Oracle Database 11g アプリケーション開発入門

<Documents Title Here>

Oracle Database Clientクイック・インストレーション・ガイド, 10gリリース1( ) for Microsoft Windows

untitled

Oracle Application Server 10g( )インストール手順書

Oracle Application Server 10g(9

(OnePoint) ( URL Web Copyright 2005 Microsoft Corporation. All rights reserved. Microsoft Windows Visual Basic Visual Studio Microsoft Corporation

Oracle Web Conferencing Oracle Collaboration Suite 2 (9.0.4) Creation Date: May 14, 2003 Last Update: Jan 21, 2005 Version: 1.21

Microsoft Word - 430_15_Developing_Stored_Procedure.doc

Oracle8i Client for Windowsインストレーション・ガイド リリース8.1.7

_02-4.ppt

<Documents Title Here>

<Documents Title Here>

Oracle Developer for Microsoft Windows R6i Patch13 リリース・ノート

untitled

FileMaker Server Getting Started Guide

D1印刷用.PDF

FileMaker Server 9 Getting Started Guide

<Documents Title Here>

intra-mart Web for SellSide ver /03/31 Oracle MS-SQL Server IBM DB2 MS-SQL Server IBM DB2 Client Side JavaScript Server Side JavaScript URL -

BC4J...4 BC4J Association JSP BC4J JSP OC4J

CSV ToDo ToDo

Oracle Lite Tutorial

Oracle Lite Tutorial

(OnePoint) ( URL Web Copyright 2005 Microsoft Corporation. All rights reserved. MicrosoftWindowsVisual Basic Visual Studio Microsoft Corporation

Web Microsoft 2008 R2 Database Database!! Database 04 08

FileMaker ODBC and JDBC Guide

Oracle Identity Managementの概要およびアーキテクチャ

Oracle Database Clientリリース・ノート, 10gリリース1( ) for Microsoft Windows

untitled

Oracle Lite Tutorial

KeySQL R5.1 Release Note

untitled

FileMaker Server Getting Started Guide

Oracle Database 11g × Hitachi Storage Solutionsのベストプラクティス

FileMaker Oracle Microsoft SQL Server MySQL Salesforce.com ROI TCO RAD IT FileMaker Pro RAD RAD TCO RAD Microsoft Visual Studio 2008 Oracle Developer

FileMaker 16 ODBC と JDBC ガイド

ハイウォーターマークを知る

untitled

keysql42_usersguide

FileMaker ODBC と JDBC ガイド

Microsoft Word - J doc

J2EEとMicrosoft.NETの比較

untitled

PowerPoint -O80_REP.PDF

FileMaker Server 8 Administrator’s Guide

FileMaker 15 ODBC と JDBC ガイド

キャラクタ・セットの移行に関するベスト・プラクティス

ORACLEデータベース10G データ・ポンプ: 超高速データ移動ユーティリティの基盤

Faronics Core User Guide

日本オラクル株式会社

Microsoft Windows Hyper-VでのVNXeシステムの使用

untitled

untitled

Oracle Application Server 10g Release 3(10.1.3)- アジャイル・エンタープライズ(俊敏な企業)のためのデータ・アクセス

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

セットアップカード

Oracle9i Application Server for Windows NT/2000 リリース・ノート追加情報 リリース

( ) ID - 2 -

FileMaker Server Getting Started Guide

EMC® RepliStor® for Microsoft Windows バージョン 6.2 SP2インストール・ガイド

実施していただく前に

intra-mart ver /10/31 1. / intra-mart 3.2 AND intra-mart (JavaMail ) ( )

Oracle Database 10g Release 2を使用したデータベース・パフォーマンス

FileMaker ODBC and JDBC Guide

untitled

82801pdf.pqxp

IBM Software Group DB2 Information Management Software DB2 V8 XML SQL/XML 2 XML XML UDF XMLExtender XML XML XMLCollection, XMLColumn XML UDF Informati

TopLink È... 3 TopLink...5 TopLink åø... 6 TopLink å Workbench O/R ~... 8 Workbench À ~... 8 Foundation Library å... 8 TopL

FileMaker Server 9 Getting Started Guide

Oracle9i

Transcription:

SQL*Plus for Windows 8.1.6 2000 5 : J01601-01 : : Oracle Windows Windows NT 4.0 Windows 2000 Windows 95 Windows 98 Windows NT Windows NT 4.0 Windows 2000 Oracle Oracle Oracle Corporation Oracle7 Oracle8i PL/SQL SQL*Plus Oracle Corporation Copyright 2000, Oracle Corporation All Right Reserved

... 3... 4... 4 Document CD-ROM... 4 README... 4... 4 8.1.6... 5 Windows 2000... 8 Windows 95 TCP/IP... 8 Windows Terminal Server... 8... 9 Oracle Universal Installer... 9 FAT NTFS... 12... 12... 12 Oracle Provider for OLE DB R8.1.6.0.0... 14... 14 Microsoft Visual Basic 6.0... 14 Microsoft Visual C++ 6.0... 14 1.... 14 2.... 15 3.... 17 2 SQL*Plus for Windows

8.1.6 Windows 2000 Windows 95 TCP/IP Windows Terminal Server 3

Oracle8i Release 2 Release 2 8.1.6 R8.1.6 Oracle8i URL Document CD-ROM Oracle8i for Windows NT E CD-ROM README %ORACLE_HOME% relnotes README README README README CD 4 SQL*Plus for Windows

8.1.6 Oracle8i Client 8.1.6.0.0 Net8 Products 8.1.6.0.0 Net8 Client 8.1.6.0.0 Oracle Protocol Support 8.1.6.0.0 Oracle TCP/IP Protocol Support 8.1.6.0.0 Oracle Named Pipes Protocol Support 8.1.6.0.0 Oracle SPX/IPX Protocol Support 8.1.6.0.0 Oracle LU6.2 Protocol Support 8.1.6.0.0 *(1) Oracle Utilities 8.1.6.0.0 Oracle Performance Monitor for Windows NT 8.1.6.0.0 *(3) Oracle Database Utilities 8.1.6.0.0 SQL*Plus 8.1.6.0.0 Oracle Java Products 8.1.6.0.0 Oracle JDBC drivers 8.1.6.0.0 Oracle JDBC/OCI Driver for JDK 1.1 8.1.6.0.0 Oracle JDBC/OCI Driver for JDK 1.2 8.1.6.0.0 Oracle JDBC/Thin Driver for JDK 1.1 8.1.6.0.0 Oracle JDBC/Thin Driver for JDK 1.2 8.1.6.0.0 Oracle SQLJ 8.1.6.0.0 Oracle Java Tools 8.1.6.0.0 Oracle Programmer 8.1.6.0.0 Development Tools 8.1.6.0.0 Oracle Call Interface (OCI) 8.1.6.0.0 Object Type Translator 8.1.6.0.0 Oracle Objects for OLE 8.1.6.3.6 Oracle Objects for OLE 8.1.6.3.7 Oracle ODBC Driver 8.1.6.0.0 Oracle Provider for OLE DB 8.1.6.0.0 Pro*C/C++ 8.1.6.0.0 Pro*COBOL 8.1.6.0.0 Pro*COBOL 1.8.51.0. 5

Oracle Enterprise Manager Products 8.1.6.0.0 Oracle Enterprise Manager Client 2.1.0.1.0 Oracle Enterprise Manager Console 2.1.0.1.0 Oracle Enterprise Manager Integrated Applications 2.1.0.0.0 Oracle intermedia Text Manager 2.1.0.0.0 Oracle Enterprise Security Manager 2.0.0.0.0 Oracle Developer Server Forms Manager 2.1.0.0.0 Net8 Integration 8.1.6.0.0 *(4) Oracle Application Server Manager 2.1.0.0.0 *(4) Oracle Parallel Server Manager 2.1.0.0.0 Oracle Replication Manager 2.1.0.0.0 Oracle Spatial Index Advisor 2.1.0.0.0 Beta *(2) Oracle Directory Server Manager 2.0.6.0.0 Oracle Applications Manager 2.1.0.0.0 Oracle Enterprise Manager Migration Assistant 2.1.0.1.0 Oracle DBA Management Pack 2.1.0.1.0 Oracle Schema Manager 2.1.0.0.0 Oracle Storage Manager 2.1.0.0.0 Oracle Security Manager 2.1.0.0.0 Oracle Instance Manager 2.1.0.0.0 SQL*Plus Worksheet 2.1.0.0.0 Oracle DBA Studio 2.1.0.0.0 Oracle Enterprise Manager Quick Tours 2.1.0.0.0 Oracle DBA Management Pack Quick Tour 2.1.0.0.0 Oracle Enterprise Manager Quick Tour 2.1.0.0.0 Oracle Installation Products 8.1.6.0.0 Oracle Universal Installer 1.7.0.19.0 Oracle AppWizards for Microsoft Visual Studio 8.1.6.0.0 Oracle AppWizard for Microsoft Visual C++ 8.1.6.0.0 *(5) Oracle Migration Workbench 1.2.5.0.0 *(1) MS Access Plugin 1.2.5.0.0 *(1) MS SQL Server 6.5 Plugin 1.2.5.0.0 *(1) MS SQL Server 7.0 Plugin 1.2.5.0.0 *(1) Sybase Adaptive Server 11 Plugin 1.2.5.0.0 *(1) 6 SQL*Plus for Windows

Oracle Services for Microsoft Transaction Server 8.1.6.0.0 *(3) Oracle Advanced Security 8.1.6.0.0 Oracle intermedia Client Option 8.1.6.0.0 Oracle Visual Information Retrieval Client 8.1.6.0.0 *(1) Oracle Internet Directory Client 2.0.6.0.0 : SQL*Plus for Windows R8.1.6 *(1) *(2) *(3) Oracle8i Client Windows NT/2000 *(4) Oracle8i Client Windows NT *(5) Microsoft Visual C++ 6.0 7

Windows 2000 SQL*Plus for Windows 8.1.6 Windows 2000 Windows 95 TCP/IP Oracle TCP/IP Protocol Support for Windows 95/98 Windows Sockets 2 Windows 95 SQL*Plus for Windows 8.1.6 Windows Socket 2 Update for Windows 95 Microsoft Web http://www.microsoft.com/windows95/downloads Windows Socket 2 Update for Windows 95 CD-ROM WINSOCK2 WS2SETUP.EXE Windows Socket 2 Update for Windows 95 TCP/IP Web 1.3 http://www.asia.microsoft.com/japan/windows/dun1_3/ Windows 95 Windows Socket 2 Update for Windows 95 TCP/IP 1.3 Oracle8 8.0.3 8.0.4 Oracle TCP/IP Protocol Adapter Windows Sockets 2 8.0.3/8.0.4 Windows Socket 2 Update for Windows 95 8.0.5 Windows Terminal Server Windows NT Terminal Server Edition Windows 2000 Server 8 SQL*Plus for Windows

Oracle Universal Installer PATH 1024 Oracle PATH PATH PATH OK [Ctrl]+[Alt]+[Delete] EXPLORER.EXE CONTROL.EXE PATH OS Loader Last Known Good Menu Windows NT Last Known Good Menu Oracle Oracle Universal Installer (OUI) 1.7.x Windows NT NetWare CD-ROM Windows NT Oracle Universal Installer Java Runtime Environment <location> Oracle Universal Installer Novell JRE_LOCATION 8 9

CD-ROM Windows NT Oracle Universal Installer Windows NT 4.0 SP5 ATI Oracle Universal Installer Windows NT Oracle Universal Installer 2 Oracle8i 1. Oracle8i 8.1.6 2. 2 Oracle Universal Installer 2 Java Runtime Environment JRE 1.1.7.24 Oracle8i 8.1.6 JRE 1.1.7.5 Oracle8i 8.1.5 JRE 1.1.7.24 Oracle8i 8.1.5 Oracle Enterprise Manager 2.0 Oracle8i 8.1.6 Oracle Enterprise Manager 2.1 JRE Oracle Universal Installer 1.1.7.5 Oracle8i 8.1.6 Oracle Enterprise Manager 2.1 JRE 1.1.7.5 JRE 1.1.7.24 SQL*Plus for Windows 10 SQL*Plus for Windows

8.1.6 CD-ROM Oracle Provider for OLE DB COM Oracle 1 Oracle Provider for OLE DB 1 Oracle Provider for OLE DB Oracle Universal Installer Microsoft <filename>.dll.old Oracle Universal Installer <filename>.dll.old <filename>.old msvcrt.dll msvcirt.dll msvcrt40.dll oleaut32.dll olepro32.dll mfc40.dll mfc42u.dll mfc42.dll Novell Client for Windows NT Oracle Universal Installer Windows 95/98 autoexec.bat path Bug#1259693 1. path 11

2. autoexec.bat.old0 %ORACLE_HOME% bin path FAT NTFS FAT NTFS FAT Oracle Universal Installer FAT 32K NTFS 2K Oracle8i Client RAM FAT NTFS 64MB 678MB 236MB 19MB 32MB 164MB 102MB 16MB 32MB 93MB 48MB 16MB README "xxx" 12 SQL*Plus for Windows

EPC-00086 OCI-30120 ORA-29379 ORA-30120 ORA-25212 ORA-25219 ORA-12488 ORA-13443 'xxx' 'xxx' OracleNUMBER xxx xxx 'xxx' 'xxx' Oracle Number PRIORITY xxx.xxx [xxx] 'xxx' 'xxx' Oracle xxx xxx 'xxx' 'xxx' Oracle SEQUENCE_DEVIATION PRIORITY xxx.xxx SEQUENCE_DEVIATION [xxx] 13

Oracle Provider for OLE DB R8.1.6.0.0 : Oracle Provider for OLE DB Windows 95 OraOLEDB COM ORACLE 1 1 OraOLEDB OraOLEDB OraOLEDB Microsoft Visual Basic 6.0 Microsoft ActiveX Data Objects Microsoft ActiveX Data Objects Recordset Microsoft Visual C++ 6.0 VC++.cpp OraOLEDB.h.cpp 1 #define DBINTCONSTANTS 1. 1.1 JOIN ADO ADO Dim objcon As New ADODB.Connection Dim objrst As New ADODB.Recordset objcon.provider = "OraOLEDB.Oracle" objcon.open "db815", "scott", "tiger" 14 SQL*Plus for Windows

objrst.cursorlocation = aduseclient 'ADO Client Cursor objrst.open "select ename, dname " & _ "from emp, dept " & _ "where emp.deptno = dept.deptno", _ objcon, adopenstatic, adlockoptimistic, adcmdtext JOIN CursorLocation aduseclient 1.2 CursorLocation aduseclient Client Cursor ADO LOB /LONG aduseserver 1.3 ADO CacheSize ADO FetchSize ConnectionString Oracle Provider for OLE DB CacheSize FetchSize < 1 FetchSize ADO LOB / INSERT/UPDATE SQL 2. 2.1 LONG LONG RAW ADO AppendChunk ADO AddNew ADO Update LONG LONG RAW 2.2 COMMIT ROLLBACK SAVEPOINT SQL DDL CREATE TABLE ALTER VIEW Oracle DDL DDL 2.3 Oracle EMP emp 2 Oracle Provider for OLE DB R8.1.6.0.0 15

SQL SELECT ename FROM emp EMP SELECT ename FROM "Emp" Emp Oracle 2.4 OraOLEDB /*+... */ --+... 2.5 LEVEL ROWID ROWNUM SQL SYSDATE UID USER SQL 2.6 BFILE BFILE INSERT INTO topomaps (areanum, topomap) VALUES (158, BFILENAME('mapdir', 'topo158.tps')) 2.8 Oracle8i 2.9 PL/SQL PROCEDURE_PARAMETERS PL/SQL / OLE DB / 2.10 LOB UPDATE SomeTable SET LobCol =?WHERE... 16 SQL*Plus for Windows

UPDATE LOB BLOB/CLOBLONG LONG/LONG RAW 2.11 LOB INSERT UPDATE LOB 2.12 Oracle 2.13 ADO GetChunk() ADO LOB LONG rst("lob_column").value ADO 2.14 OLE DB CONNECTIONSTATUS 3. OraOLEDB a. OLE DB 1. 2. HRESULT 3. ID b. 1. 2. ID a. HKEY_LOCAL_MACHINE SOFTWARE ORACLE OLEDB TraceFileName Oracle Provider for OLE DB R8.1.6.0.0 17

TraceFileName TraceOption 0 TraceOption 1 ID TraceOption b. HKEY_LOCAL_MACHINE SOFTWARE ORACLE OLEDB TraceCategory 0 = 1 = OLEDB 2 = OLEDB 4 = TraceCategory TraceCategory 3 c. HKEY_LOCAL_MACHINE SOFTWARE ORACLE OLEDB TraceLevel 0 = 1 = 2 = 4 = 8 = 16 = TraceLevel OLE DB OLE DB 1 OLE DB TraceLevel TraceLevel 12 TraceCategory 3 18 SQL*Plus for Windows

d. HKEY_LOCAL_MACHINE SOFTWARE ORACLE OLEDB TraceOption 0 = 1 = TraceOption ID 1 TraceFileName ID Oracle Provider for OLE DB R8.1.6.0.0 19