I have a simple Oracle database (non SDE/Geodatabase) but I want to constrain the values that can be entered into a particular field (ex: the state names that can be stored/entered in a "State" field)
This is exactly what Domains are, in an ESRI geodatabase. Does something like this exist outside of Geodatabases? If so, how can I do it?
Best Answer
You can try writing triggers for the database, checking for valid values (trigger restriction) and update the field accordingly. Check the following links:
Parts of a Trigger
Types of Triggers
If possible, you can do the same validation at the form (GUI) level and provide the user with some drop-down option.
You can also try putting these in a separate table which can be accessed by all.
Just some thoughts...