select * from TIKY.IKY_TPERSONEL PT WHERE LENGTH(TO_CHAR(PT.IKY_PER_SCL_NO)) = 5;
Converting integer type to char and getting length in sql
Reading Time: < 1 minute
select * from TIKY.IKY_TPERSONEL PT WHERE LENGTH(TO_CHAR(PT.IKY_PER_SCL_NO)) = 5;