Fraud Blocker

Setting default tabular spaces Oracle.

First, make sure you create a permanent table space.

Then you will need to modify the Oracle database to use the persistent table space as the defaul…

Continue Reading

Oracle Roles.

Oracle Role is a set or group of privileges that can be granted to users or other roles. It is a great way for database administrators to save time an…

Continue Reading

Oracle delete cascade; Foreign Keys with cascade delete.

You will learn how to use foreign keys with cascade delete in Oracle PLSQL with syntax and examples….

Continue Reading

Creating databases and tables using SQL commands.

This article will show you how to create new databases and tables using SQL commands in a mysql client. It is assumed that this tool is running and co…

Continue Reading

Why should the MySQL GROUP CONCAT function be used?

This is the function MySQL GROUP CONCAT and how it can change the work with query results. Especially if the database is the data source for the appli…

Continue Reading

🎉 Thank you for subscribing!

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