How will restrict values in 0-9 and A-Z and a-z and special character.Only all

How will restrict values in 0-9 and A-Z and a-z and special
character.Only allowed these chars otherwise we will reject
the records? what is the function we used to restrict...

Question Posted / jey.dgl

3 Answers
7753 Views
Cap Gemini, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

How will restrict values in 0-9 and A-Z and a-z and special character.Only allowed these chars oth..

Answer / ankit

Do it in Unix shell script . Search through "grep" for value
between [0-9] [A-Z] & other criteria .If condition doesn't
satisfy.U can pass a parameter stating invalid.

Is This Answer Correct ?

2 Yes

0 No

How will restrict values in 0-9 and A-Z and a-z and special character.Only allowed these chars oth..

Answer / abhishek

REGEXP_LIKE(COL_NAME,'[[:alphanum:]]')

Is This Answer Correct ?

0 Yes

0 No

How will restrict values in 0-9 and A-Z and a-z and special character.Only allowed these chars oth..

Answer / babu

Hi,
As per my knowledje,i find below method for u r query.

select * from tab where col1 between 'A' and 'Z' or col1
between 'a' and 'z' or col1 between '0' and '9'

please let me know,if u have any concerns.

Babu

Is This Answer Correct ?

5 Yes

8 No

Post New Answer