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

When connecting to Oracle 12.2 databases from different databases with db link, reco process terminates unexpectedly. This problem is caused by bug 27544973. In order …

With SQL Server 2008, we can now easily uninstall Service Packs and Cumulative Updates from Control Panel, Programs and Features. Especially in case of a …

Prior to the Oracle 12c version, droping an index was an offline process that put a lock on the original table in exclusive mode. Exclusive …

With BULK INSERT you can upload text, csv data files to the database in any format. Users must have insert privileges in the database and …

We often need to get information about existing sessions in databases. We can find the below details with the help of the following query. Which …

With OPENROWSET, you can access remote data using OLE DB. OPENROWSET is a system function as you will see below. With this method, we provide …

If a user want to drop a DB link belonging to a schema in Oracle databases, it searches for that DB link under the schema …

What is Query Hint? You can change the execution plan of the query by adding the query hints to the end of the query. For …

The most recent password change date for users in the Oracle database is in the ptime field in the sys.user $ table. With a query …

In this article, we will examine what happens when we enable Optimize for ad hoc workloads and when we use parameterization. We will see what …