Search This Blog

Tuesday, July 31, 2012

Check the column data contains alphanumeric data in Oracle

select employee_number from per_all_people_f where regexp_like(employee_number,'^[a-zA-Z]');

Output

SC1000
I10001

No comments:

Post a Comment