The blog discusses anything data with a focus on databases. If you are interested in improving your knowledge of SQL and databases, this is the place to be.
In the series, I hope to cover some common database objects such as procedures, functions, triggers etc. while also providing frequent real-life...
... in Oracle Databases · Before, we dive in. PL SQL is a strongly typed language. For every variable used in a program or subprogram, the variable must...
A Deep Dive using AWS RDS · Database triggers are special types of objects. They look like database procedures and functions but they are only executed...
Procedures are commonplace across several different occupations and processes. Simply put, the term 'procedure' is a series of actions conducted in a...
It is ridiculously hard to get very appealing SQL pictures 🤕 · Functions are very similar to procedures in databases. In this article, I will try to...
Packages are unique to Oracle relational database management systems. Packages in the simplest terms are a group of related objects all bundled...
