>I tried the earlier suggested method to this particular >scenario below but it did not work.
How it did not worked: some Oracle version does not support this syntax or has bugs (version 815 hasthe syntax. As for bugs, there are some, like CBO and RULE based optimizer modes returns different number of rows.)