This weekend has been quite an Eye-Opener. This, due to the following chain of events.
1.) Miracle had their annual Christmas Party. This gave me the opportunity to finally meet the last handful of people that I hadn´t already met (among these, 'The Chosen One'- See point 2.). It also gave me the opportunity to taste the authentic Miracle Beer from our very own Brewery. Cheers!!
2.) I found out that 'The Matrix' wasn´t actually too far off. There really is a 'Chosen One' or a 'God', if you will, in the world of PL/SQL. But his name isn´t Neo, but Egan. Morten Egan. And he actually works for Miracle, right here in little Denmark. He can do everything in PL/SQL.
I was actually taken back by the fact, that he could even manage to speak to me in plain Danish.
He is going to be VERY tired of my e-mails and my phone calls during the next two months.
Mark my words, Mr. Anderson, Ehhh I mean Mr. Egan.
3.) I finished the first two books: 'Expert Oracle Database Architecture by Tom Kyte' and 'Mastering Oracle SQL and SQL*Plus by Lex de Haan'.
4.) I got to meet James Morle, one of the founders of the Oak Table Network.
A very nice guy whom I am going to get to know him even better, when I am to read one of his books later on in the programme.
5.) I spoke to Tom Kyte on the phone.
That gave me the opportunity to tell him about what I got out of reading his book. And also give him credit, for bringing down to earth, the most technical stuff in the book, so even an ignorant like myself, can actually learn a little something about Oracle.
Speaking of Tom. Mogens would like me to send Tom a question, which can challenge him a little bit. This is pretty hard for me, since all I know about Oracle, is what I have been taught out of this book.
Therefore, I need the help of you guys out there. If you can come up with a question for Tom, please leave a comment on the blog. It could be fun if we could challenge him just a little :-)
Well, from tomorrow I will start reading two Whitepapers; 'Building Robust Applications in a Database-Centric Way by Toon Koppelaars' and 'YAPP by Anjo Kolk'.
After reading these, I will start reading 'Oracle 9i Concepts Guide'. And just to make sure, that I won´t get bored, I will also read a chapter a day from the book; 'Oracle Insights - Tales from The Oak Table'.
The Oak Table book is written by eleven 'Gurus', I think it´s safe to say.
To qoute the cover from the book; 'Eleven leading authorities on Oracle´s database engine share their unique insights on how best to exploit the software'.
The eleven 'Gurus' are Dave Ensor, Tim Gorman, Kyle Hailey, Anko Kolk, Jonathan Lewis, Connor McDonald, Cary Millsap, James Morle,
David Ruthven, Gaja Krishna Vaidyanatha
and of course Mogens Nørgaard.
Quite a list...
Jan
Abonner på:
Kommentarer til indlægget (Atom)
3 kommentarer:
Might be one for you 'Chosen One' too. It was originally posed by Howard at the Dizwell site:
http://www.dizwell.com/prod/node/900
Slightly rephrased:
Using the classic EMP table, with its normal contents, is there a query/report or data modification that can be done through PL/SQL but not in a single SQL statement ?
Requiring built-in packages like UTL_HTTP would be cheating.
No-one really came up with anything where SQL could not do the job (though, especially with larger data volumes, in some cases the SQL apparoach would have required much greater resources).
Hi Jan,
Next week Tuesday we have again a Ordina Master Class meting. Maybe we can come up with a challenging question for Tom Kyte. I will drop the question to all the OMC participants.
Regards,
Marcel.
Hi Jan,
Together with some Ordina collegues, we encountered the following (real life) problem which could perhaps serve as a question for Tom Kyte:
- we have a source table which contains all the services the customers use.
- Each row contains a customer, a service, a startdate for that service and (possibly) an enddate.
- A customer is uniquely identified by a combination of 2 columns (A and B)
What we want to do is to fill another table in which each row represents a period in which a certain customer had ANY sevice running.
To achieve this we would have to do a timeline merge of all the running services per customer.
Example.
In the source table are the following rows for one customer:
- service1 startdate T1 enddate T4
- service2 startdate T1 enddate T2
- service3 startdate T2 enddate T3
- service4 startdate T3 enddate T5
- service5 startdate T6 enddate T7
This should lead to 2 records in the destination table:
record1 startdate T1 enddate T5
record2 startdate T6 enddate T7
The question would be how to do this in the most efficient way possible.
Good luck with MEEP and
happy holidays
Hendrik-Jan Schrijvers
Send en kommentar