Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux

In today’s article, we will explain using Grant to authorize the user or roles and Revoke to revoke authorizations. System and Object privileges cannot be …

In today’s article, we will examine the “ORA-08180” error when trying to see the changes in a table with “AS OF TIMESTAMP” in the Oracle …

In today’s article, we will be cover the use of the Any operator, which has the same meaning as some in PostgreSQL. One of the …

In today’s article, we will be explaining how to Changing Parameters at Session Level. Only the connected session will change. ALTER SESSION SET command is …

In today’s article, we will answer the question of How to Kill a Running Sql Query in Oracle Database. There is a SQL query that …

In PostgreSQL, we may want to update the records from another table, for this we will use the update clause, but this time we will …

In today’s article we will be explaining how to do Instance Level Parameter Change. This change applies to all user sessions. ALTER SYSTEM SET command …

In today’s article, we will explain how ZDLRA (Zero Data Loss Recovery Appliance) produced by Oracle management the Storage space on itself. One of the …

In today’s article, we will be learning the NOT EXISTS clause in PostgreSQL. You can think of NOT EXITS as the use of equal and …

In today’s article, we will be learning how to customize the name of the trace file to be created for a session. 1. We determine …