Recent content by Thijs Blaauw

when I have an update statement like this: update mytable set ( col1 , col2 , col3 , col4 , col5 , col6 , col7 , col8 , col9 ) = ( select col1 , col2 , col3 , col4 , col5 , col6 ...

I see I am not very original :) Thank you for pointing out the existing solution. It is an improvement. Is the list of enhancements requests available to us, so I can check if a feature is already requested, before asking for it? Or is the priority of a request based on the number of people...

Good news, thank you.

Is it possible to configure the beautifier so that AND's in the WHERE clause start on a new line. For example: select * from a where x = 1 and y = 2; instead of: select * from a where x = 1 and y = 2; or select * from a where x = 1 and y = 2; which now seems the default? Regards...

The current Tools/Sessions window is a great tool to find which statements are taking a long time to run. If it were possible to copy the statement on the SQL text tab directly into an Explain Plan window you also could see why. I know that it is possible to copy the statement lines from the...