APEX 19.1 08 Create static and dynamic LOVs in Shared Components. Use them in a form.

Опубликовано: 19 Октябрь 2024
на канале: J Kreie Database
7,578
49

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...

This video shows how to
(1) copy a page in APEX,
(2) create lists of values (LOVs) in a form
(3) analyze several fields in a table and decide whether a list of values [LOV] should be static [doesn’t change] or dynamic [the list reflects changes over time],
(4) import the data dictionary/diagram using SQL Developer, and
(5) correct an error in a report that opens a form.

Both static and dynamic LOVs are created in the Shared Components feature of APEX. These lists, which act as drop-down lists, are then added to several page items in a form.