Create a Table from another Table in Oracle SQL
In my previous article, you have seen how to create a Table and Global Temporary …
Learn SQL
SQL stands for Structure Query Language that is used to modify and access data from a database like Oracle, SQL Server etc.
Create Normal Table and Global Temporary Table in Oracle
We can create two types of Table in Oracle. 1) Normal Table (CREATE TABLE Command) …
Create Normal Table and Global Temporary Table in Oracle Read More »
Alter Table Command in Oracle SQL
The ALTER TABLE command allows you to rename an existing Oracle table to a new …
How to use LPAD and RPAD Function
If you want to pad any character on the left side or right side of …
How to Create Index in Oracle SQL with Example
What is an Index? Index is created on existing tables to retrieve data more quickly. …
NVL, DECODE, NVL2, COALESCE-NULL Functions in Oracle
This article will provide you a summary of the NULL functions available for handling null …
NVL, DECODE, NVL2, COALESCE-NULL Functions in Oracle Read More »
Difference in RANK, DENSE_RANK, FIRST and LAST Analytic Functions
This article gives you an overview of the RANK, DENSE_RANK, FIRST and LAST analytic functions. …
Difference in RANK, DENSE_RANK, FIRST and LAST Analytic Functions Read More »
SQL Tips: LAG and LEAD Analytic Functions
LAG and LEAD functions can be used in Oracle PL/SQL and apply on Oracle 12c, …
How to Escape Special Characters in Oracle SQL queries
Whether you are working as PL/SQL developer or ETL developer or Data Warehousing Developer or …
How to Escape Special Characters in Oracle SQL queries Read More »