Oracle varchar2 minimum length -
We have a table with the varchar2 type column in Oracle DB (for example, USERNAME). How can I determine the exact (or at least minimum) length for this column? That's why all the usernames included in this table can be only 10 (or at least 10) characters long.
You can use a check barrier:
Table Mabelable (Macclaw varchar2 (50), barrier strollen check (length (mycolumn)> 2))
or something similar. I'm not sure how performant it is, though.
Comments
Post a Comment