Stack Exchange

Leigh Riffel

Plantation, FL

http://isworthy.wordpress.com

Oracle Database Administrator

Oracle Certified Professional (OCP)
Oracle Database SQL Certified Expert

profile for Leigh Riffel on Stack Exchange, a network of free, community-driven Q&A sites

top accounts reputation activity favorites subscriptions
Top Questions
Top Answers
143
Why is Database Administration so hard?
dba.stackexchange.com

53
How do I limit the number of rows returned by an Oracle query after ordering?
stackoverflow.com

48
Pasting text into Excel without splitting on spaces (or other delimiter)
superuser.com

40
How should I best name my timestamp fields?
dba.stackexchange.com

28
Boolean Field in Oracle
stackoverflow.com

27
How do I Create Tablespace in Oracle 11g?
dba.stackexchange.com

26
What is the difference between Oracle's VARCHAR and VARCHAR2 datatypes?
dba.stackexchange.com

25
How to select the first row of each group?
dba.stackexchange.com

23
How do I ignore ampersands in a SQL script running from SQL Plus?
stackoverflow.com

22
Idiomatic way to implement UPSERT in PostgreSQL
dba.stackexchange.com

21
What is the difference between sys and system accounts in Oracle databases?
dba.stackexchange.com

18
How could DBAs be more 'programmer friendly'?
dba.stackexchange.com

17
Is there any difference between Rem and — comments for SQL*Plus?
dba.stackexchange.com

17
Tombstone Table vs Deleted Flag in database syncronization & soft-delete scenarios
dba.stackexchange.com

17
Top 5 time-consuming SQL queries in Oracle
stackoverflow.com

16
Oracle Sequence starting with 2 instead of 1
stackoverflow.com

16
Difference between GROUP BY B,A and GROUP BY COALESCE(B,A)
dba.stackexchange.com

15
Unit testing of stored procedures
dba.stackexchange.com

15
Reason to not use nullable number in Oracle?
dba.stackexchange.com

15
Does SQL Server CASE statement evaluate all conditions or exit on first TRUE condition?
dba.stackexchange.com

15
How do indices impact query performance?
dba.stackexchange.com

15
Why are constraints applied in the database rather than the code?
dba.stackexchange.com

14
Should date formats be specified in SQL statements?
dba.stackexchange.com

14
What exactly is a database engine?
dba.stackexchange.com

14
What are the best software tools for personal finance?
money.stackexchange.com

14
Recovering logical space from a tablespace
dba.stackexchange.com

13
Where can I find example databases for MySQL, SQL Server and Oracle?
dba.stackexchange.com

13
Running a stored procedure across db Link
dba.stackexchange.com

12
How do long columns impact performance and disk usage?
dba.stackexchange.com

12
What happens when you modify (reduce) a column's length?
dba.stackexchange.com

1 2 3 4 5