I have searched the google and metalink.from that, i have found commands for this problem. they said,please upgrate the your oracle version.but my oracle version is 10.2.0.4.0. i have also checked the trace file.it shows a ORA-07445: exception encountered: core dump [evaopn2()+3509] [SIGSEGV] [Address not mapped to object] [0x0] [] []. i saw metalink commands from this problem, it noted "please upgrade the problem".

suddenly, i have rewrite the above query. the ANSI joins are converted into Oracle joins. It gives output without any error.

Check your system for anomalies and reissue the statement. If this error persists, contact Oracle Support Services. See trace file for more details.

Lucky you, you have solved it by removing ANSI joins. Did you consider creating a SR at Metalink?

As of (un)formatted code: it is not that this simple query is not formatted, but the fact that code enclosed into [code] tags (i.e. the one that uses non-proportional font) is easier to read. How much would it cost if you, actually, used those tags?