My World

Small posts here and there about my life

Oracle & PL/SQL Stuff

sathya

2 minutes read

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.

sathya

3 minutes read

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.

sathya

2 minutes read

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.

sathya

1 minute read

If you’re looking to brush up on your PL/SQL knowledge, PL/SQL challenge{#aptureLink_bTi5ZytYmL} 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{#aptureLink_WlOD3WAo4T} .

sathya

2 minutes read

I’ve been facing this really annoying problem for quite some time now. My job revolves around developing apps using Oracle Forms Builder{#aptureLink_dzpThUVtnA}. Oracle Forms applications, uses Java applets to run inside any browser, on most platforms. Here’s the kink – Oracle Forms applications by default uses Oracle’s{#aptureLink_5VcUe7aCHj} jInitiator{#aptureLink_uyXnIMpqB7} which is a JVM made by Oracle and allows a web enabled Oracle Forms client application to be…

sathya

2 minutes read

Couple of days ago at work I was asked to create a new environment(schema, user) for specific application testing conditions. While that was no big deal, I was also asked to import all the data from existing production environment into a new environment – and I was in a bit of bother here – generally the whole importing/exporting is done by DBA’s not developers. While I knew the usage of exp and imp commands, creating schema would require stuff like tablespace creating, adding…

Recent posts

See more

Categories

About

AWS Community Hero, SRE at Adobe, Author: Practical Docker With Python