Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
goodman2253
Yak Posting Veteran
88 Posts |
 Posted - 2012-07-12 : 07:23:00
|
| Is it possible in oracle that when i give the number lets say 345 it should give the result by 3.45(means it should divide the number by 100 at back end)I should not do it manually. I just give the number and it should give me the result.like select 223 from dualwhen it execute this statement it should give me 2.23 |
|
|
sunitabeck
Master Smack Fu Yak Hacker
5155 Posts |
Posted - 2012-07-12 : 07:24:25
|
| This is a Microsoft SQL Server forum, so experts on Oracle are likely to be far and few in between. You might get better an faster answers at dbforums.com |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2012-07-12 : 08:53:22
|
| IMO,It is not possible in any RDBMS. If you want to have it, use a function that divides the number by 100 and call that function in the SELECT statementMadhivananFailing to plan is Planning to fail |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-07-12 : 10:14:10
|
| do want value itself to change in db or do you want this just for display?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
Dividing the number by 100