Stack Exchange
log in
chat
meta
about
Stack Exchange
All Sites
Hot Questions
Top Users
Newsletters
Blogs
Rob van Wijk
Utrecht, Netherlands
rwijk.blogspot.com
top
accounts
reputation
activity
favorites
subscriptions
Top Questions
12
votes
Cycle detection with recursive subquery factoring
sql
oracle
db2
hierarchical-query
asked Nov 13 '09 at 20:59
stackoverflow.com
Top Answers
19
Is there a combination of “LIKE” and “IN” in SQL?
stackoverflow.com
18
Group by values that are in sequence
stackoverflow.com
11
CHECK CONSTRAINT of string to contain only digits. (Oracle SQL)
stackoverflow.com
11
Function returning boolean fails on “expression is of wrong type”
stackoverflow.com
9
ORACLE : Materialized view not working when Using LEFT JOIN
stackoverflow.com
9
What is better? Subqueries or inner joining ten tables?
stackoverflow.com
9
Help with “ORA-00907: missing right parenthesis” error please
stackoverflow.com
8
How to index a date column with null values?
stackoverflow.com
8
What does +0 mean after an ORDER BY in Oracle
stackoverflow.com
8
How to use a package constant in SQL SELECT statement?
stackoverflow.com
8
How I find missing elements in a series using SQL?
stackoverflow.com
7
Oracle all foreign key references
stackoverflow.com
6
Display contents of Oracle AQ SYS.AQ$_JMS_TEXT_MESSAGE
stackoverflow.com
6
How to best split csv strings in oracle 9i
stackoverflow.com
6
Oracle join query
stackoverflow.com
6
view with parameters?
stackoverflow.com
6
Storing the time in Oracle
stackoverflow.com
6
data feed for reporting table in oracle (rollup vs grouping sets)
stackoverflow.com
6
limiting union result in oracle
stackoverflow.com
6
bulk compiling pl/sql procedures
stackoverflow.com
6
Is there an efficient way to avoid UNIONs of fixed values in SQL?
stackoverflow.com
6
plsql: Getting another field values along with the aggregation values in a grouping statement
stackoverflow.com
6
How to convert “1985-02-07T00:00:00.000Z” (ISO8601) to a date value in Oracle?
stackoverflow.com
6
Is using “select *” for a cursor in PL/SQL considered bad programming?
stackoverflow.com
6
How can I rewrite this query without repeating SELECT subqueries
stackoverflow.com
5
Calculate the Sum of duration in sql query
stackoverflow.com
5
Oracle Hierarchical query: how to include top-level parent
stackoverflow.com
5
Oracle Calculation Involving Results of Another Calculation
stackoverflow.com
5
What is wrong with my update statement with a join in Oracle?
stackoverflow.com
5
Oracle: formatting number as xxx-xx-xxxx
stackoverflow.com
1
2
next