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

PROBLEM: The error “java.sql.SQLException: OALL8 is in an inconsistent state” is being retrieved when the query is executed. REASON: The database version is incompatible with …

You can regularly query your queries written with the Common Table Expression by converting them to Recursive View. We have already done an example of …

  With CTE we can generate recursive queries. We can create a code block and use it over and over again. In this article, I …

By using Materialized Views in PostgreSQL, you can access data faster by physically holding the data in the view. I will go over an example …

Oracle uses Redo Logs and Archive Logs to ensure that the data written to the database will not be lost once it has been written …

The most important two components of Oracle Instance are SGA and Background Processes. Each Oracle Database process on the operating system is responsible for one …

  In PostgreSQL, views are logical tables. By turning queries into views we can use complex queries with a simple select statement. For example, if …

Problem: When attempting to pull data from sql server with db link in Oracle database, ORA-600 error occurs. Reason: Setting the cursor_sharing parameter to force …

  When using dblink in Oracle 11.2.04, we get ORA-04052 error when we want to create an object with the query result from dblink. To …

  I have already mentioned how to create a linked server that will connect to Oracle in the article named “How To Create a Linked …