Re: Oracle 9i query results differ from Oracle 8i! Is Oracle 9i reliable when using complex queries with analytic functions? This is very serious question!

Hi!

both SCOTT schemas were created with %ORACLE_HOME%\RDBMS\ADMIN\scott.sql, not utlsampl.sql. There is no significat difference in content of scott.sql in 9i and 8i.

"Hexathioorthooxalate" <ruler_at_removemetoemail.clara.co.uk> wrote in message news:1109944823.28822.0_at_lotis.uk.clara.net...
> Sergey, before I have a look at this further for you, could you ....
>
> A few minutes ago I created the SCOTT schema using the script "utlsampl.sql"
> a few minutes ago. I get 4 rows on 10g on a winbox, which you say is wrong.
> I get 4 rows using 9.2, same machine. Please confirm you have used the
> <b>same</b> SQL script to generate the <b>same</b> SCOTT schema on both your
> 8i and 9i DB's. This will confirm you are executing your query against the
> <b>same</b> data and ruling out the obvious. If the problem persists, we can
> look into in more detail.
> Regards
> Hex
Received on Fri Mar 04 2005 - 13:15:01 CST