Code block for "if-else", loops, anonymous block

[blanket]

I hope devs can add a feature like a line block that connects the start of any code block. Like in an If-Else block, there will be a line from "If" and connects it until the "End If". And for loops, start at "For" to "End Loop".

This way it will be easier to debug codes with a lot of nested if else.

Hope you can understand, English is not my first language.

Thank you.

 

[Marco Kalter]

If you place the cursor on an if/then/else/end keyword, the corresponding keywords will be highlighted.

 

[blanket]

Hi, good day. Thank you for your response. Can you tell me how to do that in a SQL Window? Seems it only work when I try to edit packages, procs, etc, thru object browser? Thanks a lot.

 

[Marco Kalter]

This function is indeed not available in a SQL Window.

 

[blanket]

I see. Can you suggest any workaround on this? Thank you.

 

[mike]

The package editor works for files also - not just from the object browser. If you are creating a package, stick with the package editor.

There are two workarounds that I do for some things (Line numbers in the command window editor, for example):

One - Right click and change the window to a package window. Put it back to a command window or sql window when you are finished.

Two - copy/paste to Notepad++ or your favorite text editor. Then put it back in PL/SQL Developer.

I used to this stuff more often, but it's becoming less needed as the editor gets better.

 

[William Robertson]

Why would you edit PL/SQL code in a SQL window? It's for SQL. I don't understand the requirement.

Also, you should not be editing code through the object browser. Don't you have source control?

 

[William Robertson]

Two - copy/paste to Notepad++ or your favorite text editor. Then put it back in PL/SQL Developer.

If you are editing an existing file (rather than just a new window), you don't need to copy and paste. You can set up an 'Edit with Notepad++' action in Configure > Tools. (Handy guide.)