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

Archive for the 'SQL' Category

« Previous Entries
Next Entries »

How to simulate this special recursive update and merge of data in SQL

How to solve the Multiples of single digits Puzzle in SQL

How to solve the Vier-Neun Puzzle in SQL

How to display the contents of a column of ANYDATA data type in SQL

How to solve this “Div9″ Puzzle in SQL

How to compute the i-th Fibonacci number in SQL

How to find permutations such that adjacent numbers form a base-10 number are not divisible by 3, 4, or 5 in SQL

How to find the earliest day that is at least one year after the prior calculated date in SQL

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 add years, months and days to a date

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

« Previous Entries
Next Entries »