Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

APEX select list default value

RotanMar 22 2018 — edited May 21 2018

5.1.0

How can we default the 'Select List' with the display value and save the Return Value in Database.

I have a column in a Interactive Grid whose value should be displayed as 'Yes' or 'No' .

When New Row is created it should default to display 'No'

Return values are Y or N , to be saved in the database

Problem I face is when I default the Value to 'No' , Data doesnot Save as my column in Varchar2(1)

Now, when I default the value to 'N' - It saves correctly , but the display on New Row is 'N' not 'No'

When A new Row is created, I want the field to be displayed as 'No' and data to be saved as 'N'

Any help please..

pastedImage_2.png

pastedImage_3.png

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 18 2018
Added on Mar 22 2018
7 comments
11,363 views