Oracle does not support Limit similar to mysql. But you can still limit the number of rows of the returned result set.
If you only want to return to the previous ten row, you can write:
Select * from Table WHERE ROWNUM <10;
But the following statement is wrong:
Select * from Table Where Rownum> 90 And Rownum <100;
This is because Oracle believes that this condition is not established, so it has not returned. You should write this:
Select * from table where rownum <101 minus selection * from table where rownum <91;
Toad use Quick Start - ZZ http://www.yourblog.org/data/20043/14305.html
