| how to get 0.5,not .5 [message #365936] |
Wed, 29 March 2000 04:52  |
Yasu
Messages: 2
Registered: March 2000
|
Junior Member |
|
|
Hi
(It is so hard to explain in English)
I want to get '0.5' but My Oracle display '.5' in a
SQL statement like 'select Ratio from Table1'.
if i use 'decode','round' function,i will get '0.5',
but i want '0.5' in all columns defined as real number(number(8,2) or so)
Mybe i have to edit some ini files to do this.
Please help me.
(Excuse me for bat English,can you understand?)
|
|
|
|
| Re: how to get 0.5,not .5 [message #365978 is a reply to message #365936] |
Mon, 21 August 2000 02:25  |
Vimal Kumar
Messages: 2
Registered: August 2000
|
Junior Member |
|
|
If u r doing this in SQL Plus then it's pretty simple.
use command at SQL Plus command prompt
column <column_name> format 99999990.99
then run ur sql.
Hope this is helpful
|
|
|
|
| Re: how to get 0.5,not .5 [message #365979 is a reply to message #365936] |
Mon, 21 August 2000 02:26 |
Vimal Kumar
Messages: 2
Registered: August 2000
|
Junior Member |
|
|
If u r doing this in SQL Plus then it's pretty simple.
use command at SQL Plus command prompt
column column_name format 99999990.99
then run ur sql.
Hope this is helpful
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
