Apr
13
awarded Enlightened
Apr
13
awarded Nice Answer
Apr
9
awarded Nice Question
Apr
7
awarded Great Answer
Mar
31
awarded Popular Question
Mar
21
awarded Notable Question
Mar
12
asked What is meant by the RMAN Duplicate "noncurrent point in time"?
Mar
11
answered SQLPlus Padding in Query Results
Mar
11
asked SQLPlus Padding in Query Results
Feb
27
awarded Yearling
Feb
27
awarded Yearling
Feb
17
awarded Popular Question
Jan
4
awarded Yearling
Jan
4
awarded Yearling
Jan
2
awarded Nice Answer
Dec
16
comment How to check for mutiple rows with same data?
I understood "not select data of multiple rows" to mean that no rows identical to another should be included. This would apply to both the the first (being duplicate of the second) and the second (being a duplicate of the first). If the intention intention of the OP (or the reader) was to eliminate only the secondary instance of the row, then an analytic like yours would be the route to go. (+1)
Dec
9
comment Eliminate duplicates in ListAgg (Oracle)
This query does not return the requested results. It returns the same results as SELECT * FROM ListAggTest;.
Nov
26
comment Optimal value for LOG_BUFFER parameter
Related: asktom.oracle.com/pls/apex/…
Nov
25
revised Optimal value for LOG_BUFFER parameter
deleted 2 characters in body
Nov
18
comment Why is Database Administration so hard?
@Chris Travers To some extent yes, but a good DBA interacts far more with developers and their application code than would a sysadmin.
1 2 3 4 5