Oracle query

[shalinikumarhitendra]

Hi All,

I am using the following query on sqlplus editor

sql>select 1/2 from dual;

it is giving result as .5.

But I want the result as 0.5.

Please provide the solution for the same. it is something urgent.

Thanks
Shalini

[debasisdas]

may i know pease what you want to achieve from

select 1/2 from dual;

[babind]

hi shalini this is bab from hyderabad i saw ur query but ur qeuery result will be the same as 0.5 but 0 are nothing value so 0 invisible mode are in our result
but if u want such type of result i will once again and result should send to u surely

thanking u
anjan

Hi All,


I am using the following query on sqlplus editor

sql>select 1/2 from dual;

it is giving result as .5.

But I want the result as 0.5.

Please provide the solution for the same. it is something urgent.

Thanks
Shalini

[amitpatel66]

Run the query in TOAD, it would show 0.5

[nramrits]

If U Have Important In Zero
Try This
Select 0||1/2 From Dual