This post is about string aggregation in oracle. Let’s say you have a table structure like below Country State USA CA USA WA USA TX India Tamil Nadu India Kerala India Andhra Pradesh India Karnataka UK Essex UK Surrey UK…
Number of working days – Oracle
Most of us would have come across this task. ie., to find the number of working days between two given dates. Method 1 I got a function to calculate the same from my colleague. function getDays(d1 IN DATE, d2 IN…
I looovvveeeee jQuery
I’ve become a fan of jQuery. The day I started working on JQuery, I keep admiring about the architecture of the framework. As the caption rightly says “Write less and do more”, our source code will be reduced considerably, using…