user avatar
user avatar
user avatar
Chris Saxon
  • Member for 11 years
  • Last seen more than a week ago
11 votes
Accepted

eCommerce orders table. Save prices, or use an audit/history table?

10 votes
Accepted

What queries is Oracle executing, how frequently, and time-taken?

10 votes
Accepted

How and when to use sys_refcursor in oracle

9 votes
Accepted

Can I rely on functions being executed first in SQL

9 votes

Is there any way to break out of the string and inject SQL without using a single quote in oracle?

9 votes
Accepted

Do foreign keys affect performance in Oracle?

8 votes

DBF file exist while user has been dropped?

7 votes
Accepted

Learning to Optimize SQL Queries and Understand Execution Plans - Resources?

7 votes

MySQL Database Schema for Train Timetables

7 votes
Accepted

are there significant differences with 500+ million row tables in Oracle?

5 votes
Accepted

Most efficient and practical way to store time values (HH:MM) in Oracle that makes it easily searchable

5 votes
Accepted

Does 'Cities' deserve a separate table?

5 votes
Accepted

Modifying table structure within a transaction?

5 votes
Accepted

Parsing and binding variables for SELECT .. WHERE column IN ( .. ) queries

4 votes

Designing a Products database: One Products table or many separated by vendor?

4 votes
Accepted

Can this business logic be enforced by a conditional database constraint?

4 votes
Accepted

Conceptual Design of a data warehouse (declaring the grain)

4 votes

Composite indexes: Most selective column first?

3 votes

Multiple JOIN of 6 tables via 5 database instances

3 votes

Outer Join vs Dummy Rows

3 votes

Clustered index in SQL Server vs index organized tables in Oracle

3 votes
Accepted

conversion of high_value to date datatype

3 votes
Accepted

How many database licenses do we need for setting 2 servers (nodes) into a cluster?

3 votes

Is there a bug with PL/Scope in combination with associative arrays?

3 votes

How shared nothing and shared everything architectures look like in Oracle?

3 votes

Materialized view for the last 24 hour period

3 votes

This refactoring from cursor on a dblink'ed Oracle table OK?

3 votes
Accepted

Rankings based on "versus" style matchups?

3 votes
Accepted

FORALL on Nested Collections

3 votes

Why an object became invalid in oracle databse.