| SQL Developer Code Formatting issue [message #568466] |
Fri, 12 October 2012 01:14  |
Manoj.Gupta.91
Messages: 239
Registered: March 2008
Location: Delhi
|
Senior Member |
|
|
Hi All,
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.
Thanks & Regards
Manoj
|
|
|
|
|
|
|
|
| Re: SQL Developer Code Formatting issue [message #568493 is a reply to message #568492] |
Fri, 12 October 2012 07:06  |
 |
thatjeffsmith
Messages: 81
Registered: July 2009
Location: Raleigh, NC
|
Member |
|
|
The 'create or replace' isn't actually stored in the database, we're artificially adding it when you see it in the Procedure Editor. If you want it uppercased, use the formatter. There's a formatter option for UPPER keywords, and CREATE OR REPLACE will get included in this.
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.
[Updated on: Fri, 12 October 2012 07:08] Report message to a moderator |
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
