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

I will continue to explain Oracle database architecture in this article. I’m adding the following image to be memorable. If you didn’t read the first …

In this article I will tell you about Oracle Database Architecture. Oracle Database is the most preferred database in the world, especially in large scale …

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. …