'Oracle & PL/SQL Stuff' - Sathyajith Bhat

Sathyajith Bhat

Sign in Subscribe

'Oracle & PL/SQL Stuff'

A collection of 4 posts

Swap Table Names Between Inserts And Selects on the Same Line using Regular Expressions

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'

Internet Explorer

Fixing Internet Explorer Crash on Launching Oracle Forms Application with jInitiator

I've been facing this really annoying problem for quite some time now. My job revolves around developing apps using [Oracle Forms Builder][1]. Oracle Forms applications, uses Java applets to run inside any browser, on most platforms. Here's the kink - Oracle Forms applications by default

Exporting and Importing An Oracle database from one schema/user to Another schema/user easily

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

PL/SQL Procedure To Reset A Sequence To A Predefined Number in Oracle

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: You enter some values