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

If there is a difference with the db_name parameter when opening the Oracle database, you receive an error as follows. “ORA-00205: error in identifying control …

What is Basic Availability Groups? As of SQL Server 2016, we can create Always ON Availability Groups in Standard Edition with some limitations. You should …

ORA_ROWSCN returns the SCN information for the last modified date of the row for each row in a table. You can use this pseudo-column to …

Static Data Dictionary Views These are new static data dictionary views which are introduce in Oracle Database Release 19c. ALL_TRIGGERS_AE DBA_TRIGGERS_AE USER_TRIGGERS_AE DBA_AUTO_INDEX_CONFIG DBA_AUTO_STAT_EXECUTIONS DBA_PDB_SNAPSHOTFILE …

What is Dynamic Data Masking? Dynamic Data Masking is a feature announced in SQL Server 2016. With Dynamic Data Masking, you can restrict unauthorized access …

It is possible to convert SCN (system change number) to date and date to SCN in Oracle databases. This allows us to find out when …

What is Row Level Security in SQL Server? Row-Level Security is a feature introduced in SQL Server 2016 that allows each user to see only …

In Oracle databases, over time, indexes are fragmented and cause serious performance issues. We should check the indexes regularly and rebuild them if necessary. Determine …

You can find information about creating SQL Database in Azure in this article. If you are creating a Stretch Database, you must first create a …

If the password file format in the 12c databases is same with the format in the 11g databases, you receive the error “ORA-28017: The password …