Just nu i M3-nätverket
Jump to content

Två decimaler med btitle - oracle


speke

Recommended Posts

Hur får jag två decimaler på belopp?

 

set pagesize 15
column belopp new_value be noprint

btitle left col 95 be skip 1 -
           ========================================================================================================

column belopp format 999990.00
column summa format 999990.00

select 1000+2000+3000 summa, 1000+2000+3000 belopp 
from dual]

[inlägget ändrat 2009-01-14 08:28:37 av speke]

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.



×
×
  • Create New...