Two things I learned this week...
Here are the two new things I learned - the first is regarding temporary tablespaces. In the past - when people have asked "how can I shrink my temporary tablespace" I've said "create a new one that is smaller, alter your database/users to use this new one by default, wait a bit, drop the old one". Actually I usually said first - "don't, it'll just grow again" but some people really wanted to make it smaller.
Now, there is an easier way:
Using alter tablespace temp shrink space
The second thing is just a little sqlplus quirk that I probably knew at one point but totally forgot. People run into problems with &'s in sqlplus all of the time as sqlplus tries to substitute in for an &variable. So, if they try to select '&hello world' from dual - they'll get:
ops$tkyte%ORA11GR2> select '&hello world' from dual;
Enter value for hello:
old 1: select '&hello world' from dual
new 1: select ' world' from dual