83 reputation
19
bio website
location
age
visits member for 2 years, 1 month
seen 16 hours ago

Oct
16
comment How to detect in which schema a procedure is called?
@jms yes, we literally answered the question at the same time.
Oct
15
answered How to detect in which schema a procedure is called?
Oct
15
comment Ensuring that 1 row has 5 specific records referencing it
Out of curiosity, does Postgres by default defer constraint checking until the commit of a transaction? You might need to set the constraint fk_test_case__test_case as deferred.
Oct
10
comment ORA-00937 when calculating a sub-value in an aggregate select statement
@ypercube you are right, max works well. D oI have to put it in the question to make it clear for the reader?
Oct
9
comment Need query for the below problem
@ypercube: sorry, my first link. I confused dispkayed value with link content. Here you go: http://dba.stackexchange.com/questions/78805/ora-00937-when-calculating-a-sub-v‌​alue-in-an-aggregate-select-statement.
Oct
9
comment Need query for the below problem
@ypercube: the proposed extension still does not work in Oracle. This question is in more than one respect not a duplicate at all. 1) Oracle allows user-defined aggregate-funcitons. 2) Your linked solution does not work in Oracle. To shed some light on the question why Oracle does not behave as expected, I posted a question on this site: http://dba.stackexchange.com/questions/78805/ora-00937-when-calculating-a-sub-v‌​alue-in-an-aggregate-select-statement.
Oct
9
revised ORA-00937 when calculating a sub-value in an aggregate select statement
added 856 characters in body
Oct
9
asked ORA-00937 when calculating a sub-value in an aggregate select statement
Oct
9
revised Need query for the below problem
deleted 2 characters in body
Oct
9
answered Need query for the below problem
Oct
9
comment Need query for the below problem
@ypercube: Your answer: yes, except the comments. Also I tested it on my oracle 11gR2. The part (not exists (... delivers a boolean valued result, which is interpreted in old C-fashion as 0 or 1 in MySQL and helps your implementation. This seems to be not quite SQL standard.
Oct
9
awarded  Commentator
Oct
9
comment Need query for the below problem
@ypercube the linked solution is mysql-compatible, but not with oracle.
Oct
9
comment Need query for the below problem
LN(0) is not defined, you need to extend your where-clause by and Value > 0.
Sep
24
comment Oracle 12c Installation in Windows 7 error INS-30131
Adding a share helped, thanks a lot!
May
23
awarded  Popular Question
May
14
comment Oracle Scheduled Job Stays in State RUNNING
@Phil: thanks for the hint, I will investigate this.
May
14
asked Oracle Scheduled Job Stays in State RUNNING
Sep
14
awarded  Notable Question
May
30
comment Oracle database link via ODBC to SQL Server does not recover automatically
OK, I will try to analyse the logfiles, and come back to you after that. Do you have a link which lists the 12+ ODBC errors?