Arindam Mondal

Arindam Mondal
SQL IN with Subquery

Understanding the SQL IN operator with examples

March 19, 2024 by

Today we will learn about the SQL IN operator. The RDBMS systems are very popular today in terms of data storage, data security, and data analysis. SQL stands for Structured Query Language which is used to create, update, or retrieve data in RDBMS or Relational Database Management Systems like SQL Server, Oracle, Microsoft Access, MySQL, and PostgreSQL.

Read more »
'HELLO',1,2

Understanding Substring in Oracle SQL

March 22, 2023 by

The Oracle SQL database provides many useful functions to use with your query or programming. The SUBSTR function is one of the most used string functions in the Oracle SQL database. I will also discuss a few important string functions TRIM, UPPER, and LOWER which can be used along with substring functions. In this article, we will discuss substring in Oracle SQL.

Read more »