I spotted this question on Super User about creating parameterized queries in Excel 2007 and attempted to answer it – as I thought it would be pretty easy. And well – it was easy – the part part where you create the query, that is. Now creating parameterized queries – now that’s something totally different.… Read more
If you’re looking to brush up on your PL/SQL knowledge, PL/SQL challenge is pretty nice. It’s a daily challenge quiz, where you are presented with multiple choice or true/false questions. It’s an initiative by Steven Feuerstein , who’s pretty well known. I just joined in, first few questions were not too tough Join in, there’s… Read more
It’s been a while hasn’t it, since I last blogged ? *goes to next tab to check last manual blog post* April 19. God! Hadn’t realized its been so long since I last composed. Yes, I’m alive (hey you’re reading this aren’t ya?). I can hear the collective yells of “where the hell have you… Read more
They say “Necessity is the Power of Invention” – a quote which I fully understood the impact today. I’ve been trying to understand Oracle’s Hierarchical Queries for a while now, but never fully understood the situation under which or when it would be used. Yesterday I got a reason to use it. Let me begin.
Over the period of time that I’ve been working on PL/SQL, the one the thing that we end up doing often is reset the sequences we use for Primary keys in our tables. Why do we do that, you might wonder. Consider this case:
Another of things I got via IpMessenger, this query(yes, its a QUERY, not even a full-blown code) returns the calender of the current year. Do note this query will work only in Oracle. Here’s the query.