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

You can check the expression is a valid date, time or datetime value using ISDATE Function. This function’s return type is int. Before using this …

  We ensure that unused space in the datafiles are reclaimed by the ASM disk group with the resize process. This ensures that unused areas …

  We use Telnet Client to check if the port we want to use is open when we access a server from another server. In …

  I will explain GETDATE, GETUTCDATE, SYSDATETIME and SYSUTCDATETIME functions in this article. GETDATE Function in SQL Server(TSQL): We can obtain current database timestamp as …

IOPS (Input/Output Operations Per Second) is a common performance metric used to compare computer storage devices. IOPS in Oracle databases is the total number of …

  Sometimes you cannot copy your scripts or files to the database server. If you don’t know the solution, it can be a very frustrating. …

  We can find the day using DAY function, month using MONTH function and  year using YEAR function from a date. It takes the date() …

  Some of the disks may be in CLOSED and IGNORED status when “v$asm_disk” is queried after a broken disk on the Exadata storage is …

Synonym is to give alias (an alternative name) to some objects on a database basis. The synonym can be created for following objects. Table View …

A friend ask to me to conversion about gregorian date to hijri date or hijri date to gregorian date. I will explan this conversions in …