How to validate a column, which takes only number and character value?

Is there any datatype in oracle to check whether a inserting value is at least a numeric and a character?

Showing Answers 1 - 1 of 1 Answers


  • Jul 17th, 2019

We can use regular expression such as REGEXP [A-Za-z0-9] in order to validate a column,which takes only number and charcater value.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.


Related Answered Questions


Related Open Questions