SQL> select count(*) from rdf_test where '1.0' = v1;

  COUNT(*)
----------
         1

SQL>  select count(*) from rdf_test where 'a' = v1;
 select count(*) from rdf_test where 'a' = v1
                                     *
ERROR at line 1:
ORA-01722: invalid number


SQL> select count(*) from rdf_test where v1 = 'a';
select count(*) from rdf_test where v1 = 'a'
                                         *
ERROR at line 1:
ORA-01722: invalid number

##</code><code>##

  1* select count(*) from rdf_test where 'a' = TO_CHAR(v1)
SQL> /

  COUNT(*)
----------
         0

##</code><code>##


SQL> select count(*) from rdf_test where '1.0' = TO_CHAR(v1);

  COUNT(*)
----------
         0