SQL for Oracle RDB - SELECT TOP 1000 ROWS??

[nataliek92]

Hello,

I am trying to import an Oracle RDB Recordset to Excel via Microsoft VBA. I currently have a working SQL string but would like to return just the top 1000 rows.

Normally I would use "SELECT TOP 1000" for an SQL Server. I understand that this will not work for Oracle, so I tried Oracles version of "WHERE ROWNUM <= 1000", but this returns the following run-time error :

Run-time error '-2147467259 (80004005)':
[Oracle][ODBC][Rdb]%SQL-F-ORAROWNUM, ROWNUM only available in ORACLE LEVEL 1 dialect

What does this mean? Is this because I am connecting to an RDB driver? What dialect should I be using?

Anyone have any other alternatives I could try?

Thanks in advance for any help!

Natalie

 

[RickXL]

Sorry, I am not an Oracle person but you could try the "LIMIT TO" clause: http://download.oracle.com/otn_hosted_doc/rdb/pdf/sql_ref_v7143_part1.pdf