Recent content by rbl

Hopefully this question is acceptable for this forum but I need advice on a good SQL tuning tool that can recommend improvements to SQL statements to improve performance. Unfortunately my favorite tool PL/SQL Developer does not cater for this. Cost is essential as I have seen excellent tools to...

A stupid question that has always bugged me. Within procedures, most times I want to do a select into a variable and if no result is returned I don't want anything to happen except return a null value. Typically I handle this with something like "select max(whatever_col) into MyVariable from...