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.
💻 Live Code Editor
Is page ki language (MYSQL) mein code likhein aur turant chalाएं — yahीं, bina kuch install kiye.Powered by OneCompiler. Agar editor na khule to yahान naye tab mein kholein.
💻 Live Code Editor
Is page ke program yahan ready hain — chalाएं, badlें aur seekhें. Bina kuch install kiye.
Powered by OneCompiler. Editor mein code apne aap aa jata hai — Run dabaakर output dekhें.
Agar load na ho to naye tab mein kholें.