regarding the data storage in oracle

[trysenthil]

in what case the datas get stored in oracle.
i think that it is in upper case.
but i have doubt.


one more : if the datas defaultly get stored as Ucase in oracle... is there is any possibilities for me to change the case..... i think no...but yet not satisfied...... ...

[debasisdas]

In database data is stored in the case it is inserted by the user not in any predefined case.

[trysenthil]

thanks,
one more doubt:

while retrieving the data the is stored in oracle dbase., and comparing that particular field eg.name we are writing as name='INDIA' .
how the comparison works with the name having diffrent cases. at that time whether it ignores the case?...

i have a query

select ename from emp
where name='abc' ***** can i give like this...... basically i am a beginner to oracle..... at that instanct how can i compare the field values**** .provide a way to do that...