Fraud Blocker

10 useful tips for writing SQL queries.

Today I want to talk about the simple things that will help novice SQL programmers more correctly, thoughtfully and simply make the logic of their que…

Continue Reading

Oracle Comments.

Did you know that you can put comments into SQL statements in Oracle? Comments can appear in one line or be distributed over several lines. Let’s see …

Continue Reading

Oracle Data Types.

Below is a list of data types available in Oracle/PLSQL, which includes character, numeric, date/time, Boolean LOB, RowId data types….

Continue Reading

Oracle BEFORE INSERT trigger.

In this tutorial you will learn how to create a BEFORE INSERT trigger (before inserting) in Oracle with syntax and examples.

Oracle executes (exci…

Continue Reading

Trigger before delete in Oracle.

In this tutorial you will learn how to create a trigger BEFORE DELETE (before deleting) in Oracle with syntax and examples.

Oracle executes (exci…

Continue Reading

🎉 Thank you for subscribing!

You're now on the list for database FinOps strategies and performance insights.