Help for this page

Select Code to Download


  1. or download this
    SQL> select count(*) from rdf_test where '1.0' = v1;

...
                                         *
ERROR at line 1:
ORA-01722: invalid number
  2. or download this
      1* select count(*) from rdf_test where 'a' = TO_CHAR(v1)
SQL> /

  COUNT(*)
----------
         0
  3. or download this
    
SQL> select count(*) from rdf_test where '1.0' = TO_CHAR(v1);
...
  COUNT(*)
----------
         0