APEX12 of 30: SQL code to concatenate display columns in a dynamic LOV. APEX does LOV SQL code
If the http://db.kreie.net URL doesn't work, go to this website to access the scripts and other files used in this video series. https://sites.google.com/view/db-krei...
APEX 18.1 video 12 of 30: Look at the data model (data dictionary) using SQL Developer and data then decide what additional static and dynamic LOVs are used. Create the LOVs. See how APEX writes the SQL code when you use the “dynamic list of values” interface. See how to combine more than one column in the LOV’s display column. Combining two or more columns is called concatenating a display column.
select lname || ', ' || fname || ': ' || pers_ID as display,
pers_id as return from persons order by 1;
select lname || ', ' || fname || ': ' || persons.pers_ID as display,
persons.pers_id as return from persons inner join employees
on persons.pers_id = employees.pers_id order by 1;
select city || ', ' || state || ' ' || zip as display, zip_id as return
from zips order by 1;
select name || ', ' || dom_breed || ': ' || animal_id as display,
animal_id as return from animals inner join dom_breed_lookup
on animals.dom_breed_id = dom_breed_lookup.dom_breed_id
order by name;
Watch video APEX12 of 30: SQL code to concatenate display columns in a dynamic LOV. APEX does LOV SQL code online without registration, duration hours minute second in high quality. This video was added by user J Kreie Database 12 October 2018, don't forget to share it with your friends and acquaintances, it has been viewed on our site 4,874 once and liked it 34 people.