Oracle Database and Oracle Applications
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
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment