Hello all,
i have a huge database in Oracle. I cant load it fully in the Standalone Designer. To set up filtering and so on, i try to limit the rows i receive from the DB.
Normally in Oracle, i use ROWNUM to limit the results:
SELECT * FROM HUGEDB WHERE ROWNUM < 100
When i use exact the same query in ReportDesigner, i get: ORA-00904 - "ROWNUM" invalid identifier.
It seems, that the ReportDesigner add some quotation marks around ROWNUM. How can i turn that off?
Or is there another way to limit the number of returned rows?
Thanks,
Tobias