📄 otl3_examples.htm
字号:
<!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">Oracle7 / OCI</a><br> </li> <li><span style="font-weight: bold;"><a href="otl4_ora8_examples.htm">Oracle 8,8i / OCI</a> , <a href="otl4_ora8i_unicode_examples.htm">Oracle 8iUnicode/OCI,</a></span></li> <li style="font-weight: bold;"><a href="otl4_ora9_examples.htm">Oracle9i / OCI</a>, <a href="otl4_ora9_unicode_examples.htm">Oracle 9iUnicode /OCI</a> , <a href="otl4_ora9_utf8_examples.htm">Oracle 9i UTF8 /OCI<span style="font-weight: bold;"></span><span style="font-weight: bold;"></span></a> <span style="font-weight: bold;"> </span></li> <li style="font-weight: bold;"><a href="otl4_ora10_examples.htm">Oracle10g / OCI,</a> <a href="otl4_ora10_unicode_examples.htm">Oracle 10gUnicode /OCI</a>, <a href="otl4_ora10_utf8_examples.htm">Oracle 10g UTF8 / OCI</a><br> </li> <li style="font-weight: bold;"><a href="otl4_ora_odbc_unicode_examples.htm">Oracle 8/8i/9i/10g Unicode /ODBC</a><br> </li> <li style="font-weight: bold;"><a href="otl4_db2_examples.htm">DB2/ CLI</a>, <a href="otl4_db2_unicode_examples.htm">DB2 Unicode / CLI</a><br> </li> <li style="font-weight: bold;">MS SQL Server<br> </li> <ul> <li style="font-weight: bold;"><a href="otl4_mssql_examples.htm">MSSQL Server / ODBC</a> </li> <li style="font-weight: bold;"><a href="otl4_mssql_unicode_examples.htm">MSSQL Server Unicode / ODBC</a></li> </ul> <ul> <li style="font-weight: bold;"><a href="otl4_mssql_freetds_examples.htm">MS SQL Server / FreeTDS ODBC</a><br> </li> </ul> <li style="font-weight: bold;"><span style="font-weight: bold;">Sybase</span><br> </li> <ul> <li style="font-weight: bold;"><a href="otl4_sybsql_examples.htm">SybaseSQL Server / ODBC</a>, </li> <li style="font-weight: bold;"><a href="otl4_sybsql_freetds_examples.htm">SybaseSQL Server / FreeTDS ODBC</a></li> </ul> <li style="font-weight: bold;"><a href="otl4_mysql_odbc35_examples.htm">MySQL /MyODBC 3.5, </a><a href="otl4_mysql_odbc25_examples.htm">MySQL /MyODBC 2.5</a>, <br> </li> <li style="font-weight: bold;"><a href="otl4_postgresql_examples.htm">PosgtreSQL / ODBC</a></li> <li style="font-weight: bold;"><a href="otl4_sap_db_examples.htm">MAX-DB/ SAP-DB examples (ODBC)</a></li> <li><span style="font-weight: bold;"><a href="otl4_interbase_examples.htm">FireBird Database / ODBC</a></span></li> <li><span style="font-weight: bold;"><a href="otl4_sqlite_examples.htm">SQLite ODBC</a></span></li> <li><span style="font-weight: bold;"><a href="otl4_t10_examples.htm">TimesTenODBC</a></span></li> <li style="font-weight: bold;"><a href="otl4_msaccess_examples.htm">MicrosoftACCESS ODBC</a></li> <li><span style="font-weight: bold;"><a href="otl4_gen_odbc_examples.htm">GenericODBC</a> (examples for Oracle /ODBC, MS SQL Server / ODBC, etc.)</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 datatypesin 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 viareferenced cursor)</a></b></li> <li> <b><a href="otl3_ex05.htm">Example 5 (Simple Insert/Selectwith the LONG datatype)</a></b></li> <li> <b><a href="otl3_ex06.htm">Example 6 (Simple Insert/Selectwith 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> <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 ("Incompatibledatatypesin 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 viareferenced cursor)</a></b></li> <li> <b><a href="otl3_ex14.htm">Example 14 (Simple Insert/Selectwith the LONG datatype)</a></b></li> <li> <b><a href="otl3_ex15.htm">Example 15 (Simple Insert/Selectwith 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/Selectwith the CLOB datatype)</a></b></li> <li> <b><a href="otl3_ex20.htm">Example 20 (Simple Insert/Selectwith the BLOB datatype)</a></b></li> </ul> <ul> <br> </ul></ul><hr style="width: 100%; height: 2px;"><ul> <ul> </ul> <li> <a name="ora8i_examples"></a><b><font size="+1">Oracle CallInterface 8 (OCI8) for Oracle 8i that requires special treatment</font></b></li> <br> <ul> <li> <b><a href="otl3_ex62.htm">Example 62 (Insert and Select viareferenced 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 CallInterface 8i (OCI8i) with Unicode</font></b></li> <ul> <li> <b><a href="otl4_ex174.htm">Example 174 (Simple UnicodeInsert/Select)</a></b></li> <li> <b><a href="otl4_ex175.htm">Example 175 (Simple UnicodeInsert/Select in the NLS (NVARCHAR2))</a></b></li> <li> <b><a href="otl4_ex176.htm">Example 176 (Unicode Insert andSelect via referenced cursor)</a></b></li> <li> <b><a href="otl4_ex177.htm">Example 177 (Simple UnicodeInsert/Select with LONG)</a></b></li> <li> <b><a href="otl4_ex178.htm">Example 178 (Simple UnicodeInsert/Select with CLOB)</a></b></li> <li> <b><a href="otl4_ex179.htm">Example 179 (Simple UnicodeInsert/Select with NCLOB)</a></b></li> <li> <b><a href="otl4_ex180.htm">Example 180 (Simple UnicodeInsert/Select with CLOB via referenced cursor)</a></b></li> <li> <b><a href="otl4_ex181.htm">Example 181 (Simple UnicodeInsert/Select with NCLOB via referenced cursor)</a></b></li> <li> <b><a href="otl4_ex182.htm">Example 182 (Simple UnicodeInsert/Select with CLOB, and LOB streams)</a></b></li> <li> <b><a href="otl4_ex183.htm">Example 183 (Simple UnicodeInsert/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 CallInterface 9i (OCI9i) with Unicode</font></b></li> <ul> <li> <b><a href="otl4_ex188.htm">Example 188 (SimpleUnicode Insert/Select)</a></b></li> <li> <b><a href="otl4_ex189.htm">Example 189 (Simple UnicodeInsert/Select an the NLS (NVARCHAR2))</a></b></li> <li> <b><a href="otl4_ex190.htm">Example 190 (Unicode Insert andSelect via referenced cursor)</a></b></li> <li> <b><a href="otl4_ex191.htm">Example 191 (Simple UnicodeInsert/Select with LONG)</a></b></li> <li> <b><a href="otl4_ex192.htm">Example 192 (Simple UnicodeInsert/Select with CLOB)</a></b></li> <li> <b><a href="otl4_ex193.htm">Example 193 (Simple UnicodeInsert/Select with NCLOB)</a></b></li> <li> <b><a href="otl4_ex194.htm">Example 194 (Simple UnicodeInsert/Select with CLOB via referenced cursor)</a></b></li> <li> <b><a href="otl4_ex195.htm">Example 195 (Simple UnicodeInsert/Select with NCLOB via referenced cursor)</a></b></li> <li> <b><a href="otl4_ex196.htm">Example 196 (Simple UnicodeInsert/Select with CLOB, and LOB streams)</a></b></li> <li> <b><a href="otl4_ex197.htm">Example 197 (Simple UnicodeInsert/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> <ul> <li> <b><a href="otl3_ex21.htm">Example 21 (Simple Insert/Select)</a></b></li> <li> <b><a href="otl3_ex22.htm">Example 22 ("Incompatibledatatypesin stream operation" exception)</a></b></li> <li> <b><a href="otl3_ex23.htm">Example 23 (Oracle storedprocedurecall)</a></b></li> <li> <b><a href="otl3_ex24.htm">Example 24 (MS SQL Server storedprocedure call)</a></b></li> <li> <b><a href="otl3_ex25.htm">Example 25 (Implicit Select/ResultSet returned by a stored procedure)</a></b></li> <li> <b><a href="otl3_ex26.htm">Example 26 (TIMESTAMP_STRUCT andOracle)</a></b></li> <li> <b><a href="otl3_ex27.htm">Example 27 (TIMESTAMP_STRUCT andMSSQL Server)</a></b></li> <li> <b><a href="otl3_ex28.htm">Example 28 (MS SQL Server and TEXTcolumn)</a></b></li> <li> <b><a href="otl3_ex29.htm">Example 29 (MS SQL Server andIMAGEcolumn)</a></b></li> <li> <b><a href="otl3_ex30.htm">Example 30 (Oracle and LONG column)</a></b></li> <li> <b><a href="otl3_ex31.htm">Example 31 (Oracle and LONG RAWcolumn)</a></b></li> <li> <b><a href="otl3_ex32.htm">Example 32(otl_stream::describe_select() with a simple Select)</a></b></li> <li> <b><a href="otl3_ex33.htm">Example 33 (MS SQL Server:otl_stream::describe_select() and result sets)</a></b></li> <li> <b><a href="otl3_ex34.htm">Example 34 (otl_stream and NULLs)</a></b></li> <br> </ul></ul>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -