Using free cloud instance of Oracle DB and Apex. Complete Apex novice at this point.
I need to ensure a text lastname field is uppercase in the db to ensure users do not enter names in various case mixes, which would not violate the PK constraint (e.g., Jones <> jones for uniqueness). I tried to use a Computation on the form field in the page developer but can't figure out the syntax for the expression entry, and couldn't find any help pages that explain this. For example, what is the assignment operator if must be used (=, !=)? What goes to the left of it - the form field name in developer (eg P3_LASTNAME)? Same for the function input for the UPPEER() function?
Or maybe there's a better way than use of a Computation on that field?
Thanks!