3,344 reputation
313
bio website
location Paris, France
age 34
visits member for 3 years, 7 months
seen Aug 8 at 13:22

Jul
21
answered Nested table as condition prevents using index
Jun
20
answered SQL query for all combinations without repetition
Mar
5
answered Is using dbms_utility.format_error_stack to filter errors in the exception block a bad idea?
Feb
3
revised ORA-12899 when creating varchar virtual column based on numeric column
added 738 characters in body
Feb
3
answered ORA-12899 when creating varchar virtual column based on numeric column
Jan
19
awarded  Yearling
Jan
17
revised How can I delete rows in an oracle table from xml input parameter?
edited body
Jan
16
answered How can I delete rows in an oracle table from xml input parameter?
Jan
16
revised How can I delete rows in an oracle table from xml input parameter?
deleted 3 characters in body
Jan
16
revised PreparedStatement caching size on Oracle and SQL Server
deleted 2 characters in body
Nov
26
comment DDL trigger AFTER ALTER ON SCHEMA behavior
It looks like the trigger fires while the DDL is not completely finished. This seems to happen if you add any constraint with a column. I have no idea why.
Nov
6
answered Oracle - how to reference to a field%TYPE using database links?
Sep
23
comment Oracle Equivalent of PostgreSQL CLUSTER
There are also indexed clusters which are a little more practical since the number of keys is unlimited (though you need a rough estimate of the number of entries per key).
Jun
20
revised Can I grant privileges to a role without specifying an object?
added 817 characters in body
Jun
20
answered Can I grant privileges to a role without specifying an object?
Jun
11
answered How to combine `delete` and `insert` operations in one statement?
Jun
11
comment How to combine `delete` and `insert` operations in one statement?
What table do you want to insert into?
May
31
answered Different dates Oracle 11g with TOAD
May
30
answered How to manage constants within an Oracle Database
May
23
answered Filter on a window function without writing an outer SELECT statement