83 reputation
19
bio website
location
age
visits member for 2 years, 2 months
seen Nov 21 at 8:24

Oct
29
revised ORA-01410 Error
added 1263 characters in body
Oct
27
revised ORA-01410 Error
added 3 characters in body
Oct
27
answered ORA-01410 Error
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.