OraFAQ Forum: Client Tools » how to get 0.5,not .5

Home » Other » Client Tools » how to get 0.5,not .5

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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?)

Report message to a moderator

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

Report message to a moderator

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

Report message to a moderator

Previous Topic:	How to import date and time in Oracle8 Navigator?
Next Topic:	Delphi Oracle

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu May 01 19:26:15 CDT 2025