Skip to main content
Share Your Experience: Take the 2024 Developer Survey
David Aldridge's user avatar
David Aldridge's user avatar
David Aldridge's user avatar
David Aldridge
  • Member for 11 years, 2 months
  • Last seen more than 1 year ago
  • Haddenham, United Kingdom
19 votes
Accepted

Partitioning vs Indexes

18 votes

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

12 votes

Is Oracle free to download?

8 votes

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

7 votes
Accepted

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

6 votes

Oracle trigger to update columns daily

6 votes
Accepted

Using dynamic sql inside Oracle stored procedure

5 votes

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

4 votes

Best cloud platform for PostgreSQL

4 votes

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

4 votes
Accepted

Efficiently store time based data

4 votes

Oracle 11g: performance improvements of inserts

4 votes

Is shrink a safe online operation?

4 votes

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

4 votes

Need an idea for a complex SQL question

3 votes

Prune unused joins

3 votes
Accepted

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

3 votes

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

3 votes

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

3 votes
Accepted

Deleting large amount of data in ORACLE

3 votes

Data Warehouse Design and Double Dipping

3 votes

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

3 votes

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

3 votes

Oracle Equivalent of PostgreSQL CLUSTER

3 votes

How to manage constants within an Oracle Database

2 votes

Achieving best practice schema and permissions management on PostgreSQL

2 votes

Duplicate Conditions in PostgreSQL Query

2 votes

Example optimisic offline lock in SQL/PL?

2 votes

Optimizing bulk update performance in PostgreSQL

2 votes

oracle huge hash_area_size