Hi,
I would like to know if there is any function/option in oracle to restrict the entry of values in a field only with a combination of numeric and few special characters.
For an instance, in current below are the valid entries. Numeric '1' is used for explanatory purpose. Any number is valid.
<1 >1 <=1 >=1 =1 1.0 1.00
Apart from these any other value entered is invalid. Currently, I tried using REGEXP_LIKE(column, '[^0-9.<=>]'). However, this seems to be allowing multiple entries of the special characters and also allows the comparative operators after the numeric value like 100<= which is invalid. The logical operators should be entered only at the first place. Also should restrict the entry of decimal ( . ) twice.
Can anyone help me?