ODI Real time Scenario's and Interview Questions
Pages
(Move to ...)
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
‹
›
Home
View web version