Search:

Hi,

I have one doubts in using the IN operator in the subquery from the performance point of view. If I use the IN operator, somebody is saying that it should not be used, instead exists operator...

Hi,

I have one doubts in using the Distinct keyword to suppress the duplicates from the performance point of view. Why we should not use the Distinct Keyword in the Select statement. To suppress...

In the Build Script dialog box,what is difference between Build script file, execute SQL now and Execute and build script?

Hi,

1. Can any body tell that what is consistency and intergrity in oracle with suitable examples

2. What is normalization in oracle. pls provide the solution with suitable examples.

Hi,
First you have to lock the rows explicitly before some body update the rows
like below query

select * from table name
for update no wait;

use the above command to prevent other user...