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

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 …

  When you create a linked server to connect to Oracle, you need to put an oracle user into the linked server. Before reading this …

  Stored Procedure and Function concepts in PostgreSQL are not the same as in other relational databases. Functions are used like stored procedures. In some …

  With the help of the following query, you can access the answers to the questions listed below. You can filter the query as you …

Oracle stores the following components in Memory. Program Code Connected sessions even if not active Information required during Query Execution. For example, if the query …