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?
  • Interview Candidate
  • 2
  • 5229

Showing Answers 1 - 2 of 2 Answers

Rajiv

  • 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