Back

How does PL/SQL differ from SQL?

  • SQL is primarily designed to store data in and retrieve data from your database. It is an ANSI standard language, although Oracle has significantly enhanced its SQL to provide additional functionality.
  • Since PL/SQL is a 3GL, it provides much more sophisticated manipulation of the data than is possible with SQL.
author avatar
eliadminaccount

You may also like

Chrome Extension To Automatically Format Your APEX and PLSQL Code
31 March, 2023

The built in code editor in APEX is missing a very useful thing: the ability to automatically format the code. If you are using a tool like VSCode, Toad or SQL Developer to write your SQL or PL/SQL code, everything …

Oracle Multitenant Architecture Is Here To Stay!
18 January, 2023

Oracle Multitenant Architecture is the only way to go in version 21c. Are you ready for it? With version 12c the traditional, non-CDB architecture was deprecated, and with version 20c this architecture was de-supported. This means going forward Multitenant is …

Using Oracle XE database? Don’t wait until you hit the space limit before moving off it
9 January, 2023

We recently helped a client migrate from Oracle Database XE to SE2. There was no choice – they had reached the XE 12GB data limit. Going to SE2 is effectively a downgrade because XE has all the EE features, so …