The Power and Simplicity of Oracle Hierarchical Queries
· ☕ 6 min read · ✍️ Sathyajith Bhat

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.

Query For Displaying The Calender of The Current Year using SQL
· ☕ 1 min read · ✍️ Sathyajith Bhat

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.