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?

1) create table xyz (col1 varchar2(20))

2)
insert into xyz values (1)
insert into xyz values ('2')
commit

3)
Following query works:
------------------------
select * from xyz where col1 = 1
select * from xyz where col1 = '2'

4)
insert into xyz values ('a')
commit

5)
Following query works:
------------------------
select * from xyz where col1 = '1'
select * from xyz where col1 = '2'

6)
Following query does not works:
---------------------------------
select * from xyz where col1 = 1