This discussion is archived
3 Replies Latest reply: Jul 22, 2013 10:40 AM by Joe Upshaw RSS

create a dinamic LOV using string substitution

Ingenio Newbie
Currently Being Moderated

Hello

I need to create a List of Values as follows using my application item CALLED GLOBAL_SCHEMA

 

GLOBAL_ESCHEMA := RPSENV  is set on load trigger.

 

select N_COUNTRY d, COD_COUNTRY r

from V('GLOBAL_ESCHEMA').COUNTRIES@DB_APEX_RPS

order by 1

 

do you have suggestions for me?

please help.

 

____________________________________________

note:

select N_COUNTRY d, COD_COUNTRY r

from RPSENV.COUNTRIES@DB_APEX_RPS

order by 1

 

WORKS GOOD

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points