Скачать или смотреть oracle apex || display additional columns || display additional columns in page item

In Oracle APEX, a List of Values LOV typically shows a display value and returns a return value. However, sometimes you may want to display additional columns from the LOV in a form or interactive grid—like showing a description, price, or category along with the selected item.


Go to Shared Components List of Values.

2. In a Form or Grid Item: Use "Display Extra Columns"
In the form or interactive grid where the LOV is used:

Go to the item or column settings e.g., for P1_PRODUCT_ID.

Set the LOV type to “Shared Component LOV” or “SQL Query.”

In the Settings, under Display Extra Columns, you’ll now see the extra columns e.g., price, category that you included in the LOV.

You can now create Dynamic Actions or use JavaScript to display these values in additional fields.