📄 oci8.datatypes.html
字号:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"><html> <head> <title>Supported Datatypes</title> <meta http-equiv="content-type" content="text/html; charset=UTF-8"> </head> <body><div style="text-align: center;"> <div class="prev" style="text-align: left; float: left;"><a href="oci8.connection.html">Connecting Handling</a></div> <div class="next" style="text-align: right; float: right;"><a href="ref.oci8.html">OCI8 Functions</a></div> <div class="up"><a href="book.oci8.html">OCI8</a></div> <div class="home"><a href="index.html">PHP Manual</a></div></div><hr /><div> <h1>Supported Datatypes</h1> <table border="5"> <caption><b>The driver supports the following types when binding parameters using <a href="function.oci-bind-by-name.html" class="function">oci_bind_by_name()</a> function:</b></caption> <colgroup> <thead valign="middle"> <tr valign="middle"> <th colspan="1">Type</th> <th colspan="1">Mapping</th> </tr> </thead> <tbody valign="middle" class="tbody"> <tr valign="middle"> <td colspan="1" rowspan="1" align="left">SQLT_NTY</td> <td colspan="1" rowspan="1" align="left">Maps a native collection type from a PHP collection object, such as those created by <a href="function.oci-new-collection.html" class="function">oci_new_collection()</a>.</td> </tr> <tr valign="middle"> <td colspan="1" rowspan="1" align="left">SQLT_BFILEE</td> <td colspan="1" rowspan="1" align="left">Maps a native descriptor, such as those created by <a href="function.oci-new-descriptor.html" class="function">oci_new_descriptor()</a>.</td> </tr> <tr valign="middle"> <td colspan="1" rowspan="1" align="left">SQLT_CFILEE</td> <td colspan="1" rowspan="1" align="left">Maps a native descriptor, such as those created by <a href="function.oci-new-descriptor.html" class="function">oci_new_descriptor()</a>.</td> </tr> <tr valign="middle"> <td colspan="1" rowspan="1" align="left">SQLT_CLOB</td> <td colspan="1" rowspan="1" align="left">Maps a native descriptor, such as those created by <a href="function.oci-new-descriptor.html" class="function">oci_new_descriptor()</a>.</td> </tr> <tr valign="middle"> <td colspan="1" rowspan="1" align="left">SQLT_BLOB</td> <td colspan="1" rowspan="1" align="left">Maps a native descriptor, such as those created by <a href="function.oci-new-descriptor.html" class="function">oci_new_descriptor()</a>.</td> </tr> <tr valign="middle"> <td colspan="1" rowspan="1" align="left">SQLT_RDD</td> <td colspan="1" rowspan="1" align="left">Maps a native descriptor, such as those created by <a href="function.oci-new-descriptor.html" class="function">oci_new_descriptor()</a>.</td> </tr> <tr valign="middle"> <td colspan="1" rowspan="1" align="left">SQLT_NUM</td> <td colspan="1" rowspan="1" align="left">Converts the PHP parameter to a 'C' long type, and binds to that value.</td> </tr> <tr valign="middle"> <td colspan="1" rowspan="1" align="left">SQLT_RSET</td> <td colspan="1" rowspan="1" align="left">Maps a native statement handle, such as those created by <a href="function.oci-parse.html" class="function">oci_parse()</a> or those retrieved from other OCI queries.</td> </tr> <tr valign="middle"> <td colspan="1" rowspan="1" align="left">SQLT_CHR and any other type</td> <td colspan="1" rowspan="1" align="left">Converts the PHP parameter to a string type and binds as a string.</td> </tr> </tbody> </colgroup> </table> <table border="5"> <caption><b>The following types are supported when retrieving columns from a result set:</b></caption> <colgroup> <thead valign="middle"> <tr valign="middle"> <th colspan="1">Type</th> <th colspan="1">Mapping</th> </tr> </thead> <tbody valign="middle" class="tbody"> <tr valign="middle"> <td colspan="1" rowspan="1" align="left">SQLT_RSET</td> <td colspan="1" rowspan="1" align="left">Creates an oci statement resource to represent the the cursor.</td> </tr> <tr valign="middle"> <td colspan="1" rowspan="1" align="left">SQLT_RDD</td> <td colspan="1" rowspan="1" align="left">Creates a ROWID object.</td> </tr> <tr valign="middle"> <td colspan="1" rowspan="1" align="left">SQLT_BLOB</td> <td colspan="1" rowspan="1" align="left">Creates a LOB object.</td> </tr> <tr valign="middle"> <td colspan="1" rowspan="1" align="left">SQLT_CLOB</td> <td colspan="1" rowspan="1" align="left">Creates a LOB object.</td> </tr> <tr valign="middle"> <td colspan="1" rowspan="1" align="left">SQLT_BFILE</td> <td colspan="1" rowspan="1" align="left">Creates a LOB object.</td> </tr> <tr valign="middle"> <td colspan="1" rowspan="1" align="left">SQLT_LNG</td> <td colspan="1" rowspan="1" align="left">Bound as SQLT_CHR, returned as a string</td> </tr> <tr valign="middle"> <td colspan="1" rowspan="1" align="left">SQLT_LBI</td> <td colspan="1" rowspan="1" align="left">Bound as SQLT_BIN, returned as a string</td> </tr> <tr valign="middle"> <td colspan="1" rowspan="1" align="left">Any other type</td> <td colspan="1" rowspan="1" align="left">Bound as SQLT_CHR, returned as a string</td> </tr> </tbody> </colgroup> </table></div><hr /><div style="text-align: center;"> <div class="prev" style="text-align: left; float: left;"><a href="oci8.connection.html">Connecting Handling</a></div> <div class="next" style="text-align: right; float: right;"><a href="ref.oci8.html">OCI8 Functions</a></div> <div class="up"><a href="book.oci8.html">OCI8</a></div> <div class="home"><a href="index.html">PHP Manual</a></div></div></body></html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -