Skip to Content

Oracle ROWNUM is eqals in HANA

Jan 24 at 04:15 AM


avatar image

Hi All,

I have function being used as MOD ( ROWNUM, 1 ) and I have to use the same in Oracle but some reason ROWNUM is not recognized in HANA but when I googled I have read some where that ROWNUM can be replaced with "$rowid$" in HANA , even i replace as below still complaining , any thoughts or work around solution for this ?

MOD ( "$rowid$", 1 )



10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Lars Breddemann
Jan 24 at 06:02 AM

This question had been discussed quite a bit already and searching for $rowdid$ would have led you to the fact that using $rowid$ simply is not supported. (not sure why you as an SAP employee ask for that in a public forum, but that's a different topic).

There is a lot to be said about why one shouldn't use ROWNUM even in Oracle, but I think the easiest way for you to find a solution would be to tell us, what the desired outcome of the code is.

If you are not writing code that deals with the internal storage of rows in Oracle then ROWNUM really only a means to an end. What's your end here? Do you want to select just a subset of records?

10 |10000 characters needed characters left characters exceeded