Formatting PL/SQL code in SQL DEVELOPER
Home > IT Answers > Oracle > Formatting PL/SQL code in SQL DEVELOPER
Inprise
540 pts.
0
Q:
Formatting PL/SQL code in SQL DEVELOPER
PL/SQL block, Oracle SQL Developer, PL/SQL, Oracle PL/SQL
Hi Experts,

I would like to know some keyboard shortcuts and clever formating on PL/SQL codes in SQL developer

Pls hlp me out with some hints for this..

thanks n advance
ASKED: Feb 19 2009  5:49 AM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
Carlosdl
29770 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
What version of Sql Developer are you using ?

They made enhancements to the sql formatter in version 1.5

To see the available formatting options go to Tools->Preferences->Sql Formatter

To check the current keyboard shortcut to format SQL go to Tools->Preferences->Accelerators, and look for "Format SQL". I think the default accelerator is Ctrl+B
Last Answered: Feb 19 2009  1:49 PM GMT by Carlosdl   29770 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

Inprise   540 pts.  |   Feb 19 2009  6:03AM GMT

HI,

I need to understand the clever ways to format the PL/SQL ,not shortcuts …

 

Inprise   540 pts.  |   Feb 19 2009  7:03AM GMT

Hello ,

I found sqlinform a online version for formatting.

But is there direct means to get it properly done in sql developer itself

pls share ur thoughts

 

Carlosdl   29770 pts.  |   Feb 19 2009  2:01PM GMT

I tried sqlinform, and I found it pretty similar to the sql formatter in Sql Developer (ver 1.5 or above). What exactly would you want to be able to do in Sql Developer that is possible in sqlinform but not in sql Developer ?

 

Inprise   540 pts.  |   Feb 20 2009  10:13AM GMT

BEGIN .. END blocks and IF .. then checks indentation within the block..

 

Carlosdl   29770 pts.  |   Feb 20 2009  4:07PM GMT

I’m using version 1.5.3 and it does that, and much more.

You just need to select the desired code, and press Ctrl+F7 (this is the default shortcut), and it will automatically apply format including alignment and indentation, line breaks, white spaces, and others.

The formatter options are under Tools->preferences->Database->Sql Formatter.

If you are using an older version, I would recommend to download the latest.

Download Sql Developer 1.5.3 here.

 

Inprise   540 pts.  |   Feb 23 2009  4:11AM GMT

thanks yes even i am using 1.5.3,anyhow will check my formatting preference to have good formatting of my code

thanks once again.

 
0