Oracle apex prevent initial load

-- 1. Put a HIDDEN field P1_IS_LOADED in the region

-- 2. Requesting datas in region becomes:
SELECT /* your columns */
  FROM /* your tables */
WHERE 1 = 1 
  AND nvl(:P1_IS_LOADED, 'N') = 'Y'
   
-- 3. At page level:
>> Post-Rendering > After Regions > Computation > add one computation with: 
	Computation: Static Value: Y

Source: askmax.blog

Similar codes

3 votes111 views2 answers
Install mysql powershell
SQL
0 vote121 views1 answer
Sql server select record with max id
SQL
0 vote125 views1 answer
Mysql a from on this page has
SQL
29 votes115 views6 answers
Delete all rows from table mysql
SQL
4 votes154 views1 answer
How to drop a database in sql server when it is in use
SQL
0 vote117 views8 answers
Convert sql query to linq online
SQL
10 votes126 views4 answers
SELECT FROM WHERE
SQL
0 vote122 views1 answer
Dump db only triggers mysql
SQL
0 vote129 views3 answers
Join
SQL
2 votes116 views1 answer
Postgresql transaction
SQL