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 …

Any problem with multicast traffic between Oracle RAC database servers can cause network heartbit problems between servers. In this case you need to see the …

In the database, it may sometimes be necessary to disable system triggers during operations such as java installation, downgrade, or upgrade. An error in a …