User Chris Saxon

13 votes

Accepted

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

answered Feb 3, 2014 at 21:58

11 votes

Accepted

How and when to use sys_refcursor in oracle

answered Feb 5, 2013 at 21:14

10 votes

Accepted

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

answered Mar 4, 2013 at 12:40

9 votes

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

answered Feb 12, 2013 at 12:44

9 votes

Accepted

Do foreign keys affect performance in Oracle?

answered Apr 18, 2018 at 13:11

9 votes

Accepted

Can I rely on functions being executed first in SQL

answered Jul 30, 2012 at 12:10

8 votes

DBF file exist while user has been dropped?

answered Nov 20, 2012 at 8:56

7 votes

Accepted

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

answered Jul 9, 2012 at 16:32

7 votes

MySQL Database Schema for Train Timetables

answered Sep 20, 2012 at 19:43

7 votes

Accepted

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

answered Feb 16, 2013 at 15:56

6 votes

Accepted

Modifying table structure within a transaction?

answered Sep 29, 2011 at 11:30

5 votes

Accepted

Does 'Cities' deserve a separate table?

answered Aug 19, 2012 at 18:02

5 votes

Accepted

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

answered Jan 8, 2013 at 12:27

5 votes

Accepted

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

answered May 14, 2013 at 8:08

5 votes

Composite indexes: Most selective column first?

answered Jan 31, 2017 at 20:08

4 votes

Accepted

Conceptual Design of a data warehouse (declaring the grain)

answered Feb 12, 2013 at 8:44

4 votes

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

answered Jan 23, 2013 at 12:04

4 votes

Materialized view for the last 24 hour period

answered Dec 13, 2012 at 9:52

4 votes

Accepted

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

answered Sep 16, 2012 at 14:26

4 votes

Separate or Combine 2 Tables with Similar Attributes?

answered Dec 30, 2012 at 16:33

3 votes

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

answered Dec 5, 2012 at 20:20

3 votes

Outer Join vs Dummy Rows

answered Jan 28, 2013 at 10:28

3 votes

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

answered Jan 10, 2013 at 17:17

3 votes

Clustered index in SQL Server vs index organized tables in Oracle

answered Feb 8, 2013 at 9:05

3 votes

Accepted

conversion of high_value to date datatype

answered Feb 8, 2013 at 13:38

3 votes

Accepted

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

answered Feb 12, 2013 at 8:30

3 votes

Why an object became invalid in oracle databse.

answered Oct 15, 2012 at 16:33

3 votes

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

answered Jun 18, 2012 at 13:26

3 votes

Accepted

Rankings based on "versus" style matchups?

answered Jun 29, 2011 at 15:54

3 votes

Accepted

FORALL on Nested Collections

answered Aug 16, 2012 at 8:06

Stack Exchange Network

56 Answers

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

How and when to use sys_refcursor in oracle

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

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

Do foreign keys affect performance in Oracle?

Can I rely on functions being executed first in SQL

DBF file exist while user has been dropped?

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

MySQL Database Schema for Train Timetables

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

Modifying table structure within a transaction?

Does 'Cities' deserve a separate table?

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

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

Composite indexes: Most selective column first?

Conceptual Design of a data warehouse (declaring the grain)

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

Materialized view for the last 24 hour period

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

Separate or Combine 2 Tables with Similar Attributes?

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

Outer Join vs Dummy Rows

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

Clustered index in SQL Server vs index organized tables in Oracle

conversion of high_value to date datatype

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

Why an object became invalid in oracle databse.

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

Rankings based on "versus" style matchups?

FORALL on Nested Collections