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 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 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 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 find a sub string from the main string using oracle SUBSTR function The SUBSTR() function returns a substring from the str starting
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 write a short hints in the input fields for user understanding when filling any application. Placeholder Attribute in HTML- Placeholder is an
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 write a dynamic sql query in “for PIVOT In Clause”. Generally in “for PIVOT In Clause” only constant values are allowed as
Learn how to converts rows into columns using SQL pivot with Example queries. The PIVOT operator takes data in separate rows, aggregates it and converts