Attending first Startup Weekend Brisbane Women Oct 2015 #SWBNEwomen

Startup Weekend Brisbane Women

October 9-11, 2015

Usually I'm extremely private about events that I attend, however this is the first time I may pitch one of the many 'big ideas' that are floating in my head. 

The call out for the event is:  

• Women. 
• Girl Geeks. 
• Developers. 
• Designers. 
• Marketers. 
• Business Folk. 

And I feel that I tick at least 3 of those bullet points: Women, Girl Geek, Business Folk..

Hopefully I can get an idea off the ground surrounded by like minded women or help another woman or team with their problem to solve! 

Startup Weekend Brisbane Women #swbnewomen

PL SQL Add Decimal to make a dollar value

You may need to design a report with financial information, where the dollar value is in a text field without decimal points. 

So how is this possible and not a number field?? Well, in the original business process, legacy systems, the value had always been a real number, then last year, after 20 years, the business began to use cents in payment as well. There is no decision to change the column type, to the change was required in the reports, which contained that column.

The situation is that some number had decimals and others didn't... 

In the report the data looked like this:
TOTAL_AMOUNT
-------------------------
33
24.95
12
56.90

I then used NUMERIC_FORMATTING to present the column data in a currency format: 

select TO_CHAR(TOTAL_AMOUNT, '9999D99') from TABLE_NAME; 

The end result is: 

TOTAL_AMOUNT
-------------------------
33.00
24.95
12.00
56.90

When the value is null, a null will be returned.


You could also use: 
select TO_CHAR(TOTAL_AMOUNT, '9999.99') from TABLE_NAME;