15,306 reputation
43194
bio website isworthy.wordpress.com
location Plantation, FL
age 36
visits member for 3 years, 3 months
seen Mar 12 at 19:48

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.
Sep
9
awarded  Nice Question
Aug
23
reviewed Approve suggested edit on duplication tag wiki
Aug
23
reviewed Approve suggested edit on duplication tag wiki excerpt
Aug
7
awarded  Popular Question
Aug
5
answered Trigger in trigger or trigger before table creation
Aug
1
answered FileWatcher Troubleshooting Options
Jul
30
comment FileWatcher Troubleshooting Options
That's a good thing to check, but in my case is not the problem.
Jul
27
revised Calculating percentage of a row over total sum
Misleading transposition.
Jul
22
asked FileWatcher Troubleshooting Options
Jul
22
reviewed Approve suggested edit on Open source tools for Oracle schema compares
Jul
17
reviewed Leave Open How to join multiple tables (SQL) to find the difference between an order and shipped quantities?