Quick post: I was trying to connect to a 64-bit Oracle database using PL/SQL Developer. Despite ORACLE_HOME being set the right values and oci.dll available, PL/SQL Developer could not connect to the database.
By default, Oracle Forms Application Server serves Oracle Forms applications using the built-in Jinitiator JVM. While JVM works swell with cutting edge browsers it pretty much crashes most of the other browsers and doesn’t work at all in Chrome. There are workarounds but the workarounds do not play well while working with multiple tabs.
Background: For the past few days weeks, I have been working on a way to export selective data from one schema to import into another. Now the problem is that “selective” data refers to the data as stored across various tables in the custom application that I’ve been working on, with elaborate relational links between the tables ( if you’re curious, the table count on the related data was about 65) – so it was not just couple of tables that I had to export.
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 🙂
Toad (acronym for Tool for Oracle Application Developers) is arguably one of the most popular and best known tools used by most people dabbling in Oracle databases ( or for that matter, most relational databases anyway). Toad’s reputation is so good, I’ve known few people swear by it and don’t even bother looking at other software, no matter how good.