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

If you want to find a word in all your databases in an instance, you are in the right article. The below code block search …

  We can use the Oracle ASM configuration assistant (asmca) tool via the GUI, or from the command line. In other words, we can run …

  I received this error when I right-click on the database and click Properties. Property Size is not available for Database. This property may not …

  In this article, I will explain the startup and shutdown modes of Oracle database. Oracle Database Startup Modes A closed Oracle database opens in …

You can find the last day of a month using EOMONTH function. In addition, you can use a second parameter that add a specific number …

When trying to connect to an open intance via the listener, you may receive the error “ORA-12528: TNS: listener: all appropriate instances are blocking new …

  Computed Column is a column generated by a calculation using one or more columns in a table. For example, you have columns A, B …

  In this article I will explain the software and database installation of Oracle 11g database. You can download Oracle 11g software from this link. …

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 …