The difference between MySQL and Oracle

1. Grammatical differences

The definition of the variable type, the position in the out, the position of the variable definition, the position of the cursor, and the position of the exception;

2, MySQL does not return keyword, using leave label way to end the loop

3. Exception handling MySQL handles exceptions based on the error code returned

4. Lock

If set to Auto-lock, then the lock statement execution will be automatically committed after completion, and then release the lock; select * FROM table1 where ... for update; this sentence will release the lock when the execution is complete. In some cases it is not possible to avoid conflicts, such as when an update is required, or for uodate wait 10 for Oracle, or to wait for more than 10 seconds to throw an exception

So for MySQL is generally set to manually release the lock, with a commit or ROLLBACK statement release.

5.

The difference between MySQL and Oracle