If I say Oracle is the best database system available then there will be hardly any one who will disagree with me. Oracle 8 / 8i were the best database systems and the biggest bug in Oracle 8 is, there is no uninstaller and after you install the Oracle 8 personal you don’t have an option of removing and without removing it you cannot install the later version or even upgrade it. So now the question arises how to uninstall the Oracle 8.

The last option that came to my mind is to format the hard drive and so the Oracle 8 personal will be gone and as I wanted to format it started taking the backup. After all backup done being a programmer and database designer thought of giving a try as to edit the registry and remove it manually and lastly succeeded in the process.

I am sharing my personal opinion how I removed it and following this steps can be dangerous and it’s recommended that whatever you do you should think it’s ok and not unethical. If anything unintended happens I am not responsible for the effect though.

Network cards are getting faster, internet connections are increasingly becoming faster. There are even talks of 1Gbps internet and faster coming available. Oracle RAC can benefit from such developments, but did you know that you could stretch your RAC geographically (well almost) if you wanted to? Well as it turns out, you can! You can already spread your nodes across the city. There are cases of several clients running the extended RAC up to 50 kms!

Before designing, ask yourself why do you want to push this far and why an extended RAC? The answer is pretty simple. There are enough log shipping solutions but they only end up making the RAC environment complex. A second benefit is that you won't need to worry about the danger of your data being lost in a building fire.

I would be doing this in a new user and so first you need to have the administrative priviledges to create new user. By default the Scott user does not have the priviledges and you need to login using the System user.

Is Oracle always the best tool or application to manipulate data? The answer lies within what you mean by manipulate. Data can be transformed via data manipulation language, and it can also be transformed via string or numerical manipulation. To distinguish between the types of manipulation, let’s say that stored data is in the purview of DML, and output or displayed data is what or how stored data is presented to the user. A simple example of this is a date. What is stored can be forced to display in numerous ways. March 8th, 2007 is just as valid an output as 03/08/2007; it just depends on what you or your users want to see.

The point of this article concerns how you get from what is stored to what is displayed. The construct for this point revolves around a string/numeric manipulation problem. Suppose you have an application that supports surveys or offers a coupon to users via the Internet. After clicking Submit on an online survey form, it is very common for your identifier, whether it is a survey ID or an account number, to be passed back as one of many name-value pairs in a URL.

Many times developers find it difficult to delete records from parent tables when child records reference those tables through foreign key (referential integrity) constraints.

Constraints validate the data; without constraints, we are just storing invalid data.

For a developer to identify and disable foreign key constraints is a difficult task. Most of the time, the application’s ER diagrams are not available to the developers. A brief description on the foreign key (referential integrity) constraints will go a long way in identifying and disabling these constraints