Dear Patrick, Recently I heard someone talk about overloading in Java. What is it, is it possible in PL/SQL and if so, how would I use it? Ramesh Cumar
Read moreMonthly Archives: September 2016
When would you use a normal table function?
Dear Patrick, Last year I did a presentation on table functions at KScope. One of the questions I got was: ‘If pipelined table functions provide their results faster, why would you want to use a normal table function?’ I couldn’t come up with the answer then, maybe you can help? Erik van Roon
Read moreWhat’s the difference between SEMI-JOIN and ANTI-JOIN?
Dear Patrick, What is an ANTI-JOIN? And what is the difference between the SEMI-JOIN and the ANTI-JOIN? Lillian Sturdey
Read moreWhat is the difference between NVL and COALESCE?
Dear Patrick, Could you tell me what the difference is between NVL and COALESCE? Kindest regards, Paul McCurdey
Read moreHow do I get my query results paginated?
Dear Patrick, I have got a website with a search form. I want to display a limited number of results to the user and have him/her navigate through different pages. Is this possible using plain SQL? Kindest regards, Mitchell Ian
Read more