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 …

  We can get a date by combining the values such as year, month and day with the help of DATEFROMPARTS, DATETIMEFROMPARTS, DATETIME2FROMPARTS, SMALLDATETIMEFROMPARTS functions. …

  When a database owner changes his password, you may receive errors as follows. Therefore, it would make more sense to set the owner of …

When taking a backup with Expdp, it can be terminated with ORA-31693, ORA-02354 and ORA-01555 errors when it comes to a table with a lob …

  The “Cursor Mutex S” wait event occurs when two different sessions try to make hard or soft parsing on the same query. As a …

  ColumnStore Index entered our lives with SQL Server 2012.  Normally the index is stored in the disk as row-based, and the index is created …