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

2 votes315 views1 answer
Oracle sql day of month from date
SQL
8 votes332 views1 answer
Check mysql version phpmyadmin
SQL
0 vote327 views2 answers
.... ERROR! The server quit without updating PID file mysql centos
SQL
3 votes322 views2 answers
How to list columns for particular tables in postgresql
SQL
1 vote313 views1 answer
Oracle check table space
SQL
2 votes271 views1 answer
Oracle current date without time
SQL
0 vote312 views1 answer
Sql select rows with different values in one column
SQL
0 vote305 views1 answer
Drop all tables in azure sql database
SQL
0 vote313 views1 answer
Update database collation in postgresql
SQL
1 vote339 views1 answer
Oracle insert multiple rows into same table
SQL