Where Vs Having In SQL

21-05-2012 The Having clause can only be used when you are using the group by phrase. When you are using the Group By phrase in a query, you can use the Having clause for pretty much everything you can do with the Where clause. But not vise versa. The where clause doesn’t support aggregate functionsContinue reading “Where Vs Having In SQL”

A stored procedure that can auto-genarate SQL queries using exec method

06-10-2011 http://pagead2.googlesyndication.com/pagead/show_ads.js Have you ever wanted to write a flexible and dynamic¬†stored procedure that would allow you to send the table name as a parameter? Have you ever wanted to write a flexible¬†and dynamic stored procedure that would allow you to send only the condition but also the column name you want to include inContinue reading “A stored procedure that can auto-genarate SQL queries using exec method”

Oracle Trunc Function

2008-11-24 Among various helpful functions provided by Oracle, Trunc function took my attention today because I had to fix a defect where some one has misunderstood and misused this function. As the name itself suggests, the trunc function is capable of truncating a value. This function can be used either on a date type valueContinue reading “Oracle Trunc Function”