Tag: Alphanumeric

Oracle query to find alphanumeric data in column

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 […]