Sample Data
SELECT ‘3874’ col FROM DUAL
UNION ALL
SELECT ’74’ col FROM DUAL
UNION ALL
SELECT ‘123’ col FROM DUAL
UNION ALL
SELECT ’22FRE’ col FROM DUAL
UNION ALL
SELECT ‘ABCD’ col FROM DUAL
UNION ALL
SELECT ‘AB33FRE’ col FROM DUAL
Query Syntax
SELECT COLUMN_NAME FROM TABLE_NAME WHERE REGEXP_LIKE(COLUMN_NAME,'[[:alpha:]]') AND REGEXP_INSTR(COLUMN_NAME,'[0-9]')>0;
Output
COLUMN_NAME
22FRE
AB33FRE
Hello! I am Narayanaswamy founder and admin of narayanatutorial.com. I have been working in the IT industry for more than 12 years. NarayanaTutorial is my web technologies blog. My specialties are Java / J2EE, Spring, Hibernate, Struts, Webservices, PHP, Oracle, MySQL, SQLServer, Web Hosting, Website Development, and IAM(ForgeRock) Specialist
I am a self-learner and passionate about training and writing. I am always trying my best to share my knowledge through my blog.
