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

. @narayananh and @tantanoo on @narayananh's TBTS

. @Shivaranjan with his Nexus One, @dhempe and @varunshridhar

. @abvan wondering whether to take Complan +Bournvita mix

Status » @Kazarelth sniper in ME2 >> sniper in ME

Posts tagged query

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: hierarchical queries, oracle, PL/SQL, query, SQL

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: calender, oracle, query, SQL

Sounds I Like »

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

Posts tagged query

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

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

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

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