Leigh Riffel

less info
meta site favicon meta user | stack exchange network profile network profile
13,712 reputation
32285
bio website isworthy.wordpress.com
location Plantation, FL
age 35
visits member for 2 years, 4 months
seen 2 days ago
stats profile views 655

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


338 Answers

newest activity votes
7
What is the difference between an INNER JOIN and an OUTER JOIN ?
7
What's the difference between DBA and DA?
7
Does the SELECT statement count into DML?
7
Multidimensional indices in databases
6
How much does an index need to narrow the results of a search in order to be useful?
6
What happens when you modify (reduce) a column's length?
6
Does Oracle PL/SQL have a standard ASSERT routine?
6
Oracle RAC on Virtual machine
6
Grant create permission on a specific schema in Oracle 11g
6
Alternatives to concatenating strings or going procedural to prevent SQL query code repetition?
6
Do I need to enumerate the columns used in a materialized view when creating the MV log?
6
MAX for each subset
6
Is Oracle DB licensing needed for a test environment?
6
When refreshing materialised views does the index automatically refresh
6
Running a stored procedure across db Link
6
Tracing, debugging and fixing Row Lock Contentions
6
How do I implement a database/table as a stack
6
How different are the top DB vendor's SQL (DML-) dialects from each other?
5
Unit testing of stored procedures
5
Having multiple refs in an intersection table
5
Using Multi-table Insert for Parent and Child Table
5
Proper use of NULL, and utilizing CHECK constraints for business logic vs stored procedures
5
What exactly is “pinning” in relation to indexes?
5
Is to possible to forbid access to tables in own schema - Oracle?
5
Joining two tables on multiple criteria
5
How do I sync instance A to instance B without losing any of the data already on instance B?
5
How to select the first row of each group?
5
What are the mandatory/required oracle 11g tablespaces?
5
oracle format specifiers: to_number vs to_char
5
For Oracle, we mount the instance to the database or mount the database to the instance?
1 2 3 4 5 … 12