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

How to filter and locate the position of non-alphanumeric characters in a SQL statement

How to display combinations using the table format in a SQL statement

How to collapse all nulls for every table column in a SQL statement

How to replace the data of the Target table with the data of the Source table in a SQL statement

How to compute numbers that the sum of all its digits are divisible by three in a SQL statement

How to compute numbers that are both divisible by seven and when the digits are reversed are still divisible by seven in a SQL Statement?

« Previous Entries
Next Entries »