While I was in wonderful Kong Kong, the mugshot arrived and I now have the content to announce Kylie Payne has arrived on our SAGE team:

http://sagecomputing.com.au/about_sage_computing_services.html#kylie

I've already had the opportunity to work with Kylie on a few things and I enjoy her great attitude. We have a similar background - working on a few data integration projects; and now we look forward to the growing world of Oracle Application Express.

To meet Kylie come by our booth at November's AUSOUG conference.

See you there!

ScottWe

## Pages

▼

## Monday 18 October 2010

## Friday 8 October 2010

### Compute the area of...

Riddle me this |

In just a few hours I take off for Hong Kong to take the kids to Disneyland and visit the city for a few days. I'm happy, so (while I don't condone the use of the Internet to solve all your problems) I thought I'd make a few other people happy, and make the visit to my site worthwhile :-)

I've used formulas according to Maths is Fun, and also demonstrated a few other SQL rounding functions you can find well documented here. That's right kids, documentation is your

*friend*.

declare lc_pi constant number := 3.141592; -- triangle ln_t_base number default 2; ln_t_height number default 4; -- square ln_s_length number default 5; -- circle ln_c_radius number default 200; -- ellipse ln_e_width number default 3; ln_e_height number default 2; -- trapezoid / trapezium ln_z_a number default 2; ln_z_b number default 5; ln_z_height number default 3; -- sector ln_r_radius number default 4; ln_r_degrees number default 45; ln_area number; begin -- triangle ln_area := 0.5 * ln_t_base * ln_t_height; dbms_output.put_line('Triangle: '||ln_area); -- square ln_area := POWER(ln_s_length, 2); dbms_output.put_line('Square: '||ln_area); -- circle ln_area := lc_pi * POWER(ln_c_radius, 2);

dbms_output.put_line('Circle: '||ROUND(ln_area, -2)); -- ellipse ln_area := lc_pi * ln_e_width * ln_e_height; dbms_output.put_line('Ellipse: '||FLOOR(ln_area)); -- trapezium ln_area := 0.5 * (ln_z_a + ln_z_b) * ln_z_height; dbms_output.put_line('Trapezoid: '||CEIL(ln_area)); -- sector ln_area := 1/2 * ln_r_radius**2 * ln_r_degrees / 180 / lc_pi;

dbms_output.put_line('Sector: '||ROUND(ln_area, 5)); end simple_calcs; / Triangle: 4 Square: 25 Circle: 125700 Ellipse: 18 Trapezoid: 11 Sector: 6.28319 PL/SQL procedure successfully completed.See you on the other side of Hong Kong!

## Thursday 7 October 2010

### Perth AUSOUG Conference Information 2010 (advert)

To all Oracle, E-Business Suite; J2EE; DBA; Enterprise Architects; Siebel Users; MIS Management; and Academia professionals interested in this years Australian Oracle User Group conference in Perth (and why wouldn't you be?), I've just published some information on our SAGE website.

Here is a page linking to an amazing brochure that details everything you need to know about the conference.

And here I detail times where you can catch our SAGE experts present; and also link to our past presentations.

Download the daily session program for more information.

There really is a great line-up this year, and as usual I look forward to catching up with local & international guests.

ScottWe.