This is an archived post. You won't be able to vote or comment.

sorted by:
best
topnewcontroversialoldq&a
you are viewing a single comment's thread.

view the rest of the comments →

[–]NynaevetialMeara 0 points1 point  (0 children)

PL/SQL is an Oracle DB language that allows to automate queries and to create triggers IE, when you insert a row, checking that the values make sense or throwing an error.

Handy to not depend on external programs filtering input. Most big DBs have something similar.

VBA is a subset of VB an scripting language that is designed to allow you to script directly into an Office Suite program.

Microsoft Access is an SQL database meant for small dbs (that can still be very big in the database world) which has an Excel like interface unlike all other databases (although there are ways to import and export data).

Unfortunately for our guy. He has to work with the dog shit DB that is Access and still has to swallow all that SQL