Skip to main content
OverflowAI is here! AI power for your Stack Overflow for Teams knowledge community. Learn more
Chris Saxon's user avatar
Chris Saxon's user avatar
Chris Saxon's user avatar
Chris Saxon
  • Member for 12 years, 10 months
  • Last seen more than a month ago
12 votes
Accepted

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

11 votes
Accepted

How and when to use sys_refcursor in oracle

10 votes
Accepted

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

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?

9 votes
Accepted

Can I rely on functions being executed first in SQL

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?

6 votes
Accepted

Modifying table structure within a transaction?

5 votes
Accepted

Does 'Cities' deserve a separate table?

5 votes
Accepted

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

5 votes
Accepted

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

5 votes

Composite indexes: Most selective column first?

4 votes
Accepted

Conceptual Design of a data warehouse (declaring the grain)

4 votes

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

4 votes

Materialized view for the last 24 hour period

4 votes
Accepted

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

4 votes

Separate or Combine 2 Tables with Similar Attributes?

3 votes

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

3 votes

Outer Join vs Dummy Rows

3 votes

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

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

Why an object became invalid in oracle databse.

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