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

  CHOOSE and IIF functions are logical functions. CHOOSE function returns the value at the specified index from the specified list. IIF function performs the …

  On an Oracle RAC server, you may receive an error as follows when you want to create a new database with runinstaller. INS-35354: The …

  Spatial Index can only be created on Spatial columns. That is, the type of column must be geometry or geography. Let’s create a table …

  SQRT function returns the square root of a float value and the return data type is float. SQUARE function returns the square of a …

  When the “AVDF transaction log audit trail” is created and deleted, the archive logs cannot be deleted normally, depending on bug 23217905. The problem …

  The Filtered Index is a filtered nonclustered index. For example, you have 100,000 records in a table. And some of your queries are only …

  The SIGN function determines whether a number is negative, 0, or positive. If the number is negative, it returns -1, If the number is …

With ADRCI, it is possible to delete files such as “log, trace, incident, cdump” created before a certain day. Instead of manually deleting individual files, …

Most database experts, or TSQL developer knows EDIT TOP 200 Rows option. When you click EDIT TOP 200 Rows by right-clicking on the table, unlike …

  The FLOOR function returns the largest integer value smaller than a number. If the number is already an integer, it returns the same number …