Quote Originally Posted by balajiyes
Hi All,

I did the follwoing test.

Step 6 falied with ORA-01722. Can you please let me know why oracle failed to convert the number into character?

6)
Following query does not works:
---------------------------------
select * from xyz where col1 = 1
I hope now you learned how to treat the data type in Oracle.

Tamil