SQL Developer Code Formatting issuehttp://www.orafaq.com/forum/./mv/msg/184471/568466/#msg_568466
I'm using SQL Developer tool for Oracle 11g. When I'm creating any package, procedure or function "CREATE OR REPLACE" is automatically converted to lower case at compile time even if I'm typing it in upper case.

Please help me to know which setting I should use to keep it in upper case.

Or disable it and it will leave your code as is.]]>thatjeffsmith2012-10-12T10:20:48-00:00Re: SQL Developer Code Formatting issuehttp://www.orafaq.com/forum/./mv/msg/184471/568492/#msg_568492
This setting is set to "Upper Keywords".

All other keywords are in Upper Case but "CREATE OR REPLACE" changes to Lower Case on compilation.

Please help.

Thnaks & Regards
Manoj]]>Manoj.Gupta.912012-10-12T10:42:49-00:00Re: SQL Developer Code Formatting issuehttp://www.orafaq.com/forum/./mv/msg/184471/568493/#msg_568493
You can enable 'autoformat PLSQL in Procedures, Packages, View and Triggers' in the preferences and this will happen as you open the objects in the editors.]]>thatjeffsmith2012-10-12T12:06:52-00:00Re: SQL Developer Code Formatting issuehttp://www.orafaq.com/forum/./mv/msg/184471/568499/#msg_568499
But autoformat option will format all the part not just "create or replace".