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

  After installing Oracle clusterware, we often ask the following question. What is my Oracle Cluster Name? In RAC systems, we can query the cluster …

  You may need to uninstall a replication that you previously installed and drop the database. You may receive an error if you want to …

  The use of “Auto Increment Identitiy Column” in tables is common. In some cases, we may want to find the last Identitiy value generated. …

  When a table containing a CLOB column is queried with a dblink from a remote database, it returns an error as ORA-22992. A table …

  If you want to delete the database, you will get this error if there is an open session on the database. First, set the …

With the DATALENGTH function, we can calculate the size of the data in a column in bytes. Usually, its useful for calculating the size of …

  In some cases, we may need to move the lob columns in a table to another tablespace. You can do this with the following …

  With Database Mail, you can get this error when you want to send mail using msdb.dbo.sp_send_dbmail. This is because none of the Database Mail …

  With the @@ SPID Function, we can find the session id of the current session. Usually we use when we want to exclude the …

  When access to the KVM switch in the Exadata cabinet, a “Network connect error” error can be received from Java. An error may occur …