My best SQL tricks

Having worked with Oracle databases since V6.3, I have been faced with technical challenges that I had to overcome. Many of you out there will know these things already but some may benefit from the tricks I have picked up. If you have suggestions or can offer improvements, please feel free to post your comments, – I am always to learn.