Feed items
PL/SQL Challenge Authorship
The PL/SQL Challenge site by Steven Feuerstein is great for learning various SQL and PL/SQL techniques. I am one of the quiz authors - I write most of the SQL quizzes (and one or two PL/SQL quizzes now and then.)
ROWS versus default RANGE in analytic window clause
I have talked at KScope about the difference between ROWS and RANGE in the analytic window clause, but haven't yet blogged about it. Recently while working out a quiz for the PL/SQL Challenge I discovered yet another reason for remembering to primarily use ROWS and only use RANGE when the actual problem requires it.From my KScope presentation examples here is a simple case of a rolling sum of salaries:select deptno , ename , sal , sum(sal) over (
The KScope Charitable Dinner Raffle
Recursive subquery graph traversing
In December a user Silpa asked a question on AskTom on "Bi-directional hierarchical query," which inspired me to fool around with recursive subquery factoring (available from version 11.2) giving Silpa a solution which he seemed to find useful.
I'm evaluated...
UKOUG 2012 evaluations have arrived - I think I did OK :-).On a scale from 1 to 6 my scores were:
- Topic: 5.5
- Content: 5.5
- Presentation skills: 4.83
- Quality of slides: 5
- Value of presentation: 5.67
I'm quite happy with those scores - particularly that the 6 people that filled out evaluation schemas thought they got a lot of value from the presentation. The skills score is fair, I had expected a bit less as I know I am not world class presenter - but I hope practice makes better :-)
Formspider comes to Denmark
For the Danish Oracle User Group (DOUG) I'll be hosting a Formspider event in Copenhagen January 21st 2013. I look forward to seeing Yalim Gerger demonstrate this alternative to APEX or ADF or Forms.
Thank you, UKOUG 2012
So, I'm about to leave UKOUG 2012. I had a good time and learned quite a bit from the smart people gathered in Birmingham ;-)Thank you to those attending my presentation on analytic functions - I hope you learned something from it. If you need to take a closer look, both presentation and scripts can be found here.Birmingham Airport next stop...
Analytic FIFO multiplied - part 3
This is part 3 of a three part posting on analytic FIFO picking of multiple orders. Part 3 shows how to combine the FIFO developed in part 1 with the analytics used for the better route calculation in an earlier blog post.We use the same tables and same data as part 1, so read part 1 for the setup.
Analytic FIFO multiplied - part 2
This is part 2 of a three part posting on analytic FIFO picking of multiple orders. Part 2 shows an alternative way of doing the same thing as part 1 did - but this time using recursive subquery factoring in Oracle v. 11.2.We use the same tables and same data as part 1, so read part 1 for the setup.And just to recap - here's the picking list developed in part 1:
Analytic FIFO multiplied - part 1
I have blogged before about Analytic FIFO picking as well as talked about it at KScope12 and will do again at UKOUG2012.
