How to make a request on click on a button in apex?

Question

Oracle

How to create a button in Oracle Database 11g Express Edition that, when clicked, executes a query and displays the result?
did according to this guide www.stock.zp.ua/simple-example-of-ajax-in-apex

spoiler

and did not understand how to make this request happen when you click on the P1_CLICK button?

Answer 1

There are several options.
1 page submission that starts the plsql process.
2 dynamic action
3 Ajax request using apex.server.processe (js dynamic action)