-
Query doubt
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
Cheers!
OraKid.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|