Wednesday, 12 October 2011

JDeveloper Group By Insight Preference

During Oracle OpenWorld a customer asked how to turn off the autogenerate of GROUP BY clause when using JDeveloper.

SQL Developer has a preference


But JDeveloper is missing this preference, and it is turned on by default.
This will be rectified in a future realese of JDeveloper but in the mean time there is a workaround.

1) Close JDeveloper.
2) Open JDevelopers product-preferences.xml file.
This can be found under
c:\Users\\AppData\Roaming\JDeveloper\\o.jdeveloper\
on windows 7. Or in the usual place applications persist preferences in your OS.
3)Add the following after the ide tag.

<hash n="DBConfig">
<value n="AUTOGENERATEGROUPBY" v="false"/>
<hash n="EXTENSION"/>
<value n="INDENT_CACHE_NUMBER" v="2"/>
<value n="INDENT_CACHE_USE_TAB" v="false"/>
</hash>


.

4) Restart JDeveloper, and Autogenerate GROUP BY should not turned off.