OraQA

Oracle Question and Answer

  • Do you have a solution to a problem? Do you have an unanswered question? Login and share it with the Oracle community. More...

Oracle News


Entries RSS feed

Comments RSS feed

Author Archive

« Previous Entries
Next Entries »

How to find the longest common substring pattern in different group of strings in SQL

How to divide consecutive rows into groups based on the value of the smallest running total in SQL

How to find the longest add-a-gram using SQL

How to find the shortest possible palindromic pangram in a SQL statement

How to find the largest rectangle of words from a word list in a SQL statement

How to find matched rows between 2 tables based on required matching criteria in a SQL statement

How to assign the same number identifier to different groups that contain the identical set of data in a SQL statement

How to remove duplicate chararacters from a string in a SQL statement (original order retained)

How to find the last consecutive date sequence in a SQL statement

How to find the longest common substring patterns starting from the string head/tail

How to find all leaf path nodes and assign numbers to roots and branches

How to generate multiple rows from a single row based on a date range

How to find all the starting positions and counts of consecutive occurrences of non-alphanumeric characters in a SQL statement

How to count occurrences of characters in a SQL statement

How to re-order characters in a column based on a new Order By rule in a SQL statement

« Previous Entries
Next Entries »