Differences MySQL with Oracle (PART 2)

In previous articles we have discussed the three differences between MySQL with PHP. In this article we will discuss the continuation of the differences between MySQL with PHP.

4. Free Statement

            In Mysql syntax for free statement:

                        mysql_free_result(statement);

            While at Oracle syntax for free statement:

                        OCIFreeStatement(statement);

5. Obtain the number of rows

            In Mysql syntax for Obtain the number of rows:

                        mysql_num_rows(statement);

            While at Oracle syntax for Obtain the number of rows:

                        OCIRowCount(statement);

6. Create array

            In Mysql syntax for create array :

                        mysql_fetch_array(statement, tipe array);

            While at Oracle syntax for create array:

                        OCIFetchInto(Statement, array_result,[mode]);