Display perticular length of records

Display perticular length records

If you want to dispaly record which having only 3 of length use below method

select * from my_table where length(my_column) = 3

select * from my_table where regexp_like( my_column, '^[[:digit:]]{8}$');