Been a while - new theme coming...
The theme will be "I didn't know that..." - or "What I learned new today..."
I am constantly amazed as what I don't know - given that I've been using Oracle for 23 years now - you might think that would be a small set of things. It isn't, it is quite large.
Here is one thing I learned new today. It is about SQL*Plus. A pretty simple tool, been using it for a long long long time. Been using it since it was an extra cost option to the database!
Anyway, did you know that you could put @file into a SQL command?
ops$tkyte%ORA10GR2> !cat test.sql
select * from dual;
ops$tkyte%ORA10GR2> explain plan for
1 explain plan for
2* select * from dual
Neat - I did not know that.
I have more, I'll let them leak out day by day (or so)...