[castor-dev] Verify SQL syntax of LIMIT clause on Oracle version prior to 8.1.6

[Ralf Joachim]

Hi castors,
do anyone have an Oracle server with version prior to 8.1.6 (e.g. 8.0.x or 
7.x) runing and can try if the following query can be executed.

SELECT * FROM (
   SELECT t1.*, rownum rnk FROM (
       SELECT * FROM table
   ) t1
) WHERE rnk BETWEEN 5 AND 7
You can use any table avilable on your database for "table".
I need to know the Oracle version and if the query only returns the 5., 6. 
and 7. record of the inner query.

SELECT * FROM table
Many thanks in advance.
Ralf 


----------------------------------------------------------- 
If you wish to unsubscribe from this mailing, send mail to
[EMAIL PROTECTED] with a subject of:
       unsubscribe castor-dev