Differences MySQL with Oracle (PART 1)

Some differences between Mysql to Oracle, namely:

1. Connection

In Mysql syntax for connection:    

       

                mysql_connect(“host”,”username”,”password”);

                While at Oracle syntax for the connection:

                                OCILogon(username,password, [ORACLE_SID]);

2. Closing the connection

In Mysql syntax to close the connection:

                                mysql_close(connection_variabel);

While at Oracle syntax to close the connection:

                                OCILogoff(connection_variabel);

3. executing Query

In Mysql syntax to execute the query is:

                        Mysql_query(query);

            While at Oracle syntax to execute the query is:

                        OCIParse(connection_variabel,query);