Author: Viswanath A

Learn how to transpose columns to rows using oracle UNPIVOT clasuse UNPIVOT clause allows transpose columns to rows. UNPIVOT is purely opposite to PIVOT clause

Learn how to find the position of a sub string from the main string with oracle INSTR function with example queries. INSTR –tells the position

Learn how to find a sub string from the main string using oracle SUBSTR function The SUBSTR() function returns a substring from the str starting

Learn about pattern matching and pattern to be searched for within a longer piece of text. Regular Expression A sequence of symbols and characters expressing

Learn how to retrieve the matching strings from the table using pattern matching with regular expressions. The Oracle REGEXP_LIKE condition allows you to perform regular

Learn how to find the position of a matching character or a matching string from the input string using INSTR function with example queries. REGEXP_INSTR

Learn how extract a sub-string from the given input string with example queries. REGEXP_SUBSTR function is an extension of the SUBSTR function. REGEXP_SUBSTR extractS a

Learn how to count the number of occurrences of the given sub-string present in the input string with example queries. REGEXP_COUNT returns the number of

Learn how to replace a string with another string using REGEXP_REPLACE with example queries. REGEXP_REPLACE -replace all occurrences of a substring that match a regular