Follow

Keep Up to Date with the Most Important News

By pressing the Subscribe button, you confirm that you have read and are agreeing to our Privacy Policy and Terms of Use
Contact

Get value from SQL what was relation from other list. (Oracle APEX 21.11)

I want to display a value to the text field; it is from a SQL query. And that SQL’s WHERE keyword is from the list item.
Searching by ID in the selected row will return a single item.

SELECT SHOP_NAME, ID FROM M_SHOP WHERE ID = ‘(selected ID)’;

MEDevel.com: Open-source for Healthcare and Education

Collecting and validating open-source software for healthcare, education, enterprise, development, medical imaging, medical records, and digital pathology.

Visit Medevel

>Solution :

Just use page item’s name preceded by colon (:) sign. For example, if that ID represents department ID and page number is 1, that could be

SELECT SHOP_NAME, ID FROM M_SHOP WHERE ID = :P1_DEPARTMENT_ID
Add a comment

Leave a Reply

Keep Up to Date with the Most Important News

By pressing the Subscribe button, you confirm that you have read and are agreeing to our Privacy Policy and Terms of Use

Discover more from Dev solutions

Subscribe now to keep reading and get access to the full archive.

Continue reading