Leigh Riffel's user avatar
Leigh Riffel's user avatar
Leigh Riffel's user avatar
Leigh Riffel
  • Member for 13 years, 2 months
  • Last seen more than a week ago
48 votes
15 answers
187k views

Eliminate duplicates in ListAgg (Oracle)

32 votes
9 answers
39k views

How do you version your Oracle database changes?

29 votes
4 answers
17k views

Why is OS authentication considered poor security for Oracle databases?

19 votes
9 answers
39k views

Tools to monitor Oracle Database Performance on Standard Edition [closed]

18 votes
3 answers
14k views

What other databases have a feature similar to Oracle's Flashback Query?

16 votes
4 answers
69k views

Execute a script with SQLPlus containing blanks, semi-colons, and forward slashes

13 votes
2 answers
4k views

Security for Application Developers doing PL/SQL work in Oracle

13 votes
2 answers
8k views

Can Oracle be installed on Windows without being an administrator?

13 votes
1 answer
16k views

What are the benefits of packages over standalone procedures and functions?

12 votes
2 answers
2k views

LNNVL Justification

11 votes
2 answers
5k views

Limit redo for materialized view complete refresh or manual equivalent

10 votes
2 answers
4k views

Oracle Shutdown Method

9 votes
1 answer
10k views

Comments in EXPDB parameter file

8 votes
2 answers
2k views

Should date formats be specified in SQL statements?

8 votes
1 answer
3k views

Generate XML using Oracle XML schema

8 votes
1 answer
23k views

What makes an Oracle Applications DBA different from an Oracle DBA?

8 votes
1 answer
1k views

How can a datapump export have its resource usage limited on linux?

7 votes
3 answers
2k views

How can a datapump export have its resource usage limited on windows?

6 votes
2 answers
3k views

Identify which parameters were passed to a procedure (Oracle)

6 votes
3 answers
2k views

Oracle Advanced Queuing LIFO

6 votes
2 answers
2k views

Updating rows conditionally with a gapless ascending value

6 votes
1 answer
249 views

Is Oracle Configuration Manager HIPAA compliant?

6 votes
1 answer
1k views

Package state not re-intialized on raise_application_error

6 votes
2 answers
321 views

Product of n Rows

5 votes
1 answer
996 views

Isssue with Database Links converting OEM Job to DBMS_Scheduler Job

5 votes
1 answer
1k views

What must be in place to validate a XMLTYPE against a schema?

5 votes
2 answers
2k views

FileWatcher Troubleshooting Options

5 votes
2 answers
22k views

Oracle Wallet Setup ORA-12578

5 votes
2 answers
4k views

Determine Index Compression Candidates Online

5 votes
1 answer
3k views

DBMS_Resource_Manager.Calibrate_IO Usage