SQL error ORA-01722: invalid number tips

Usually this is because INSERT or UPDATE and the conversion from chars to number failed.

But when this is happened in SELECT statement:

It's probably because the implicit conversion in WHERE clause.

SELECT * 
FROM ( SELECT FLAG, TO_NUMBER ( NUM ) NUM 
FROM SUBTEST 
WHERE FLAG = 'N' ) 
WHERE NUM > 0 ;

See here