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
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.
Subscribe to:
Posts (Atom)