Dear All,
Would like to ask anyone write sql command to delete records where particular field has non-numeric value.

for instance...
seq input_value
---- ----------
1 1
1 2
2 1
2 2
2 r
3 1
3 2
3 3

Expexting output

seq input value
---- -----------
1 1
1 2
3 1
3 2
3 3

You can see once the input_value detect character, it will delete the whole records where seq = 2.

I know plsql can achieve this, but just want to know whether can achieve in SQL statement.

Thanks,
ckwan