Learn how to fetch top N rows using SQL TOP, ROWNUM, LIMIT, FETCH clauses with example queries. Row Limiting clause is useful to limit the
Master OOP using Java with NEW Approach, so you can stand out from the crowd. In fact, you’ll have better knowledge than 99% people. That’s
Learn how to write SQL queries for questions given below. Queries are based on the Employee and Incentives tables given below. Let’s prepare the both
Learn how to extract a DAY,MONTH,YEAR,HOUR,MINUTE AND SECOND from a date time data type values. EXTRACT function extracts a date or a timestamp and returns
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
Learn how perform one to one character replacement using translate function with example queries. TRANSLATE function performs character to character replacement and returns a string
Learn how to replace matching string with another string using replace function with example queries. REPLACE function replaces a search string with replacement string. Syntax
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