Home » Other » Client Tools » how to get 0.5,not .5
how to get 0.5,not .5 [message #365936] Wed, 29 March 2000 04:52 Go to next message
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 Go to previous messageGo to next message
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 Go to previous message
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
Previous Topic: How to import date and time in Oracle8 Navigator?
Next Topic: Delphi Oracle
Goto Forum:
  


Current Time: Thu Mar 28 10:45:37 CDT 2024