Build, test, and debug regular expressions
This regex matches specific numeric data type declarations, such as SQL NUMBER(p,s) formats or type definitions followed by /DECIMAL or /PERCENTAGE. It validates precision and scale (e.g., 1-3 digits, optionally followed by a comma and another digit). This is useful for schema parsing or validating database view column types.