Skip to Content

Oracle ROWNUM is eqals in HANA

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 )



Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jan 24, 2018 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?

    Add comment
    10|10000 characters needed characters exceeded