This is a migrated thread and some comments may be shown as answers.

Oracle ROWNUM invalid identifier ORA-00904

1 Answer 238 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Tobias
Top achievements
Rank 1
Tobias asked on 04 Dec 2015, 02:55 PM

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

1 Answer, 1 is accepted

Sort by
0
Tobias
Top achievements
Rank 1
answered on 04 Dec 2015, 03:31 PM

Found the problem. There was an error in the filtering, not the actual query.

/closed

Tags
General Discussions
Asked by
Tobias
Top achievements
Rank 1
Answers by
Tobias
Top achievements
Rank 1
Share this question
or