summaryrefslogtreecommitdiff
path: root/ext/oci8/tests/create_table.inc
blob: d6debf2339a7316cda9aacccdf04aef4cadf4d5d (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
<?php

    if ($c) {
        $ora_sql = "DROP TABLE
                                ".$schema.$table_name."
                   ";

        $statement = OCIParse($c, $ora_sql);
        @OCIExecute($statement);

        $ora_sql = "CREATE TABLE 
                                ".$schema.$table_name." (id NUMBER, value NUMBER, blob BLOB, clob CLOB, string VARCHAR(10)) 
                   ";
                      
        $statement = OCIParse($c,$ora_sql);
        OCIExecute($statement);
    }

?>