Oracle SQL Select Only 5 Digit Row in a Column [closed]

    SELECT * 
    FROM GNGRB.CLAIM 
    WHERE ZOCRECDT IS NOT NULL;

SLNO Column select only 5 digit row

Answer

Please use length function of oracle. For e.g:

select * 
from table a 
where length(a.column_name) = 5

In your case

SELECT * 
FROM GNGRB.CLAIM 
WHERE ZOCRECDT IS NOT NULL 
and LENGTH(SLNO) = 5