Mumbai attacked again…..nothing new….thats what most of the population other than mumbaikar says that. They are more concerned that they are safe rather than India is safe. But they don’t know that tomorrow they can be targeted or there city can be targeted. Basically we as a Indians have a tendency to forget such unhuman [...]
Archive for November, 2008
Mumbai attacked again…
Posted in General Talk on November 27, 2008 | Leave a Comment »
Example : Analytic Function
Posted in Technical on November 24, 2008 | Leave a Comment »
We will begin with how aggregate function is different from Analytic Function. We will start with some example.
Query 1 : Select branch_id, count(*) Branch_Count from emp where branch_id in (10,30);
Output :
branch_id Branch_Count
10 5
20 [...]
Oracle : Analytic Function
Posted in Oracle, Technical on November 24, 2008 | Leave a Comment »
Basically this post is meant for PL/SQL coders who might not be using analytic function (like me) due to very complex syntax. Personally i found analytic function to be very useful and recently i used it in my project since there was requirement which can be fulfilled only Analytic Function. So i can say my [...]
Oracle : Translate Function
Posted in Oracle on November 20, 2008 | Leave a Comment »
Most of them might be knowing Translate Function in Oracle.The TRANSLATE function allows you to replace characters in an expression that appear in a from string to their corresponding character in the to string. For Example :
select translate(‘Rishi*Daftary’,’*’,’#’) from dual;
Above query will replace all the occurence of * to #. But the main problem here [...]
