What is COALESCE Function in SQL The SQL coalesce function will gives the first non-null string. Syntax: coalesce (strng1, string2, string3 … stringn)Ex: select coalesce('a','b','c'), coalesce(null,'a',null,'b') from dual; coalesce('a','b','c') ----------------------…
LEAST The SQL least function will give the least string. Description & Usage The Oracle LEAST function returns the smallest value in a list of expressions. Syntax: The syntax for…
What is GREATEST Function in SQL SQL greatest function will give the greatest string. Description This function returns the highest value in a list of expressions. Syntax: greatest (strng1, string2,…
DECODE Decode will act as value by value substitution.For every value of field, it will checks for a match in a series of if/then tests. What is DECODE function in…
INSTR The instr() function allows you for searching through a string for set of characters.To show position of character of a string.It will return interger values Syntax: instr (string, search_str…
CHR The CHR function will return the character having the binary equivalent to the string in either the database character set or the national character set. The function returns the…
ASCII This will return the decimal representation in the database character set of the first character of the string.Syntax: ascii (string) Ex: select ascii('a'), ascii('apple') from dual; output ascii('a') -----------…
CONCAT This will be used to combine two strings only.Syntax: concat (string1, string2) Ex: select concat('computer',' operator') from dual; output concat('computer',' operator') -------------------------------- computer operator concatenation in SQL some more…
SOUNDEX This will be used to find words that sound like other words, exclusively used in where clause. This function return the values whose pronunciation as some but spell differently.Syntax:…
REPLACE This will replace the set of characters, string by string.To replace multiple character at a time. Syntax: replace (string, old_chars [, new_chars]) Ex: select replace('india','in','xy'), replace('india','in') from dual; output…