Tag Archives

6 Articles

Creating and Editing Parameterized Queries in Excel 2007

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. To be specific: There are plenty of articles on how to change the parameters – just head over to Properties -> Query Definition -> Parameters. Ok, cool. Now hang on, the Parameters button is disabled. How the heck am I supposed to get it enabled ? I had a ball of a time trying to figure out a way to do it – and in the end, found the answer, and posted it. Figured might as well post it here for my reference… and for others who are searching for a way to do the same.

Read More

Brush up your PL/SQL knowledge with PL/SQL Challenge

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 some great prizes to be won .

If you know of any more such websites, do drop in a comment and let me know.

(PS: If you’re wondering what’s with the weird URL structure, well its built on Oracle Apex. Long, clumsy URLs are a pain, and Apex does nothing to banish them).

Yes I'm alive!

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.

Next question – Am I in Austin ?

Read More

%d bloggers like this: