My World A Blog On All The Things That Happen In My Life

Chuudi - 3 flowers and Durva grass tied together with a string. @.@joshenoy crafting a bunch of these. #nofilterChudi pooja at homeIMG_20140616_162916IMG_20140613_220028IMG_20140612_222607IMG_20140605_170431DSC02176DSC02178
Status » Grid 2 gameplay video - Faceoff run with the Nissan Fairlady Z: http://t.co/IiAPdIA9sS via @YouTube

Posts tagged SQL

Creating and Editing Parameterized Queries in Excel 2007
on 12/10/2010 - like it?

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.

(more…)

Tags: , , , , ,


Brush up your PL/SQL knowledge with PL/SQL Challenge
on 10/05/2010 - like it?

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).

Tags: , , , ,


Yes I'm alive!
on 14/06/2009 - like it?

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 ?

(more…)

Tags: , , , , , , ,


The Power and Simplicity of Oracle Hierarchical Queries
on 19/01/2009 - like it?

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.

(more…)

Tags: , , , ,


PL/SQL Procedure To Reset A Sequence To A Predefined Number in Oracle
on 11/08/2008 - like it?

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:

(more…)

Tags: , , , , ,


Query For Displaying The Calender of The Current Year using SQL
on 24/06/2008 - like it?

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.
(more…)

Tags: , , ,