SQL Vs PL/SQL
| Feature | SQL (Structured Query Language) | PL/SQL (Procedural Language/SQL) |
|---|---|---|
| Type | Non-procedural (Declarative). | Procedural Language. |
| Focus | What data to get or change. | How to process data using logic. |
| Logic | Executes one statement at a time. | Uses blocks, loops, and IF-THEN logic. |
| Variables | Does not support variables. | Supports variables, constants, and types. |
| Error Handling | No built-in error handling. | Uses an EXCEPTION section for errors. |
| Execution | Each command is sent individually. | A whole block is sent to the server at once. |
| Performance | High network traffic for multiple queries. | Lower network traffic (bundled execution). |