SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to check the value of a string is numeric, alphanumeric or characters?

BS2012Jul 26 2012 — edited Jul 27 2012

Hi All,
I have a task to validate an employee Id. Suppose the employee Id is E121212. Now as per the validation rule I need to check "the first letter of the employee Id is a character and rest are numbers." How can I do this? Please reply.

Thanks & Regards
Bibhuprasad Soumyaranjan

This post has been answered by chris227 on Jul 26 2012

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 24 2012

Added on Jul 26 2012

35 comments

26,748 views