Leigh Riffel

less info
meta site favicon meta user | stack exchange network profile network profile
14,081 reputation
32387
bio website isworthy.wordpress.com
location Plantation, FL
age 35
visits member for 2 years, 5 months
seen 3 hours ago
stats profile views 682

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


351 Answers

newest activity votes
0
Oracle schema migration to new database with zero downtime
jun 14 at 13:50
1
Is there a way, in a single SQL statement to ensure that all items in a list are present in some column?
jun 11 at 20:01
14
Should date formats be specified in SQL statements?
mar 6 '12 at 21:40
6
Does SQL Server CASE statement evaluate all conditions or exit on first TRUE condition?
may 29 at 19:07
5
Are there major drawbacks/risk of using oracle blob to store files
may 29 at 20:17
0
How to embed a sub-prodecure call in a SELECT statement in an Oracle 11g PL/SQL stored procedure
may 29 at 19:23
0
how to count primary key of one table inanother table?
may 28 at 15:05
0
Shell: How to time a script running in SQLPlus and kill it after x amount of minutes?
may 28 at 14:47
1
Shell: How to time a script running in SQLPlus and kill it after x amount of minutes?
may 28 at 14:35
1
How do you store tabular data in an RDBMS?
may 28 at 13:42
2
Are individual queries faster than joins?
may 24 at 19:20
1
Tablespace on ephemeral storage
may 22 at 15:42
1
Separate table by often changed / not often changed data?
may 22 at 12:47
2
How do you get the explain plan?
may 31 '12 at 15:26
0
How do I execute an Oracle SQL script without sqlplus hanging on me?
may 21 at 19:05
1
Oracle 10XE: Stop schemas seeing the all_users table?
may 7 at 17:24
0
Creating an admin user in Oracle
apr 22 at 13:52
9
How to permanently delete a row in oracle forever
apr 17 at 20:13
7
Why are constraints applied in the database rather than the code?
apr 17 at 18:05
0
What must be in place to validate a XMLTYPE against a schema?
apr 17 at 14:19
0
Rent weekly cost database design
mar 25 at 12:39
2
Sum Up values in a query based on other information
mar 13 at 13:25
3
need to use PLSQL to insert distinct rows
mar 12 at 17:02
1
Extensible Asset Database Schema
mar 11 at 19:42
1
Package state not re-intialized on raise_application_error
mar 1 at 14:02
11
A database trigger is an alternative for?
feb 27 at 20:08
2
How to check for mutiple rows with same data?
feb 27 at 14:12
0
What's the best practice for representing set operations in a relational database?
dec 26 at 22:01
6
Unit testing of stored procedures
feb 22 at 16:12
2
How to sort category by path and sort order?
feb 21 at 16:44
1 2 3 4 5 … 12