SQL

SQL (Structured Query Language) is a standard language used to operate relational databases. It includes operations such as database creation, retrieving and modifying data, granting privileges to data.

Thumbnail image for The Difference between DELETE, TRUNCATE and DROP

The Difference between DELETE, TRUNCATE and DROP

DELETE, TRUNCATE and DROP – all three commands get rid of table data. How exactly are they different? When should you use which?

Read the Full Article →
Thumbnail image for Nth Highest Salary in Oracle

Nth Highest Salary in Oracle

“How can I select the Nth highest salary of the EMP table?” The answer to the problem of finding the Nth highest salary. You can extend this logic to find the Nth highest row of any table.

Read the Full Article →
Thumbnail image for How to Validate Email Address in SQL

How to Validate Email Address in SQL

In applications that take user email id as input, there is a need to check for email id validity. Here is a an way to validate email address, using regular expressions in Oracle SQL.

Read the Full Article →
Regular Expressions in Oracle

Regular Expressions in Oracle Made Easy

A regular expression (also called regex or regexp for short) is a sequence of characters that describes a pattern in text. Tips and examples about how to regular expression in SQL

Read the Full Article →