OUG Ireland Call for submissions is now open.
The closing date for submissions is 5th January, 2015.
and the submission webpage can be found here.
The OUG Ireland conference will be on Thursday 19th March. Yes it is only a one day conference 😦 but we will be 5 or 6 or more streams. So there will be something for everyone and plenty of choice.
On Friday 20th March we will have Maria Colgan, formally the Optimizer Lady and now the In-Memory Queen (or something like that), giving a full day workshop on the In-Database option and the Optimizer. She will also be about for the main conference on the 19th, so you can expect a presentation or two from her on the Thursday.
Agenda selection day is the 8th January, 2015. So hopefully you will be getting the acceptance emails soon after that or during week of 12th January.
There is a committee of about 10 people who are involved in selecting presentations and setting the agenda. If it was up to me then I would accept everything/everyone. So if your presentation is not accepted this time, please don’t blame me 🙂 I said YES to your presentation, I really, really did. I fought so hard to have your presentation included. If your presentation is not accepted then the blame is down to the other committee members 🙂
The conference will be held in Croke Park, and is a 15-20 minute taxi ride from the Airport.
You can follow the Conference and other OUG Ireland events using the twitter tag #oug_ire
The agenda for the OUG Ireland 2013 event is now live. The event will be in the Dublin Convention Centre on the 12th March. There are lots of excellent sessions, across 7 tracks!! So there will be something (or lots of things) for everyone who works in the Oracle world here in Ireland.
I’m sure the Oracle Database track will be very popular. I wonder why!!!
Remember registration is FREE. You don’t have to be a member of the User Group to come to this event. It is open to everyone and did I mention that it is FREE. Registration is now open.
I’ll be there. Well I suppose I have to as I’ll be presenting
I hope to see you there.
Tom Kyte will be back in Dublin on the 21st January, 2013. He will be giving a number of presentations covering some of his popular Oracle Open World sessions and will also include a AskTom session
It will be a full day, kicking off at 9am and finishing around 3:30pm.
There is no better way to kick off the new year with a full day of FREE Oracle training and up skilling with Tom Kyte.
To register for the event send an email to firstname.lastname@example.org
As they say places are limited, so book early, I have so I’ll see you there.
The call for presentations at the OUG Ireland Conference is now open. The conference will be on Tuesday 12th March in Dublin city centre.
It is hoped to have at a number of concurrent tracks covering all the main topic areas, including application development, database administration, business intelligence, applications, etc.
If you are interested in submitting a presentation then you need to fill in some of the detail at
Follow the OUG Ireland conversation on twitter using the tag #oug_ire
Over the past few days I’ve had a number of emails and comments based on my previous post. My previous post was called ‘Adding numbers between two values’. I included some PL/SQL code that can be used to add up the numbers between two values. I mentioned that this was a question that my pre-teen son (a few year pre-teen) had asked me.
There are two main solutions to the same problem. One involves just using a SELECT and the other involves using recursion. I will come back the these alternative solutions below.
But let me start off with a bit more detail and background to why I approached the problem the way that I did. The main reason is that my son is a pre-teen. Over the past couple of years he as expressed an interest in what his daddy does. We even have matching ORACLENERD t-shirts
When I was working through the problem with my son I wanted to show him how to take a problem and by breaking it down into its different parts we can work out an overall solution. We can then take each of these parts and translate them into code. In this case some PL/SQL, yes it is a bit nerdy and we do have the t-shirt. The code that I gave illustrates many different parts of the language and hopefully he will use some of these features as we continue on our learning experience.
It is good sometimes to break a problem down into smaller parts. That way we can understand it better, what works and what does not work, if something does not work then we will know what bit and also leads to easier maintenance. At a later point as you develop an in-depth knowledge of certain features of a language you can then rewrite what you have to be more efficient.
All part of the learning experience.
Ok lets take a look at the other ways to answer this problem. The first approach is to just use a single SELECT statement.
SELECT sum(rownum + &&Start_Number – 1)
CONNECT by level <= &End_Number – &&Start_Number + 1;
An even simpler way is
CONNECT BY level between &Start_Number and &End_Number;
These queries create a hierarchical query that produce all the numbers between the Start_Number parameter and the End_Number parameter. The SUM is needed to all all the numbers/rows produced. This is nice and simple (but not that easy for by son at this point).
Thank you to everyone who contacted me about this. I really appreciated your feedback and please keep your comments coming for all my posts.
Oracle Open World is fast approaching. Over the past couple of weeks I have been using the schedule builder tool to work out what sessions I would like to attend. Unfortunately there are LOTS of sessions I would love to attend but I haven’t worked out a way to be in 10 places at the same time.
When attending a conference I try to achieve a number of things. These are find out about new topics/features, benchmark my knowledge of existing topics, try some of the hands-on labs, try something new and do something completely different. This will be my challenge at Oracle Open World.
There are a number of other people from Ireland who will be attending OOW, and there are some plans to have an Ireland social event. Plus there is lots of meetings/catch-ups planned too with people I know from the virtual Oracle world.
There will be some people from AIB who will be presenting at OOW. Their presentation will be on the Tuesday morning 10:15-11:00. I’ll be there.
Other social things that are on include the Oracle ACE dinner, the Oracle Music festival, with Kings of Leon playing support to Pearl Jam on the Wednesdays night.
It is going to be a busy week, an enjoyable week, a week of learning new things and finding out lots of what the 12c database will be like.
Will I get time to go to everything ? The simple answer is NO. So I will just have to try to get to another Oracle Open World soon.
Over the next couple months there are a number of events happening for Oracle Users in Ireland.
There are a number of OUG Ireland SIG meetings happening. These are:
11th September : Joint SIG meeting of the BI & EPM SIG and the first Tech SIG meeting
12th September : HCM SIG meeting
20th November : BI & EPM SIG. This will be a full day SIG event.
3rd-5th December : The annual UKOUG Conference in Birmingham. There is usually a good attendance from Ireland at this conference. On the Monday night there will be the focus pubs. Join me at the Ireland table.
Oracle and the Oracle User Group have arrange to have Tom Kyte come to Dublin on 19th September, to give a number of presentations. Check out this link for more details and how to register.
Oracle will be having an Oracle Technology Day in Dublin on 15th November in the Croke Park Conference Centre. They will be talking about Cloud Computing, Mobile Computing, Social Media and Big Data. They are also hoping to include some of the updates and product news that will be announced at Oracle Open World in early October. You will need to register for this event.
Summary of Dates & Events to add to your diary.
11th September : OUG Ireland BI & EPM and Tech SIG meeting
12th September : OUG Ireland HCM SIG meeting
19th September : Tom Kyte in Dublin
15th November : Oracle Technology Day
3rd- 5th December : UKOUG Conference in Birmingham.