Home » RDBMS Server » Server Administration » How can i formatt a number with notation cientific
How can i formatt a number with notation cientific [message #371140] Wed, 06 September 2000 04:31 Go to next message
Pedro Pereira
Messages: 1
Registered: September 2000
Junior Member
If i make this statement:
select value_v from interface_log;

and he sows 44444E+3
Now how can i view the effective number formatted ?

Report message to a moderator

Re: How can i formatt a number with notation cientific [message #371141 is a reply to message #371140] Wed, 06 September 2000 06:34 Go to previous message
Kannan
Messages: 29
Registered: September 2000
Junior Member
use the Function To_Number
For Example : select To_number(44444E+3) from Dual;

Report message to a moderator

Previous Topic: TRACE
Next Topic: Billing System
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 29 18:39:16 CDT 2023
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.