1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61
|
int main (void)
{
OCI_Connection *cn = NULL;
OCI_Statement *st = NULL;
OCI_Resultset *rs = NULL;
FILE *f = NULL;
clock_t t;
if (!OCI_Initialize(NULL, NULL, OCI_ENV_DEFAULT))
return EXIT_FAILURE;
f = fopen("output.txt", "w");
cn = OCI_ConnectionCreate("db", "usr", "pwd", OCI_SESSION_DEFAULT);
st = OCI_StatementCreate(cn);
OCI_SetFetchSize(st, 1000);
OCI_SetPrefetchSize(st, 200);
t = clock();
OCI_ExecuteStmt(st, "SELECT "
" TO_CHAR(CODPLAT,'S999999999')|| "
" TO_CHAR(CODPREP,'S999999999')|| "
" TO_CHAR(NB_PLAT,'S999999999')|| "
" lpad(nvl(TO_CHAR(DATE_FAB,'YYYYMMDDhh24miss'),' '),14,' ')|| "
" lpad(nvl(TO_CHAR(DATE_CONS,'YYYYMMDDhh24miss'),' '),14,' ')|| "
" TO_CHAR(CODMEN,'S999999999')|| "
" TO_CHAR(CODDEST,'S999999999')|| "
" TO_CHAR(CODGF,'S999999999')|| "
" TO_CHAR(TYPEPLAT,'S999999999')|| "
" lpad(nvl(TO_CHAR(DATE_FAB_INI,'YYYYMMDDhh24miss'),' '),14,' ')|| "
" TO_CHAR(ID,'S999999999')|| "
" TO_CHAR(NB_PLAT_INI,'S999999999')|| "
" lpad(nvl(TO_CHAR(DATE_CREATION,'YYYYMMDDhh24miss'),' '),14,' ')|| "
" lpad(DUMMY1,50,' ') "
"FROM "
" PREV_FAB"
);
rs = OCI_GetResultset(st);
while (OCI_FetchNext(rs))
{
fputs(OCI_GetString(rs, 1), f);
fputs("\n", f);
}
printf("\n%d row(s) fetched in %f secondes",
OCI_GetRowCount(rs),
(double) (clock() - t) / (double) CLOCKS_PER_SEC);
if (f)
fclose(f);
OCI_Cleanup();
} |
Partager