MySQL + SQL · Lesson 97
PL/SQL vs MySQL Stored Programs
Two Procedural Languages
PL/SQL is Oracle's procedural language. MySQL has its own stored-program syntax. They do similar jobs with different keywords.
Comparison
| Point | PL/SQL (Oracle) | MySQL |
|---|---|---|
| Block | BEGIN ... END; | BEGIN ... END (with DELIMITER) |
| Output | DBMS_OUTPUT.PUT_LINE | SELECT |
| Variables | DECLARE v NUMBER; | DECLARE v INT; |
Summary
- PL/SQL is Oracle-specific; MySQL has its own procedural syntax.
- Concepts (procedures, functions, loops) are similar; keywords differ.