APEX 19.1 12 SQL code concatenates columns in a dynamic LOV. APEX writes 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...
APEX12 of 30: SQL code concatenates columns in a dynamic LOV. APEX writes LOV SQL code
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.
SQL code for dynamic LOVs. Video that explains this code in detail: apex12.sql01
• APEX12.SQL01: Create LOVs that use mo...
--client_list
select lname || ', ' || fname || ': ' || pers_ID as display,
pers_id as return from persons order by 1;
--emp_list
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;
--zip_list
select zip || ', ' || city || ', ' || state as display, zip_id as return
from zips order by 1;
--animal_list
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 APEX 19.1 12 SQL code concatenates columns in a dynamic LOV. APEX writes LOV SQL code online without registration, duration hours minute second in high quality. This video was added by user J Kreie Database 11 October 2019, don't forget to share it with your friends and acquaintances, it has been viewed on our site 3,723 once and liked it 28 people.