Advertisement

07.08.2007 at 04:43AM PDT, ID: 22681762
[x]
Attachment Details

Number display in 1 decimal

Asked by manfredino in Oracle 10.x, Oracle Database

Tags: decimal, display, number

Hi experts,

Here I have a PL/SQL stored procedures for sending an email. The content would be from a particular table.

I have some problems with the number display. For a number field, I wanna show my number in 1 decimal.
If the value is not 0 , it works fine. However if the value there is 0, it won't work and my number will show as .0 instead of 0.0 . Is there anything wrong with my script?

to_char(to_number(v_carte_value), '999.9')

Start Free Trial
[+][-]07.08.2007 at 06:23AM PDT, ID: 19439901

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]07.08.2007 at 06:28AM PDT, ID: 19439913

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]07.08.2007 at 12:36PM PDT, ID: 19441033

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]07.09.2007 at 10:35AM PDT, ID: 19447088

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: Oracle 10.x, Oracle Database
Tags: decimal, display, number
Sign Up Now!
Solution Provided By: sujit_kumar
Participating Experts: 3
Solution Grade: A
 
 
 
Loading Advertisement...
20080716-EE-VQP-32