Stack Exchange

David Faber

East Coast

Software engineer since 1994. SQL, Oracle, Solr, ColdFusion, regular expressions, JS, Python

top accounts reputation activity subscriptions
Top Questions
No questions with score of 5 or more
Top Answers
49
MySQL - Conditional COUNT with GROUP BY
stackoverflow.com

30
Split function in oracle to comma separated values with automatic sequence
stackoverflow.com

25
Oracle update multiple spaces in a column with a single space
stackoverflow.com

25
Handling Null in Greatest function in Oracle
stackoverflow.com

22
ORA-01849: hour must be between 1 and 12
stackoverflow.com

17
Is "NUMBER" and "NUMBER(*,0)" the same in Oracle?
stackoverflow.com

12
How to join two tables based on substring values of fields?
stackoverflow.com

11
How to calculate average of a column and then include it in a select query in oracle?
stackoverflow.com

10
Is there an elegant way to dynamically generate a query based on the values of a list?
stackoverflow.com

9
Oracle: subtract millisecond from a datetime
stackoverflow.com

9
regex to replace backslash and single quote with single quote using postgres regexp_replace()
stackoverflow.com

9
Conditional Select from different tables
stackoverflow.com

8
Solr date field format
stackoverflow.com

8
coldFusion Regular Expression for "number tab tab"
stackoverflow.com

8
Using a case statement in a check constraint
stackoverflow.com

8
When I enter a dateadd or datediff code i get this error all the time "ORA-00904 "DATEADD" INVALID IDENTIFIER."
stackoverflow.com

7
How do I consume a ColdFusion webservice from C#?
stackoverflow.com

7
Regex must start with a letter or number, string can only have letters, numbers or slashes, and no double slashes
stackoverflow.com

7
Get count of specifc rows returned in cfquery
stackoverflow.com

6
Oracle: How much averaged per month?
stackoverflow.com

6
Solr (sunspot) Query with Hyphen and Stop Words
stackoverflow.com

6
mysql find numbers in query that are NOT in table
stackoverflow.com

6
Oracle - need to extract text between given strings
stackoverflow.com

6
Find which character occurs the greatest number of times in a string
stackoverflow.com

6
Need help understanding Coldfusion URL Referral
stackoverflow.com

6
How can you tell if a value is not numeric in Oracle?
stackoverflow.com

6
select rows having time difference less than 2 hour of a single column
stackoverflow.com

6
How to use PBKDF2 in Oracle 12c?
stackoverflow.com

5
In ColdFusion how can I match a posted password to an SHA256 encrypted password in my table?
stackoverflow.com

5
Finding matching items in parallel lists
stackoverflow.com

1 2