Reputation
4,134
Top tag
Next privilege 5,000 Rep.
Approve tag wiki edits
Badges
7 18
Newest
 Yearling
Impact
~320k people reached

Jun
30
comment Getting milliseconds elapsed during a stored PL/SQL procedure
Normally dbms_utility.get_time is used for debugging purposes: docs.oracle.com/cd/B19306_01/appdev.102/b14258/… . You may also want to use some of DBMS_APPLICATION_INFO procedures to add more information for debugging your code
Jun
29
comment SQL retrieve last elements of table using group by like behaviour
@ypercube : Thanks, I missed that version is not of exact type. updated...
Jun
29
revised SQL retrieve last elements of table using group by like behaviour
added 457 characters in body
Jun
28
awarded  Yearling
Jun
27
comment Is it better to use an ID (int) or a Name (varchar) as PK for a table?
@ ypercube : I can't argue that natural keys are good in many cases; I probably misunderstood your point.
Jun
26
comment Is it better to use an ID (int) or a Name (varchar) as PK for a table?
@ypercube : Not just for clustered index. Updating PK column value can trigger bunch of cascade updates in detail tables , which in turn means more locks and potentially deadlocks.
Jun
26
revised Stored procedure using cursors
added 343 characters in body
Jun
26
comment Stored procedure using cursors
@ hbrock : I think you are wrong about Mysql. it still doesn't suppor window functions.
Jun
26
answered Stored procedure using cursors
Jun
26
answered Strange looking where clause in sql server
Jun
26
comment Syntax error while creating DB2 Trigger
You have FOR EACH ROW twice :...REFERENCING NEW AS N OLD AS O FOR EACH ROW FOR EACH ROW WHEN ...
Jun
26
answered SQL retrieve last elements of table using group by like behaviour
Jun
26
comment How to get the second string in the ORA-02296 error to show something meaningful
How can it help in displaying error details ?
Jun
25
comment Oracle systimestamp result differs in db server and client
You can change session timezone (on client right after establishing connection) : ALTER SESSION SET TIME_ZONE = '+00:00'. You may write AFTER LOGON trigger to do it automatically for each new connection. You can also change db timezone (which affects columns of timestamp with local timezone type). Another option is to have at timezone clause in your queries
Jun
25
comment MySQL “case as column” question in WHERE clause
Sure he can. But in Mysql he doesn't have to...
Jun
24
comment MySQL “case as column” question in WHERE clause
@Ionic: SQLServer (at least 2008R2 ) gives an error if HAVING is used without aggregate function/group by : "Msg 8121: [column] is invalid in the HAVING clause because it is not contained in either an aggregate function or the GROUP BY clause." Or "Invalid column"...
Jun
24
answered MySQL “case as column” question in WHERE clause
Jun
24
comment Persistant inserts in a UDF even if the function aborts
Take a look raghavt.blogspot.ca/2012/05/… .
Jun
24
comment MS-SQL: unique constraint case-insensitive
yes, you need computed column . SQLServer doesn't support function based indexes.
Jun
22
comment MySql stored procedures are not atomic (JDBC)?
Transaction is a logical unit of work , not procedure. With autocommit every single dml statement is executing within the context of its own transaction. So yes, it's expected behaviour.