I have a List View Region that I would like to update the contents of based on a Select List, without a submit call or page refresh, but I am open to suggestions that don’t use the select list bind variable in the where clause. List View Region (P1_LIST_VIEW) Select list: The dynamic action is When: On …
Tag: oracle-apex
How to specify the 5 apex items on my javascript code at oracle apex
Please see picture on the link. How do I code 5 apex page items in a javascript using if else condition. Initially, what I am doing is i am trying to hide regions which will have empty page items and that depends on the sql query results. please help. thank you. Here is my code: Answer I was able to
PL-SQL, Oracle Apex: How can I add pagination to a PL-SQL dynamic content table?
I created a PL-SQL dynamic content report in Oracle Apex, however I am having trouble figuring out how to add pagination to it. I have too many rows and therefore adding pagination to the table will provide a better user experience. My sample code looks as follows: BEGIN END; Answer Create two hidden items on…
Oracle Apex opening a column link in interactive report?
I have column link in an interactive report. This column link should run an sql query which supposed to return an external URL so I want to open in a new tab/page. How can I do that? Somehow with a dynamic action? ..but I cannot make dynamic actions for columns furthermore I should query the data from the tab…
Read values from text field individually
I would like to read all values from a text field/text box individually and then write them to a table: Example: Output: This is an example of a text I want to read out How can I use a loop to read the text field/textbox? That is, whenever a space comes the new subsequent value must be in a new