PL/SQL
Making Oracle Forms Use JRE instead of Jinitiator
· ☕ 2 min read · ✍️ sathya

By default, Oracle Forms Application Server serves Oracle Forms applications using the built-in Jinitiator JVM. While JVM works swell with cutting edge browsers1 it pretty much crashes most of the other browsers2 and doesn’t work at all in Chrome. There are workarounds but the workarounds do not play well while working with multiple tabs.


Golden Rules for Developers
· ☕ 1 min read · ✍️ sathya
Steven Feuerstein has a nice little presentation on some golden rules for developers. They aren’t anything new, yet not many people read/follow them 🙂 Download the PDF from here, or just read it via the embedded doc

Brush up your PL/SQL knowledge with PL/SQL Challenge
· ☕ 1 min read · ✍️ sathya
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.

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

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.


PL/SQL Procedure To Reset A Sequence To A Predefined Number in Oracle
· ☕ 2 min read · ✍️ sathya

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: