⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 otl3_examples.htm

📁 ISO_C++:C++_OTL开发文档
💻 HTM
📖 第 1 页 / 共 3 页
字号:
🔍
123 
<!DOCTYPE doctype PUBLIC "-//w3c//dtd html 4.0 transitional//en">
<html>
<head>
  <meta content="text/html; charset=iso-8859-1"
 http-equiv="Content-Type">
  <meta content="Sergei Kuchin" name="Author">
  <meta content="Mozilla/4.77 [en] (Win95; U) [Netscape]"
 name="GENERATOR">
  <meta
 content="OTL, Oracle, ODBC, DB2, CLI, database API, C++, Template Library"
 name="KeyWords">
  <title>OTL 4.0, Examples</title>
</head>
<body>
<center>
<h1> OTL 4.0, Examples</h1>
</center>
<h1> <a name="otl_examples"></a>Examples <br>
</h1>
<ul>
  <li style="font-weight: bold;">
    <p>Examples by database type</p>
  </li>
  <ul>
    <li style="font-weight: bold;"><a href="otl4_ora7_examples.htm">Oracle
7 / OCI<br>
      </a><br>
    </li>
    <li><span style="font-weight: bold;">Oracle 8/8i<br>
      </span><br>
      <span style="font-weight: bold;"></span></li>
    <ul>
      <li><span style="font-weight: bold;"><a
 href="otl4_ora8_examples.htm">Oracle 8,8i / OCI</a> <br>
        </span></li>
      <li><span style="font-weight: bold;"><a
 href="otl4_ora8i_unicode_examples.htm">Oracle 8i
Unicode/OCI<br>
        <br>
        </a></span></li>
    </ul>
    <li style="font-weight: bold;">Oracle 9i<br>
      <br>
    </li>
    <ul>
      <li style="font-weight: bold;"><a href="otl4_ora9_examples.htm">Oracle
9i / OCI</a></li>
      <li style="font-weight: bold;"><a
 href="otl4_ora9_unicode_examples.htm">Oracle 9i
Unicode /
OCI</a> <br>
      </li>
      <li style="font-weight: bold;"><a
 href="otl4_ora9_utf8_examples.htm">Oracle 9i UTF8 /
OCI<br>
        <br>
        <span style="font-weight: bold;"></span><span
 style="font-weight: bold;"></span></a></li>
    </ul>
    <li style="font-weight: bold;">Oracle 10g<br>
      <br>
    </li>
    <ul>
      <li style="font-weight: bold;"><a href="otl4_ora10_examples.htm">Oracle
10g / OCI</a></li>
      <li style="font-weight: bold;"><a
 href="otl4_ora10_unicode_examples.htm">Oracle 10g
Unicode /
OCI</a></li>
      <li style="font-weight: bold;"><a
 href="otl4_ora10_utf8_examples.htm">Oracle 10g UTF8 / OCI<br>
        </a><br>
      </li>
    </ul>
    <li style="font-weight: bold;"><a
 href="otl4_ora_odbc_unicode_examples.htm">Oracle 8/8i/9i/10g Unicode /
ODBC<br>
      </a><br>
    </li>
    <li style="font-weight: bold;">DB2<br>
      <br>
    </li>
    <ul>
      <li style="font-weight: bold;"><a href="otl4_db2_examples.htm">DB2
/ CLI</a></li>
      <li style="font-weight: bold;"><a
 href="otl4_db2_unicode_examples.htm">DB2 Unicode / CLI<br>
        </a><br>
      </li>
    </ul>
    <li style="font-weight: bold;">MS SQL Server<br>
      <br>
    </li>
    <ul>
      <li style="font-weight: bold;"><a href="otl4_mssql_examples.htm">MS
SQL Server / ODBC</a>&nbsp;</li>
      <li style="font-weight: bold;"><a
 href="otl4_mssql_unicode_examples.htm">MS
SQL Server Unicode / ODBC</a></li>
    </ul>
    <ul>
      <li style="font-weight: bold;"><a
 href="otl4_mssql_freetds_examples.htm">MS SQL Server / FreeTDS ODBC<br>
        </a><br>
      </li>
    </ul>
    <li style="font-weight: bold;"><span style="font-weight: bold;">Sybase<br>
      </span><br>
    </li>
    <ul>
      <li style="font-weight: bold;"><a href="otl4_sybsql_examples.htm">Sybase
SQL Server / ODBC</a>,&nbsp;</li>
      <li style="font-weight: bold;"><a
 href="otl4_sybsql_freetds_examples.htm">Sybase
SQL Server / FreeTDS ODBC<br>
        <br>
        </a></li>
    </ul>
    <li style="font-weight: bold;">MySQL<br>
      <br>
    </li>
    <ul>
      <li style="font-weight: bold;"><a
 href="otl4_mysql_odbc35_examples.htm">MySQL /
MyODBC 3.5,<br>
        </a></li>
      <li style="font-weight: bold;"><a
 href="otl4_mysql_odbc25_examples.htm">MySQL /
MyODBC 2.5</a>, <br>
        <br>
      </li>
    </ul>
    <li style="font-weight: bold;"><a
 href="otl4_postgresql_examples.htm">PosgtreSQL / ODBC</a></li>
    <br>
    <li style="font-weight: bold;"><a href="otl4_edb_examples.htm"><span
 style="text-decoration: underline;">EnterpriseDB / ODBC<br>
      <br>
      </span></a></li>
    <li style="font-weight: bold;"><a href="otl4_inf_examples.htm"><span
 style="text-decoration: underline;">Informix CLI<br>
      <br>
      </span></a></li>
    <li style="font-weight: bold;"><a href="otl4_sap_db_examples.htm">MAX-DB
/ SAP-DB examples (ODBC)<br>
      <br>
      </a></li>
    <li><span style="font-weight: bold;"><a
 href="otl4_interbase_examples.htm">FireBird Database / ODBC<br>
      <br>
      </a></span></li>
    <li><span style="font-weight: bold;"><a
 href="otl4_sqlite_examples.htm">SQLite ODBC<br>
      <br>
      </a></span></li>
    <li><span style="font-weight: bold;"><a href="otl4_t10_examples.htm">TimesTen
ODBC<br>
      <br>
      </a></span></li>
    <li style="font-weight: bold;"><a href="otl4_msaccess_examples.htm">Microsoft
ACCESS ODBC<br>
      <br>
      </a></li>
    <li><span style="font-weight: bold;"><a
 href="otl4_gen_odbc_examples.htm">Generic
ODBC</a> (examples for Oracle /
ODBC, MS SQL Server / ODBC, etc.)<br>
      <br>
      </span></li>
  </ul>
</ul>
<span style="font-weight: bold;"></span>
<hr style="width: 100%; height: 2px;"><span style="font-weight: bold;"></span>
<ul>
  <li> <b><font size="+1">Oracle Call Interface 7 (OCI7</font>)</b></li>
</ul>
<ul>
  <ul>
    <li> <b><a href="otl3_ex01.htm">Example 1 (Simple Insert/Select)</a></b></li>
    <li> <b><a href="otl3_ex02.htm">Example 2 ("Incompatible datatypes
in stream operation" exception)</a></b></li>
    <li> <b><a href="otl3_ex03.htm">Example 3 (PL/SQL block)</a></b></li>
    <li> <b><a href="otl3_ex04.htm">Example 4 (Insert and Select via
referenced cursor)</a></b></li>
    <li> <b><a href="otl3_ex05.htm">Example 5 (Simple Insert/Select
with the LONG datatype)</a></b></li>
    <li> <b><a href="otl3_ex06.htm">Example 6 (Simple Insert/Select
with the LONG RAW datatype)</a></b></li>
    <li> <b><a href="otl3_ex07.htm">Example 7
(otl_stream::describe_select() with a simple Select)</a></b></li>
    <li> <b><a href="otl3_ex08.htm">Example 8 (otl_stream::
describe_select() with a referenced cursor)</a></b></li>
    <li> <b><a href="otl3_ex09.htm">Example 9 (otl_stream and NULLs)</a></b></li>
  </ul>
</ul>
<b><br>
</b>
<hr style="width: 100%; height: 2px;"><b></b>
<ul>
  <li> <b><font size="+1">Oracle Call Interface 8 (OCI8)</font></b></li>
  <br>
&nbsp;
  <ul>
    <li> <b><a href="otl3_ex10.htm">Example 10 (Simple Insert/Select)</a></b></li>
    <li> <b><a href="otl3_ex11.htm">Example 11 ("Incompatible
datatypes
in stream operation" exception)</a></b></li>
    <li> <b><a href="otl3_ex12.htm">Example 12 (PL/SQL block)</a></b></li>
    <li> <b><a href="otl3_ex13.htm">Example 13 (Insert and Select via
referenced cursor)</a></b></li>
    <li> <b><a href="otl3_ex14.htm">Example 14 (Simple Insert/Select
with the LONG datatype)</a></b></li>
    <li> <b><a href="otl3_ex15.htm">Example 15 (Simple Insert/Select
with the LONG RAW datatype)</a></b></li>
    <li> <b><a href="otl3_ex16.htm">Example 16
(otl_stream::describe_select() with a simple Select)</a></b></li>
    <li> <b><a href="otl3_ex17.htm">Example 17
(otl_stream::describe_select() with a referenced cursor)</a></b></li>
    <li> <b><a href="otl3_ex18.htm">Example 18 (otl_stream and NULLs)</a></b></li>
    <li> <b><a href="otl3_ex19.htm">Example 19 (Simple Insert/Select
with the CLOB datatype)</a></b></li>
    <li> <b><a href="otl3_ex20.htm">Example 20 (Simple Insert/Select
with the BLOB datatype)</a></b></li>
  </ul>
  <ul>
&nbsp; <br>
  </ul>
</ul>
<hr style="width: 100%; height: 2px;">
<ul>
  <ul>
&nbsp;
  </ul>
  <li> <a name="ora8i_examples"></a><b><font size="+1">Oracle Call
Interface 8 (OCI8) for Oracle 8i that requires special treatment</font></b></li>
  <br>
&nbsp;
  <ul>
    <li> <b><a href="otl3_ex62.htm">Example 62 (Insert and Select via
referenced cursor for Oracle 8i</a><a href="otl3_ex10.htm">)</a></b></li>
    <li> <b><a href="otl3_ex63.htm">Example 63
(otl_stream::describe_select() with a simple Select for Oracle 8i)</a></b></li>
    <li> <b><a href="otl3_ex64.htm">Example 64
(otl_stream::describe_select() with a referenced cursor for Oracle 8i)</a></b></li>
  </ul>
</ul>
<b><br>
</b>
<hr style="width: 100%; height: 2px;"><b></b>
<ul>
  <li> <a name="OTL_ORA8I_UNICODE"></a><b><font size="+1">Oracle Call
Interface 8i (OCI8i) with Unicode</font></b></li>
  <ul>
&nbsp;
    <li> <b><a href="otl4_ex174.htm">Example 174 (Simple Unicode
Insert/Select)</a></b></li>
    <li> <b><a href="otl4_ex175.htm">Example 175 (Simple Unicode
Insert/Select in the NLS (NVARCHAR2))</a></b></li>
    <li> <b><a href="otl4_ex176.htm">Example 176 (Unicode Insert and
Select via referenced cursor)</a></b></li>
    <li> <b><a href="otl4_ex177.htm">Example 177 (Simple Unicode
Insert/Select with LONG)</a></b></li>
    <li> <b><a href="otl4_ex178.htm">Example 178 (Simple Unicode
Insert/Select with CLOB)</a></b></li>
    <li> <b><a href="otl4_ex179.htm">Example 179 (Simple Unicode
Insert/Select with NCLOB)</a></b></li>
    <li> <b><a href="otl4_ex180.htm">Example 180 (Simple Unicode
Insert/Select with CLOB via referenced cursor)</a></b></li>
    <li> <b><a href="otl4_ex181.htm">Example 181 (Simple Unicode
Insert/Select with NCLOB via referenced cursor)</a></b></li>
    <li> <b><a href="otl4_ex182.htm">Example 182 (Simple Unicode
Insert/Select with CLOB, and LOB streams)</a></b></li>
    <li> <b><a href="otl4_ex183.htm">Example 183 (Simple Unicode
Insert/Select with NCLOB, and LOB streams)</a></b></li>
    <li> <b><a href="otl4_ex184.htm">Example 184 (Unicode, VARCHAR2,
and otl_refcur_stream)</a></b></li>
    <li> <b><a href="otl4_ex185.htm">Example 185 (Unicode, NVARCHAR2,
and otl_refcur_stream)</a></b></li>
    <li> <b><a href="otl4_ex186.htm">Example 186 (Unicode,
PLSQL/index-by tables as parameters)</a></b></li>
    <li> <b><a href="otl4_ex187.htm">Example 187 (Unicode,
PLSQL/index-by tables as parameters, and NVARCHAR2s)</a></b></li>
  </ul>
</ul>
<b><br>
</b>
<hr style="width: 100%; height: 2px;"><b></b>
<ul>
  <li> <a name="OTL_ORA9I_UNICODE"></a><b><font size="+1">Oracle Call
Interface 9i (OCI9i) with Unicode</font></b></li>
  <ul>
&nbsp;
    <li> <b><a href="otl4_ex188.htm">Example 188&nbsp; (Simple
Unicode Insert/Select)</a></b></li>
    <li> <b><a href="otl4_ex189.htm">Example 189 (Simple Unicode
Insert/Select an the NLS (NVARCHAR2))</a></b></li>
    <li> <b><a href="otl4_ex190.htm">Example 190 (Unicode Insert and
Select via referenced cursor)</a></b></li>
    <li> <b><a href="otl4_ex191.htm">Example 191 (Simple Unicode
Insert/Select with LONG)</a></b></li>
    <li> <b><a href="otl4_ex192.htm">Example 192 (Simple Unicode
Insert/Select with CLOB)</a></b></li>
    <li> <b><a href="otl4_ex193.htm">Example 193 (Simple Unicode
Insert/Select with NCLOB)</a></b></li>
    <li> <b><a href="otl4_ex194.htm">Example 194 (Simple Unicode
Insert/Select with CLOB via referenced cursor)</a></b></li>
    <li> <b><a href="otl4_ex195.htm">Example 195 (Simple Unicode
Insert/Select with NCLOB via referenced cursor)</a></b></li>
    <li> <b><a href="otl4_ex196.htm">Example 196 (Simple Unicode
Insert/Select with CLOB, and LOB streams)</a></b></li>
    <li> <b><a href="otl4_ex197.htm">Example 197 (Simple Unicode
Insert/Select with NCLOB, and LOB streams)</a></b></li>
    <li> <b><a href="otl4_ex198.htm">Example 198 (Unicode, VARCHAR2,
and otl_refcur_stream)</a></b></li>
    <li> <b><a href="otl4_ex199.htm">Example 199 (Unicode, NVARCHAR2,
and otl_refcur_stream)</a></b></li>
    <li> <b><a href="otl4_ex200.htm">Example 200 (Unicode,
PLSQL/index-by tables as parameters)</a></b></li>
    <li> <b><a href="otl4_ex201.htm">Example 201 (Unicode,
PLSQL/index-by tables as parameters, and NVARCHAR2s)</a></b></li>
  </ul>
</ul>
<b><br>
</b>
<hr style="width: 100%; height: 2px;"><b></b>
<ul>
  <li> <b><font size="+1">Open DataBase Connectivity (ODBC)</font></b></li>
  <br>
123

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -