orastory.wordpress.com
Epoch | OraStory
https://orastory.wordpress.com/2015/06/26/epoch
Dominic Brooks on Oracle Performance, Tuning, Data Quality and Sensible Design … (Now with added Sets Appeal). SQL Plan Baseline Manual Evolution. SQL Plan Management Choices →. June 26, 2015. Note to self because it’s just one of those date/timezone-related topics which just doesn’t seem to stick…. Epoch/Unix time – See https:/ en.wikipedia.org/wiki/Unix time. Firstly when converting from Oracle date or timestamp – we need to work from UTC not local time. Assuming that this timestamp is in milliseconds:.
munkyben.wordpress.com
The Magic Shed – munky on oracle
https://munkyben.wordpress.com/2013/03/14/the-magic-shed
March 14, 2013. March 14, 2013. In keeping with my last post, this is another ‘back to basic’s kind of thing. It’s basically a small metaphor of why we should use constraints, datatypes and other normal database design fundamentals when storing data and is aimed either at the complete newbie to database design or as a handy explanation to your Excel loving business users for more experienced developers…. The first weekend she carefully placed her pots on one shelf, her compost bags in one corner, her too...
munkyben.wordpress.com
Handling aggregated strings in SQL reports – munky on oracle
https://munkyben.wordpress.com/2010/11/16/handling-aggregated-strings-in-sql-reports
November 16, 2010. November 16, 2010. Handling aggregated strings in SQL reports. Well, it’s been a long time without a new post from me so I thought I’d get the ball rolling again! Having been surfing about and happened upon Adrian Billington’s. Site again, I spotted something pretty nifty. With a bit of rewriting, I started to see a possible benefit to the APEX community – mostly for the handling of multiselect list values in reports. Consider this example of the that approach…. 2 thoughts on “ H...
munkyben.wordpress.com
About – munky on oracle
https://munkyben.wordpress.com/about
My name’s Ben Burrell and I’m an Oracle developer currently based in the Isle of Man. The aim of this blog is to share tips and tricks in SQL tuning, PL/SQL programming and APEX development in Oracle. I will be posting as I come across things in my day-today work and also documenting some things that I’ve already been doing for a while. Enter your email address to follow this blog and receive notifications of new posts by email. Follow me on Twitter. Boneist's Oracle Blog. Join 255 other followers.
munkyben.wordpress.com
HAI CAN HAS TABULAR FORM CHECKBOX KTHXBYE – munky on oracle
https://munkyben.wordpress.com/2012/02/07/hai-can-has-tabular-form-checkbox-kthxbye
February 7, 2012. HAI CAN HAS TABULAR FORM CHECKBOX KTHXBYE. Ok, here’s my first blog post in a long while. It’s well overdue, I know. I spurred myself into doing it by proclaiming my intent over twitter, dangerous – no choice now! So I’ll start myself off with a short and simple that I came across the other day, hopefully it will help someone. What the hell had I done to break such a fundamental function in APEX? Here’s the exact error from Firebug;. PUT SOMETHING IN THE…. AND IN THE…. Enter your email ...
munkyben.wordpress.com
UKOUG 2010 APEX meetup! – munky on oracle
https://munkyben.wordpress.com/2010/11/27/ukoug-apex-meetup
November 27, 2010. November 27, 2010. UKOUG 2010 APEX meetup! Venue: Pennyblack’s at The Mailbox – http:/ www.pennyblacksbar.com. Time: Monday 29th November arrive 8:00pm – 8:30pm. Leave a Reply Cancel reply. Enter your comment here. Fill in your details below or click an icon to log in:. Address never made public). You are commenting using your WordPress.com account. ( Log Out. You are commenting using your Twitter account. ( Log Out. You are commenting using your Facebook account. ( Log Out.
munkyben.wordpress.com
OUG Ireland 2012 – munky on oracle
https://munkyben.wordpress.com/2012/03/28/oug-ireland-2012-16
March 28, 2012. March 28, 2012. Long time no speaky! Well, on 21st March 2012, I spoke at the OUG Ireland conference. The title of the presentation was “to iterate is human, to recurse divine”. 8211; a touch pretentious, I know. The event started for me the night before, meeting Roel Hartman, Jan Navratil and Frits Hoogland for some beers and food (followed by a few more beers and some pool). I’m going to try and blog regularly from now on, but I’ve said that before and failed. Thank you very much! You a...
orastory.wordpress.com
SQL Plan Management Choices | OraStory
https://orastory.wordpress.com/2015/08/11/sql-plan-management-choices
Dominic Brooks on Oracle Performance, Tuning, Data Quality and Sensible Design … (Now with added Sets Appeal). Quick Cross-Period AWR Comparison →. SQL Plan Management Choices. August 11, 2015. My thoughts on SQL plan management decision points:. Are also available, primarily to avoid a specific problem not to enforce a particular plan, and are not covered in the above flowchart. SQL Plan Management Choices. August 11, 2015 at 1:22 pm. Very nice job Dom. Leave a Reply Cancel reply. Enter your comment here.
SOCIAL ENGAGEMENT