user avatar
user avatar
user avatar
Vincent Malgrat
  • Member for 11 years, 5 months
  • Last seen this week
  • Paris, France
17 votes
Accepted

What are the causes and solutions for mutating table errors?

15 votes

forensically deleting/updating data

15 votes
Accepted

Why does SQL*PLUS need a slash after CREATE TYPE?

14 votes

How to implement a 'default' flag that can only be set on a single row

14 votes

When a record is locked in Oracle, can we know which record is locked?

11 votes

Oracle - Any way to view uncommited changes to a particular table?

10 votes
Accepted

How to document Oracle database?

10 votes
Accepted

How to combine `delete` and `insert` operations in one statement?

10 votes
Accepted

Oracle: Non key-preserved table should be

9 votes
Accepted

Using the same sequence twice in a PL/SQL statement

9 votes

Oracle With Statement and Delete Together

9 votes

How do you get the explain plan?

8 votes
Accepted

Option to tell Toad to never split a file which contains multiple objects?

8 votes
Accepted

Why does it take a long time to drop a function based index in Oracle?

8 votes

Clustered index in SQL Server vs index organized tables in Oracle

7 votes

I killed a session and it is still running?

7 votes
Accepted

Oracle start database with incorrect password

7 votes
Accepted

Compare dates problems

7 votes
Accepted

Updating rows conditionally with a gapless ascending value

7 votes

Tracing, debugging and fixing Row Lock Contentions

7 votes

Why am I not seeing any benefits of parallel execution when parallel clause is used?

6 votes
Accepted

How to convert a Top 1 subquery using outer table alias to Oracle?

6 votes
Accepted

How to connect to a remote Oracle server from Windows machine using PL/SQL Developer?

6 votes

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

6 votes

Commit vs Fast Commit vs Commit Cleanout in Oracle Database

6 votes

Create a "barrier" (prevent parallel execution) in Oracle PL/SQL?

5 votes

How to troubleshoot enq: TX - row lock contention?

5 votes
Accepted

Generating an arithmetic sequence

5 votes

forcing Oracle to use hash join for a subquery

5 votes

€ Euro sign/symbol not showing up on Oracle 10gr2 and aix 6.1