Soundex is one of the amazing function of Oracle. Even though working very well with characters it does not work with numbers. Find out why.… Read More Why Soundex function does not work for numbers?
Raise_application_error is one of the standard procedure of Oracle PL/SQL used to raise exceptions. Learn about it in detail here.… Read More Raise_Application_Error in Oracle PL/SQL
DISTINCT clause is used immensely in Oracle. What is DISTINCT clause? How it differs from UNIQUE clause? Learn here…… Read More DISTINCT clause in Oracle. How it differs from UNIQUE clause?
Soundex function of oracle returns the data of strings that sounds similar to each other. For this function, “peek”, “pick” and “pic” are same. Learn about it in detail here…… Read More Soundex function Oracle
Do you want to know how to write if…then…else condition in Oracle SQL queries? CASE expression will help you to do this. Learn more about it in this post.… Read More CASE expression in Oracle
Is your more than fair amount of time is consumed in silly date functions? Here are 5 useful SQL date queries that can be handy to you.… Read More 5 Useful SQL Date Queries
Do you find traditional oracle joins complicated to handle in your lengthy queries? You can have alternative in the form of ANSI joins which are easily readable and much more comfortable to work with… Read More What are ANSI Joins in Oracle?