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

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 …

ORDS 22.x on Windows bug
25 November, 2022

We just hit a silly problem with ORDS 22.x. When deploying ORDS to Tomcat, you have to create a version of the ords.war file that has the location of the ORDS configuration directory embedded within it. You do this by …

Free Online Registration Required

The tutorial session you want to view requires your registering with us.

It’s fast and easy, and totally FREE.

And best of all, once you are registered, you’ll also have access to all the other 100’s of FREE Video Tutorials we offer!

 

×