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 bookmarks subscriptions
Top Questions
Top Answers
143
Why is Database Administration so hard?
dba.stackexchange.com

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

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

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

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

28
Boolean Field in Oracle
stackoverflow.com

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

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

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

24
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

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

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

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

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

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

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

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

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

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

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

15
Print text in Oracle SQL Developer SQL Worksheet window
stackoverflow.com

15
Unit testing of stored procedures
dba.stackexchange.com

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

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

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

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

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

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

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

1 2 3 4 5