meta.c

来自「oci的源码,可以在任何平台上编译,相当方便实用」· C语言 代码 · 共 35 行

#include "ocilib.h"

int main(void)
{
    OCI_Connection *cn;
    OCI_Statement *st;
    OCI_Resultset *rs;

    int i, n;

    if (!OCI_Initialize(NULL, NULL, OCI_ENV_DEFAULT))
        return EXIT_FAILURE;

    cn = OCI_ConnectionCreate("db", "usr", "pwd", OCI_SESSION_DEFAULT);
    st = OCI_StatementCreate(cn);
 
    OCI_ExecuteStmt(st, "select * from test_fetch");

    rs = OCI_GetResultset(st);
    n  = OCI_GetColumnCount(rs);
    
    for(i = 1; i <= n; i++)
    {
        OCI_Column *col = OCI_GetColumn(rs, i);

        printf("Field #%i : name '%s' - size %i\n", i,
                OCI_GetColumnName(col),
                OCI_GetColumnSize(col));
    }

    OCI_Cleanup();
 
    return EXIT_SUCCESS;
}