How to increase number of displayed rows in a tabular form using apex 5.0

Question

Currently my tabular form displays 10 rows at a time. How do I increase the number of rows to be displayed, say from the current default number of 10 to something like 20? Is there a place somewhere in the page attribute where you can set the number of rows to be displayed, as in the case of an interactive report?

Solution 1

Region -> Attributes -> Layout -> Number of Rows

Solution 2

If you are facing this problem for an 11g Oracle SQL Developer:

More than 10 rows available. Increase rows selector to view more rows.

Then you can directly solve this from drop down menu of rows situated beside Autocommit checkmark from SQL Workshop:

select 1000000 to show more rows :

Run those queries again!

Final Result having 21 rows in result :

This might have solve your problem!

Solution 3

In scripting window you will find a drop-down with row label, select it and choose the number of rows you want to display.