What can PL/SQL do that SQL cannot?
- First, PL/SQL supports seamless integration with SQL. This allows PL/SQL to embed SQL statements to retrieve many rows of data, and then loop through the rows.
- PL/SQL extends SQL to support manipulation or rows individually to do whatever is needed: perform analyses, generate detailed reports, do statistical analyses, export data, generate emails, etc.