📄 sqlora_8h.html
字号:
<br> <a class="el" href="group__constants.html#gga6a66">SQLOT_VBI</a> = 15, <a class="el" href="group__constants.html#gga6a67">SQLOT_BIN</a> = 23, <br> <a class="el" href="group__constants.html#gga6a68">SQLOT_LBI</a> = 24, <a class="el" href="group__constants.html#gga6a69">SQLOT_UIN</a> = 68, <br> <a class="el" href="group__constants.html#gga6a70">SQLOT_SLS</a> = 91, <a class="el" href="group__constants.html#gga6a71">SQLOT_LVC</a> = 94, <br> <a class="el" href="group__constants.html#gga6a72">SQLOT_LVB</a> = 95, <a class="el" href="group__constants.html#gga6a73">SQLOT_AFC</a> = 96, <br> <a class="el" href="group__constants.html#gga6a74">SQLOT_AVC</a> = 97, <a class="el" href="group__constants.html#gga6a75">SQLOT_CUR</a> = 102, <br> <a class="el" href="group__constants.html#gga6a76">SQLOT_RDD</a> = 104, <a class="el" href="group__constants.html#gga6a77">SQLOT_LAB</a> = 105, <br> <a class="el" href="group__constants.html#gga6a78">SQLOT_OSL</a> = 106, <a class="el" href="group__constants.html#gga6a79">SQLOT_NTY</a> = 108, <br> <a class="el" href="group__constants.html#gga6a80">SQLOT_REF</a> = 110, <a class="el" href="group__constants.html#gga6a81">SQLOT_CLOB</a> = 112, <br> <a class="el" href="group__constants.html#gga6a82">SQLOT_BLOB</a> = 113, <a class="el" href="group__constants.html#gga6a83">SQLOT_BFILEE</a> = 114, <br> <a class="el" href="group__constants.html#gga6a84">SQLOT_CFILEE</a> = 115, <a class="el" href="group__constants.html#gga6a85">SQLOT_RSET</a> = 116, <br> <a class="el" href="group__constants.html#gga6a86">SQLOT_NCO</a> = 122, <a class="el" href="group__constants.html#gga6a87">SQLOT_VST</a> = 155, <br> <a class="el" href="group__constants.html#gga6a88">SQLOT_ODT</a> = 156, <a class="el" href="group__constants.html#gga6a89">SQLOT_DATE</a> = 184, <br> <a class="el" href="group__constants.html#gga6a90">SQLOT_TIME</a> = 185, <a class="el" href="group__constants.html#gga6a91">SQLOT_TIME_TZ</a> = 186, <br> <a class="el" href="group__constants.html#gga6a92">SQLOT_TIMESTAMP</a> = 187, <a class="el" href="group__constants.html#gga6a93">SQLOT_TIMESTAMP_TZ</a> = 188, <br> <a class="el" href="group__constants.html#gga6a94">SQLOT_INTERVAL_YM</a> = 189, <a class="el" href="group__constants.html#gga6a95">SQLOT_INTERVAL_DS</a> = 190, <br> <a class="el" href="group__constants.html#gga6a96">SQLOT_TIMESTAMP_LTZ</a> = 232<br> }</td></tr><tr><td class="mdescLeft"> </td><td class="mdescRight">The data types for bind variables The oracle constants are copied from $ORACLE_HOME/rdbms/demo/ocidfn.h. <a href="group__constants.html#ga6">More...</a><br><br></td></tr><tr><td class="memItemLeft" nowrap align=right valign=top>enum </td><td class="memItemRight" valign=bottom><a class="el" href="group__constants.html#ga7">sqlo_statement_states</a> { <br> <a class="el" href="group__constants.html#gga7a97">SQLO_STMT_STATE_INITIALIZED</a> = 1, <a class="el" href="group__constants.html#gga7a98">SQLO_STMT_STATE_EXECUTED</a> = 2, <br> <a class="el" href="group__constants.html#gga7a99">SQLO_STMT_STATE_END_OF_FETCH</a> = 3<br> }</td></tr><tr><td class="mdescLeft"> </td><td class="mdescRight">Possible statement states returned by <a class="el" href="group__misc.html#ga7">sqlo_get_stmt_state</a>. <a href="group__constants.html#ga7">More...</a><br><br></td></tr><tr><td class="memItemLeft" nowrap align=right valign=top>enum </td><td class="memItemRight" valign=bottom><a class="el" href="group__typedefs.html#ga4">sqlo_oci_handle_types_e</a> { <br> <a class="el" href="group__typedefs.html#gga4a100">SQLO_OCI_HTYPE_ENV</a> = 1, <a class="el" href="group__typedefs.html#gga4a101">SQLO_OCI_HTYPE_ERROR</a> = 2, <br> <a class="el" href="group__typedefs.html#gga4a102">SQLO_OCI_HTYPE_SVCCTX</a> = 3, <a class="el" href="group__typedefs.html#gga4a103">SQLO_OCI_HTYPE_SERVER</a> = 4, <br> <a class="el" href="group__typedefs.html#gga4a104">SQLO_OCI_HTYPE_SESSION</a> = 5, <a class="el" href="group__typedefs.html#gga4a105">SQLO_OCI_HTYPE_STMT</a> = 6<br> }</td></tr><tr><td class="mdescLeft"> </td><td class="mdescRight">Oracle OCI Handle types used by <a class="el" href="group__misc.html#ga0">sqlo_get_oci_handle</a>. <a href="group__typedefs.html#ga4">More...</a><br><br></td></tr><tr><td colspan=2><br><h2>Functions</h2></td></tr><tr><td class="memItemLeft" nowrap align=right valign=top>int </td><td class="memItemRight" valign=bottom><a class="el" href="group__init.html#ga0">sqlo_init</a> (int threaded_mode, unsigned int max_db, unsigned int max_cursors)</td></tr><tr><td class="mdescLeft"> </td><td class="mdescRight">Init the library. <a href="group__init.html#ga0"></a><br><br></td></tr><tr><td class="memItemLeft" nowrap align=right valign=top>int </td><td class="memItemRight" valign=bottom><a class="el" href="group__init.html#ga1">sqlo_version</a> (const char *version_str)</td></tr><tr><td class="mdescLeft"> </td><td class="mdescRight">Checks if the version is sufficient. <a href="group__init.html#ga1"></a><br><br></td></tr><tr><td class="memItemLeft" nowrap align=right valign=top>const char * </td><td class="memItemRight" valign=bottom><a class="el" href="group__error.html#ga0">sqlo_geterror</a> (<a class="el" href="group__typedefs.html#ga0">sqlo_db_handle_t</a> dbh)</td></tr><tr><td class="mdescLeft"> </td><td class="mdescRight">Return last error string. <a href="group__error.html#ga0"></a><br><br></td></tr><tr><td class="memItemLeft" nowrap align=right valign=top>int </td><td class="memItemRight" valign=bottom><a class="el" href="group__error.html#ga1">sqlo_geterrcode</a> (<a class="el" href="group__typedefs.html#ga0">sqlo_db_handle_t</a> dbh)</td></tr><tr><td class="mdescLeft"> </td><td class="mdescRight">Return the last error code. <a href="group__error.html#ga1"></a><br><br></td></tr><tr><td class="memItemLeft" nowrap align=right valign=top>int </td><td class="memItemRight" valign=bottom><a class="el" href="group__easy.html#ga0">sqlo_exists</a> (<a class="el" href="group__typedefs.html#ga0">sqlo_db_handle_t</a> dbh, const char *table, const char *colname, const char *colval, const char *where)</td></tr><tr><td class="mdescLeft"> </td><td class="mdescRight">Tests if a value exists in a table. <a href="group__easy.html#ga0"></a><br><br></td></tr><tr><td class="memItemLeft" nowrap align=right valign=top>int </td><td class="memItemRight" valign=bottom><a class="el" href="group__easy.html#ga1">sqlo_count</a> (<a class="el" href="group__typedefs.html#ga0">sqlo_db_handle_t</a> dbh, const char *table, const char *colname, const char *colval, const char *where)</td></tr><tr><td class="mdescLeft"> </td><td class="mdescRight">Counts the number of items in the table. <a href="group__easy.html#ga1"></a><br><br></td></tr><tr><td class="memItemLeft" nowrap align=right valign=top>int </td><td class="memItemRight" valign=bottom><a class="el" href="group__easy.html#ga2">sqlo_run</a> (<a class="el" href="group__typedefs.html#ga0">sqlo_db_handle_t</a> dbh, const char *stmt, int argc, const char **argv)</td></tr><tr><td class="mdescLeft"> </td><td class="mdescRight">Run a simple sql statements with parameters. <a href="group__easy.html#ga2"></a><br><br></td></tr><tr><td class="memItemLeft" nowrap align=right valign=top><a class="el" href="group__typedefs.html#ga1">sqlo_stmt_handle_t</a> </td><td class="memItemRight" valign=bottom><a class="el" href="group__easy.html#ga3">sqlo_open</a> (<a class="el" href="group__typedefs.html#ga0">sqlo_db_handle_t</a> dbh, const char *stmt, int argc, const char **argv)</td></tr><tr><td class="mdescLeft"> </td><td class="mdescRight">Open a new cursor. <a href="group__easy.html#ga3"></a><br><br></td></tr><tr><td class="memItemLeft" nowrap align=right valign=top>int </td><td class="memItemRight" valign=bottom><a class="el" href="group__easy.html#ga4">sqlo_open2</a> (<a class="el" href="group__typedefs.html#ga1">sqlo_stmt_handle_t</a> *sthp, <a class="el" href="group__typedefs.html#ga0">sqlo_db_handle_t</a> dbh, const char *stmt, int argc, const char **argv)</td></tr><tr><td class="mdescLeft"> </td><td class="mdescRight">Open a new cursor. <a href="group__easy.html#ga4"></a><br><br></td></tr><tr><td class="memItemLeft" nowrap align=right valign=top>int </td><td class="memItemRight" valign=bottom><a class="el" href="group__easy.html#ga5">sqlo_reopen</a> (<a class="el" href="group__typedefs.html#ga1">sqlo_stmt_handle_t</a> sth, int argc, const char **argv)</td></tr><tr><td class="mdescLeft"> </td><td class="mdescRight">Reopens a already used cursor. <a href="group__easy.html#ga5"></a><br><br></td></tr><tr><td class="memItemLeft" nowrap align=right valign=top>int </td><td class="memItemRight" valign=bottom><a class="el" href="group__easy.html#ga6">sqlo_fetch</a> (<a class="el" href="group__typedefs.html#ga1">sqlo_stmt_handle_t</a> sth, unsigned int nrows)</td></tr><tr><td class="mdescLeft"> </td><td class="mdescRight">Fetches the data from an open cursor. <a href="group__easy.html#ga6"></a><br><br></td></tr><tr><td class="memItemLeft" nowrap align=right valign=top>const char ** </td><td class="memItemRight" valign=bottom><a class="el" href="group__easy.html#ga7">sqlo_values</a> (<a class="el" href="group__typedefs.html#ga1">sqlo_stmt_handle_t</a> sth, int *num, int dostrip)</td></tr><tr><td class="mdescLeft"> </td><td class="mdescRight">Get one dataset. <a href="group__easy.html#ga7"></a><br><br></td></tr><tr><td class="memItemLeft" nowrap align=right valign=top>const unsigned short * </td><td class="memItemRight" valign=bottom><a class="el" href="group__easy.html#ga8">sqlo_value_lens</a> (<a class="el" href="group__typedefs.html#ga1">sqlo_stmt_handle_t</a> sth, int *num)</td></tr><tr><td class="mdescLeft"> </td><td class="mdescRight">Get the length of the returned values. <a href="group__easy.html#ga8"></a><br><br></td></tr><tr><td class="memItemLeft" nowrap align=right valign=top>const char ** </td><td class="memItemRight" valign=bottom><a class="el" href="group__easy.html#ga9">sqlo_ocol_names</a> (<a class="el" href="group__typedefs.html#ga1">sqlo_stmt_handle_t</a> sth, int *num)</td></tr>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -