Home > IT Answers > Oracle > un-format object viewer sql tab
Blackrebelmotorcyclefairy
15 pts.
 un-format object viewer sql tab
Oracle SQL, Oracle SQL Developer, SQL, SQL Server
Hi experts, Can someone tell me, how can I turn off automatic code formating on the Object viewer's SQL tab (i.e. the sql code in the SQL tab of an opened view is automatically formated compared to the code I used to create it) Thnx in advance for yr answers

Software/Hardware used:
Oracle SQL Developer (2.1.1.64)
ASKED: February 11, 2011  8:13 AM
UPDATED: February 11, 2011  3:05 PM
RELATED QUESTIONS
Answer Wiki:
Try going to: Tools->Preferences->Database->SQL Formatter Look for a check box "Autoformat PLSQL in procedures, packages, views and triggers", and uncheck it. This is the path to the option in version 1.5.3 (it could change from version to version). ------------------
Last Wiki Answer Submitted:  February 11, 2011  2:29 pm  by  Nabiha   15 pts.
All Answer Wiki Contributors:  Nabiha   15 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

The first thing I did is, unchecked Autoformat PL/SQL…(the path is still the same in my version) and the output on the SQL tab is still formated.

also I unchecked Tools–>Preferences–>Database–>ObjectViewer ‘Pretty format’
and still the output is formated.

Blackrebelmotorcyclefairy
 15 pts.