Finding Version of Oracle Database

SQLPLUS /NOLOG
CONNECT /AS SYSDBA

SELECT * FROM SYS.V_$VERSION;

A Night at the Country Opera

I’m not an Opera critic, merely and enthusiastic consumer of the art form – and unashamedly biased in the southerly direction of  WAM. This opera was one of the best and most exciting productions I’ve seen and the best at Clonter by far.  The music of course is what holds this Opera together – the story simply adds to the sheer enjoyment. I spotted a small but highlt apreciated few bars of Figaro towards the end of the second act and I rather hoping that was a subtile invitation for Figaro coming to Clonter next year.   If it is I’l be there for every performance! 

Don Giovanni may not be the most upstanding of operatic characters – but surely he is the most interesting! 

Good comment

Sometimes you see a very funny comment on a blog – well this one is in the classic range I would say.

http://www.cinemablend.com/reviews/The-Number-23-2105.html#comment-60248

DQL Duplicates

Handy for discovering if there are duplicate folders or indeed any objects

SELECT object_name  , count(*)
FROM  dm_folder
GROUP BY  object_name
HAVING COUNT(object_name) > 1