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?

score 5 · Answer 1 · answered Mar 11 '16 at 06:43

5

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

answered Mar 11 '16 at 06:43

Jeffrey Kemp

59,135
14
106
158

score 1 · Answer 2 · answered May 28 '18 at 14:43

1

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

answered May 28 '18 at 14:43

user9859468

11
1

score 1 · Answer 3 · edited Aug 19 '18 at 06:58

1

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 :

select 1000000 to show more rows

Run those queries again!

Final Result having 21 rows in result :

Final Result having 21 rows in result

This might have solve your problem!

edited Aug 19 '18 at 06:58

LuFFy

8,799
10
41
59

answered Aug 18 '18 at 19:18

Bhavik Parmar

424
1
6
9

This question is related to **Oracle Application Express**, not SQL Developer, so - your answer might be correct, but is irrelevant in this context. – Littlefoot Aug 18 '18 at 20:26

score 0 · Answer 4 · edited Mar 06 '18 at 07:51

You can call function

javascript:apex.widget.tabular.addRow();

N number of times per click... For example,

Generate 2 rows, call
    javascript:apex.widget.tabular.addRow();
    javascript:apex.widget.tabular.addRow();

Generate 4 rows, call
    javascript:apex.widget.tabular.addRow();
    javascript:apex.widget.tabular.addRow();
    javascript:apex.widget.tabular.addRow();
    javascript:apex.widget.tabular.addRow();

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

4 Answers4