Hi Gurus,
I have a table with a column set as varchar2(100).
If I insert into this a value as say 1000 and NOT '1000',
it still inserts (8i) and I can also select from it without giving the argument in quotes.
Why does this happen?
Printable View
Hi Gurus,
I have a table with a column set as varchar2(100).
If I insert into this a value as say 1000 and NOT '1000',
it still inserts (8i) and I can also select from it without giving the argument in quotes.
Why does this happen?
It works because the values with which you are testing are numeric and Oracle is able to perform a type conversion for you.