cant get the correct num of rows from Oracle. in 2 SQL servers ( sql 7.0 and SQL 2000)

From: Melih SARICA (melihsarica_at_hotmail.com)
Date: 10/19/04 

Date: Tue, 19 Oct 2004 14:05:31 +0300

I ve got an Oracle 9. server running on AIx.

and One SQL Server 2000 Sp 3on w2k
  and SQL server 7 on Winnt 4.0

i did link this Oracle server on both SQL serevrs. When run an simple SQL
query i got different results.

Num of rows are always different In SQL server 7.0 i got 49430 rows( when i
check in oracle its correct)
                                                    In SQL SErver 2000 i got
49336 rows.

Any idea ?

Relevant Pages

  • Re: IOT, memory and transaction time
    ... easily generate it with DBMS_METADATA.GET_DDL if your verison of Oracle ... were pretty consistent no matter how big the table (this transaction ... FOREIGN KEY (versionNo) REFERENCES T_TRANSACTIONS, ... Oracle provides read consistency and SQL Server ...
    (comp.databases.oracle.misc)
  • Re: Database or store to handle 30 Mb/sec and 40,000 inserts/sec
    ... "Writers block readers and readers block writers in SQLServer. ... getting around this fundamental issue and because of it SQL Server ... admitted they can happen in Oracle, I guess Oracle should never been used ... isolation level but you will always disagree because you follow doctorine ...
    (comp.databases.oracle.server)
  • Re: IOT, memory and transaction time
    ... easily generate it with DBMS_METADATA.GET_DDL if your verison of Oracle ... If it was the update statement that references ... FOREIGN KEY (versionNo) REFERENCES T_TRANSACTIONS, ... There are however differences how both products deal with concurrency; in Oracle readers don't get blocked while this may happen in SQL Server. ...
    (comp.databases.oracle.misc)
  • Re: Import problems on Windows Server
    ... XP is fine, so is Vista, like you I use them day in day out, around 12 hours ... a day myself too - laptops and the desktop i'm writing this on. ... I use SQL Server on XP and Vista for writing and demo'ing stuff, ... those are the same problems in the Oracle world. ...
    (comp.databases.oracle.server)
  • Re: command line vs grid control
    ... have Oracle on-site for their line-of-business applications. ... customers that Oracle(all of its products not just the RDBMS) run on ... SQL Server where appropriate. ... Written any shell scripts in Windows to ...
    (comp.databases.oracle.server)