Last year I have presented a couple of times about the result cache. You can download this presentation from my new Presentations and papers tabpage, by the way. After each of those sessions I received several good questions. To some questions I didn't know the answer, and for some other questions I did, but I hadn't tested it so I wasn't absolutely sure. I promised to address those questions
On June 9 and 10, I'll be doing a SQL Masterclass seminar for Oracle University in Tallinn, Estonia. You can find the details here.
This post contains four unrelated notes.First a small SQL*Plus tip. I really like to know with which user I am connected to which database, so in my login.sql script I used to have this section:define gname=idlecolumn global_name new_value gnameselect lower(user) || '@' || substr(global_name,1,decode(dot,0,length(global_name),dot-1)) global_namefrom (select global_name,instr(global_name,'.'
Google has a lot of API's that you can use in SQL and PL/SQL as well. A couple of months ago I saw a very nice example on OTN here. It was an example of how to use Google's Translate API. Here is how to do it yourself.First of all, since version 11, you need to specify fine grained access to external network services, which is described here in the documentation. The package
In my presentation and paper about grouping last year, I mentioned that an aggregation query without a group by clause is the same as grouping by the empty grouping set. So this query:SQL> select count(*) 2 from emp 3 / COUNT(*)---------- 141 rij is geselecteerd.is the same as:SQL> select count(*) 2 from emp 3 group by () 4 / COUNT(*)---------- 141 rij is
Yesterday I came back from my third Oracle OpenWorld. This year I was not on a bloggers pass, so I feel less obliged to cover the event. But I know there are people out there that like to read about my experiences and I still like it very much at San Francisco, so here is a small write-up about my experiences at Oracle OpenWorld 2010.The event started at Sunday, but later than usual: 12:30 PM I