constraints

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 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 →