SQL – Sathya's World
Creating and Editing Parameterized Queries in Excel 2007
· ☕ 2 min read · ✍️ Sathyajith Bhat
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. I searched around a bit for documentation on doing so - and found that any articles on the same were woefully inadequate.

Yes I'm alive!
· ☕ 5 min read · ✍️ Sathyajith Bhat
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 been”. Well - work. Been drowned, swamped, overloaded - basically been busy with shit loads of work.

PL/SQL Procedure To Reset A Sequence To A Predefined Number in Oracle
· ☕ 2 min read · ✍️ Sathyajith Bhat
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: You enter some values via the front end. Assume that there are *a lot* of fields to be entered. You save them. The .nextval will pick up the next number in the sequence and goes into your table as the primary key.