User David Aldridge

19 votes

Accepted

Partitioning vs Indexes

answered Jul 8, 2013 at 23:04

18 votes

Why are constraints applied in the database rather than the code?

answered Apr 12, 2013 at 18:36

12 votes

Is Oracle free to download?

answered Sep 18, 2013 at 15:49

8 votes

Getting SELECT to return a constant value even if zero rows match

answered Apr 27, 2013 at 19:05

7 votes

Accepted

How to retrieve disk spaces by removing tables from tablespaces in Oracle 10g?

answered Jan 23, 2013 at 9:12

6 votes

Oracle trigger to update columns daily

answered Mar 28, 2013 at 8:31

6 votes

Accepted

Using dynamic sql inside Oracle stored procedure

answered May 1, 2013 at 9:19

5 votes

How make convincing case to DBA to use Oracle external tables for 500 MB to 5 GB files?

answered Jul 8, 2013 at 23:40

4 votes

Best cloud platform for PostgreSQL

answered Aug 28, 2013 at 13:09

4 votes

Oracle: finding rows without children in a table with a foreign key?

answered Apr 6, 2015 at 9:53

4 votes

Accepted

Efficiently store time based data

answered Apr 2, 2017 at 16:38

4 votes

Oracle 11g: performance improvements of inserts

answered Mar 26, 2013 at 10:08

4 votes

Is shrink a safe online operation?

answered May 24, 2013 at 18:02

4 votes

Transactions, references and how to enforce double entry bookkeeping? (PG)

answered Jun 4, 2013 at 10:09

4 votes

Need an idea for a complex SQL question

answered Jun 5, 2013 at 11:11

3 votes

Prune unused joins

answered Jun 12, 2013 at 13:28

3 votes

Accepted

Is it possible to define package procedure/function outside of package body block (for Oracle)?

answered May 24, 2013 at 9:00

3 votes

Ideal frequency to gather table statistics in Oracle for database of 1GB in size

answered Apr 26, 2013 at 9:24

3 votes

Storing no of players the last seven days in an online game

answered Apr 28, 2013 at 17:56

3 votes

Accepted

Deleting large amount of data in ORACLE

answered Apr 6, 2017 at 13:30

3 votes

Data Warehouse Design and Double Dipping

answered Nov 7, 2016 at 17:45

3 votes

Selecting from a function that returns a sys refcursor or an alternative

answered Sep 9, 2013 at 10:54

3 votes

ORA-30036: unable to extend segment by 8 in undo tablespace 'UNDOTBS1'

answered Sep 17, 2013 at 6:37

3 votes

Oracle Equivalent of PostgreSQL CLUSTER

answered Sep 25, 2013 at 9:14

3 votes

How to manage constants within an Oracle Database

answered Jun 29, 2013 at 16:17

2 votes

Achieving best practice schema and permissions management on PostgreSQL

answered Nov 22, 2021 at 8:58

2 votes

Duplicate Conditions in PostgreSQL Query

answered Mar 11, 2022 at 8:32

2 votes

Example optimisic offline lock in SQL/PL?

answered Aug 15, 2013 at 12:40

2 votes

Optimizing bulk update performance in PostgreSQL

answered Apr 27, 2013 at 19:40

2 votes

oracle huge hash_area_size

answered Mar 20, 2013 at 18:59

Stack Exchange Network

64 Answers

Partitioning vs Indexes

Why are constraints applied in the database rather than the code?

Is Oracle free to download?

Getting SELECT to return a constant value even if zero rows match

How to retrieve disk spaces by removing tables from tablespaces in Oracle 10g?

Oracle trigger to update columns daily

Using dynamic sql inside Oracle stored procedure

How make convincing case to DBA to use Oracle external tables for 500 MB to 5 GB files?

Best cloud platform for PostgreSQL

Oracle: finding rows without children in a table with a foreign key?

Efficiently store time based data

Oracle 11g: performance improvements of inserts

Is shrink a safe online operation?

Transactions, references and how to enforce double entry bookkeeping? (PG)

Need an idea for a complex SQL question

Prune unused joins

Is it possible to define package procedure/function outside of package body block (for Oracle)?

Ideal frequency to gather table statistics in Oracle for database of 1GB in size

Storing no of players the last seven days in an online game

Deleting large amount of data in ORACLE

Data Warehouse Design and Double Dipping

Selecting from a function that returns a sys refcursor or an alternative

ORA-30036: unable to extend segment by 8 in undo tablespace 'UNDOTBS1'

Oracle Equivalent of PostgreSQL CLUSTER

How to manage constants within an Oracle Database

Achieving best practice schema and permissions management on PostgreSQL

Duplicate Conditions in PostgreSQL Query

Example optimisic offline lock in SQL/PL?

Optimizing bulk update performance in PostgreSQL

oracle huge hash_area_size