top of page

SQL

Oracle SQL Interview Questions

Here are some of the frequently asked SQL interview questions. Enjoy! Q1. What is the difference between VARCHAR & VVARCHAR2? Both...

Oracle SQL Interview Questions

Database Normalization

Database normalization is the process of refining the data in accordance with a series of normal forms. This is done to reduce data...

Database Normalization

SQL query between dates

To query a date column between specific dates, use below query select count(*) from DW.TB_PCDWH0091_FCT_PROJ_DTL where dw_load_dt between...

SQL query between dates

SQL Case Statement in Oracle

Oracle SQL CASE statement gives you the flexibility to use sql IF ELSE logic in a SELECT, WHERE and JOIN clause. Note: same CASE...

SQL Case Statement in Oracle

Oracle Joins

When you normalize data and create tables inside the database, the data is scattered into different tables. In order to create meaningful...

Oracle Joins

SQL Data-Type conversion functions

SQL conversion functions are single row functions designed to alter the nature of the data type of a column value, expression, or...

SQL Data-Type conversion functions

Create Reports SQL Project

The goal of this project is to test your SQL skills. You would need to use both technical and analytical skills to solve this project....

Create Reports SQL Project

Hotel Booking Application SQL Project

The goal of this project is to test your SQL skills. You would need to use both technical and analytical skills to solve this project....

Hotel Booking Application SQL Project

SQLPATH Environment Variable in Oracle

To execute any .sql script, we will have to go to specific folder which contains .sql script, start sqlplus and then run the script. It...

SQLPATH Environment Variable in Oracle

Oracle REGEXP Functions

The Oracle REGEXP_ functions are used to search and manipulate strings using simple string patterns. These functions can be used in SQL...

Oracle REGEXP Functions
bottom of page