Category: Oracle PL SQL

Learn how to use a Time stamp data type ,how to convert a Time stamp in string format to a string Timestamp format using TO_TIMESTAMP

Learn how to convert a date in string format to a string Date format using TO_DATE function and Date literal formats. Also Learn how to

Distinct Values – Learn how to select distinct values in a table with and Without using SQL DISTINCT keyword with example queries. Below is the DUP_VALUES_TBL 

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

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