So I have a link on my SQL query. It can navigate to the next page. But the thing is, I cannot carry the host_id(PK) to the next page: Anyone suggestion?

CodePudding user response：

Concatenate it.

select 
'...:P39_COPY_HOST_ID:' || host_id ||'"...'
from ...                -------------
                        this

Or, even better, use apex_page.get_url function:

select ...
  '<a href="' ||
    apex_page.get_url(p_page   => 39,
                      p_items  => 'P39_COPY_HOST_ID',
                      p_values => host_id)
              || '"</a>' as link
from ...