Tag: Oracle

How to download and install Oracle SQL Developer on Windows 11

In this article, we will see how to download and install Oracle SQL Developer on Windows 11 step by step.

What is SQL Developer

Oracle SQL Developer is a free, integrated development environment that simplifies the development and management of Oracle Database in both traditional and Cloud deployments. SQL Developer offers complete end-to-end development of your PL/SQL applications, a worksheet for running queries and scripts, a DBA console for managing the database, a reports interface, a complete data modeling solution, and a migration platform for moving your 3rd party databases to Oracle.

How to download and install Oracle SQL Developer on Windows 11

Continue reading How to download and install Oracle SQL Developer on Windows 11

How to download and install Oracle Database 21c on Windows 11

In this article, we will see how to download and install Oracle Database 21c on Windows 11 ste by step. At the time of making article Oracle Database 21c is latest Oracle version which is available for download.

System requirements to install Oracle database 21c Windows:

Minimum 2GB free RAM.
10GB of empty space on Hard Disk Drive
A processor that supports Intel EM64T or AMD64 architecture.
Display card with a minimum resolution of 1024×768 pixels.
16GB SWAP space if RAM is more than 16GB. Continue reading How to download and install Oracle Database 21c on Windows 11

How to install Oracle Database 19c on Oracle Linux or RHEL 8 step by step

In this article, we are going see how to install Oracle Database 19c on Oracle Linux or RHEL 8 step by step.

We are going to see installation of Oracle database 19c on Oracle linux: Continue reading How to install Oracle Database 19c on Oracle Linux or RHEL 8 step by step

INS-30014 Unable to check whether the location specified is on CFS on Windows 11

In this article, we will see the reason and solution for below error. I have received this error when tried to install Oracle 19c database on Windows 11.

INS-30014 Unable to check whether the location specified is on CFS

INS-30014 Unable to check whether the location specified is on CFS

Reason for INS-30014 Unable to check whether the location specified is on CFS

Continue reading INS-30014 Unable to check whether the location specified is on CFS on Windows 11

What is the difference between Stored Procedure and Trigger in SQL

In this article, we will see the difference between Stored Procedure and Trigger in SQL. Following are the main differences between Stored Procedure and Trigger:

Continue reading What is the difference between Stored Procedure and Trigger in SQL

Stored Procedure Trigger
Store Procedures are invoked explicitly Triggers are invoked implicitly
Stored procedure is a user defined piece of code which may return a value (making it a function) that is invoked by calling it explicitly. A trigger is a stored procedure that runs automatically when various events happen (eg update, insert, delete).

What is the difference between synchronous and asynchronous Replication

Following are the difference between synchronous and asynchronous Replication.

1. Asynchronous Replication: There is delay between Master and Slave(Secondary). In this data can be replicated after the transaction has been committed on the master. Which means the slave is never ahead of the master. So, in the case of writing it is usually a little behind the master. This delay also called lag.

2. Synchronous Replication: Continue reading What is the difference between synchronous and asynchronous Replication

Difference between Stored procedure and Function in SQL

Following are the main differences between Stored procedure and Function in SQL.

Continue reading Difference between Stored procedure and Function in SQL

Stored Procedure Function
Stored procedure may or may not return values A Function must return a value
Stored procedures can have input/output parameters Functions can have only input parameters
Stored Procedure may take 0 to n input parameters For a Function it is mandatory to take one input parameter

What is the difference between union and join

Following are the differences between union and join in relational database engines.
A union returns the results of two different queries as a single recordset and A join allows you to relate similar data in different tables.

UNION JOIN
UNION puts lines from queries after each other, JOIN makes a cartesian product and subsets it
Union Operation is combined result of the Vertical Aggregate of the rows JOIN Operation is combined result of the Horizontal Aggregate of the Columns
Union combines rows JOIN links the rows
Performed only on two similar structures Performed only on two dissimilar structures also
A union returns the results of two different queries as a single recordset. A join allows you to relate similar data in different tables.

Visual depiction of a join. Table A and B’s columns are combined into a single result:

Continue reading What is the difference between union and join

How to count the number of emails per domain in PostgreSQL MySQL Oracle

In this article, we will see how to count the number of emails per domain, we can use the following query in SQL Server or PostgreSQL or MySQL or Oracle or any RDBMS:

To count the number of emails per domain in PostgreSQL MySQL Oracle:

SELECT 
    SUBSTRING(
        email, 
        CHARINDEX('@', email)+1, 
        LEN(email)-CHARINDEX('@', email)
    ) domain_name,
    COUNT(email) emails_count
FROM 
    sales.customers
GROUP BY
    SUBSTRING(
            email, 
            CHARINDEX('@', email)+1, 
            LEN(email)-CHARINDEX('@', email)
        );

Continue reading How to count the number of emails per domain in PostgreSQL MySQL Oracle