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;
Смотрите видео APEX 19.1 12 SQL code concatenates columns in a dynamic LOV. APEX writes LOV SQL code онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь J Kreie Database 11 Октябрь 2019, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 3,723 раз и оно понравилось 28 людям.