15,586 reputation
53399
bio website isworthy.wordpress.com
location Plantation, FL
age 36
visits member for 3 years, 6 months
seen 8 hours ago

Feb
12
awarded  Notable Question
Jan
18
awarded  Notable Question
Jan
16
awarded  Notable Question
Jan
4
awarded  Yearling
Dec
28
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
30
awarded  Notable Question
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.
Sep
26
revised SQL Server backup fails on disk space error
edited tags; edited tags
Sep
26
reviewed Approve suggested edit on concat tag wiki
Sep
26
reviewed Approve suggested edit on concat tag wiki excerpt
Sep
26
answered Optimizing UDF - Is Using DUAL Expensive
Sep
23
revised Oracle SQL - CASE in a WHERE clause
edited tags
Sep
23
revised Software Engineers and DBAs
added 28 characters in body; edited title
Sep
12
comment Oracle empty string converts to null
@Phil Not a problem. I think you addressed the real core of the confusion.
Sep
12
answered Oracle empty string converts to null
Sep
12
comment Oracle empty string converts to null
You get no results using WHERE f= '' for the same reason you get no results using WHERE f=NULL. In Oracle '' and NULL are the same so they both evaluate to false.