Oracle Application Express (MOSC)

MOSC Banner

how to handle ID and dispaly value for a coloumn

edited Aug 13, 2018 9:43AM in Oracle Application Express (MOSC) 3 commentsAnswered

Hi,

I wanted to know how to handle ID and display value for a coloumn in APEX page?

e.g. I want to create an Apex page to create employee records, so I will be creating Form type page with fields "first name", "last name", "grade", "department".

first three fields are free-form text for user to enter any value where as the fourth field is "popup LOV" type item when selected showing list of departments i.e. "department ID" and "department name".

my question is how to show the "department name" on the page but internally save the "department ID" into employees table?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center