Home » SQL & PL/SQL » Client Tools » SQL Developer Code Formatting issue ( Version 3.2.09)
SQL Developer Code Formatting issue [message #568466] Fri, 12 October 2012 01:14 Go to next message
Manoj.Gupta.91
Messages: 186
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 #568490 is a reply to message #568466] Fri, 12 October 2012 05:20 Go to previous messageGo to next message
thatjeffsmith
Messages: 29
Registered: July 2009
Location: Raleigh, NC
Junior Member

Tools > Preferences > Code Editor > Completion Insight

'Change case as you type'

Set dropdown selector to 'Upper Keywords'

Or disable it and it will leave your code as is.
Re: SQL Developer Code Formatting issue [message #568492 is a reply to message #568490] Fri, 12 October 2012 05:42 Go to previous messageGo to next message
Manoj.Gupta.91
Messages: 186
Registered: March 2008
Location: Delhi
Senior Member
Hi,

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
Re: SQL Developer Code Formatting issue [message #568493 is a reply to message #568492] Fri, 12 October 2012 07:06 Go to previous messageGo to next message
thatjeffsmith
Messages: 29
Registered: July 2009
Location: Raleigh, NC
Junior 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

Re: SQL Developer Code Formatting issue [message #568499 is a reply to message #568493] Fri, 12 October 2012 08:04 Go to previous message
Manoj.Gupta.91
Messages: 186
Registered: March 2008
Location: Delhi
Senior Member
Hi,

But autoformat option will format all the part not just "create or replace".

right?

Thanks & Regards
Manoj
Previous Topic: First Login with SQL DEVELOPER
Next Topic: Alter Session of Connections in JBoss Connection Pool
Goto Forum:
  


Current Time: Thu Apr 17 17:12:25 CDT 2014

Total time taken to generate the page: 0.19112 seconds