This is for APEX 5.1.2
I had just learned how to make a select list, and now I need to make a SQL query for another control.
The "Select list" control named "P1_Select_Control" uses this SQL Query to get the list of values:
select Table1.TEXT as TEXT,
Table1.ID as ID
from Table1 Table1
I need to know how to make an SQL Query to retrieve the ID of the selected value.
I had been searching on the web, but all I get is something like this:
select Table1.TableData as TableData
from Table1 Table1
where Table1.id = P1_Select_Control
and it clearly doesn't works.
I need something like " P1_Select_Control.SelectedValue.ID"
I had been looking in the web, but I don't even know what is the wording that I need to use. For example, if I use the title of this thread as search, I get a lot of javascript stuff, .NET controls, and Microsoft Office stuff.
So, I would like to get a tip on what words to search.