Additionally, oracle on the requirements of the sql statement is more stringent, and oracle variables more than mysql more points, oracle has a number, large data types, mysql do not have;
Additionally, a more strict requirement for oracle on sql, and oracle variable more points, oracle has a number, and mysql do not have a large data types. There are large data types in oracle, but not in mysql;
Another example is that oracle can't insert empty columns, while mysql can (I don't know if it's correct or not). There are differences between the two of them function, such as turn date function oracle is to_date('to turn the string', 'format') -- select to_date('2004-05-07 13:23:44','yyyy-mm-dd hh24:mi:ss') from dual, while mysql is str_ to_date('08/09/2008', '%m/%d/%Y'); -- 2008-08-09// both come for string to date.
One more thing, we often hope that the primary key can automatically grow, to avoid the problem of duplication when we insert data, but oracle can not set the columns to grow automatically, and mysql can be, oracle can be used with sequences and triggers to solve the problem of automatic growth to achieve the same effect with mysql.
Overall ninety percent of the sql statements are no different. Overall oracle's format is a bit stricter, for some character types must also add single quotes to insert, mysql requirements are not so much. And when inserting a date into the database, mysql can be inserted directly into the success, but oracle need to be converted to sql inside the date type before; oracle more secure than mysql, but the charge, the general use of large companies. oracle also has a stored procedure and functions, triggers, which is mysql does not have. This is generally the case.