Fraud Blocker

Encryption of stored data in MySQL 8.

MySQL 5.7.11 introduced transparent encryption for InnoDB table space, which included support for table space files. Later, encryption for the shared …

Continue Reading

Oracle CASE statement.

In Oracle statement CASE has IF-THEN-ELSE functionality. Starting with Oracle 9i, you can use a CASE statement in an SQL sentence….

Continue Reading

Oracle IF-THEN-ELSE operator.

In Oracle, the IF-THEN-ELSE operatoris used to execute code when the condition is TRUE (true), or execute another code when the condition is FALSE (fa…

Continue Reading

Oracle unique constraints.

In this post you will learn how to create, delete, disable, and enable unique constraints in Oracle with syntax and examples.

A unique constraint is…

Continue Reading

Oracle Indexes.

In this post you will learn how to create, rename and drop indexes in Oracle/PLSQL with syntax and examples….

Continue Reading

🎉 Thank you for subscribing!

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