ODI Real time Scenario's and Interview Questions
Pages
Introduction
ODI Architecture
Data Warehouse Concepts
ODI 12c Material
ODI Interview Questions
SQL interview questions
Thursday, April 6, 2017
How to check whether string is alphanumeric or not in Oracle?
SELECT * FROM DUAL regexp_like('abc123','^[0-9a-zA-Z]+$')
Output:
x
SELECT * FROM DUAL regexp_like('abc123@','^[0-9a-zA-Z]+$')
Output:
abc123 is alphanumeric
abc123@ not alphanumeric
Newer Posts
Older Posts
Home
Subscribe to:
Posts (Atom)