Add a comment button in SQL Developer

GregV

Hi,

In SQL Developer you can comment a line or a block using "Source -> Toggle Line Comments" (Ctrl-Slash), but it would be nice to have a button that allows you to do it not only for line or block, but also for a part of a line.

Suppose I have the following block:

DBMS_OUTPUT.Put_Line('Hello World! How is it going today?');

IF mood = 'OK' AND weather = 'SUNNY' AND coffee_available

THEN

    DBMS_OUTPUT.Put_Line('Great!');

END IF;

The button would allow me to do something like:

/*DBMS_OUTPUT.Put_Line('Hello World! How is it going today?');

IF mood = 'OK' AND weather = 'SUNNY' AND coffee_available

THEN

    DBMS_OUTPUT.Put_Line('Great!');

END IF;*/

But also like:

DBMS_OUTPUT.Put_Line('Hello World! How is it going today?');

IF mood = 'OK' /*AND weather = 'SUNNY'*/ AND coffee_available

THEN

    DBMS_OUTPUT.Put_Line('Great!');

END IF;

BPeaslandDBA

SQL Developer requests should be posted to the Exchange. https://apex.oracle.com/pls/apex/f?p=43135:1

ApexBine

I like the idea.

Maybe this SQL Developer Exchange feature request is the right one? https://apex.oracle.com/pls/apex/f?p=43135:7:::NO:RP,7:P7_ID:37301

William Robertson

Yes I suppose it would be nice if this basic feature existed in SQL Dev as it does in rival products. I'm not sure it counts as a Database Idea, though.

Sven W.

Don't think I would use it, since I prefere single line comments most of the time, but it can't hurt to have such an option.

Btw. on German keyboards Ctrl+/ does not work (not without pressing several other buttons at the same time), so I remapped it to CTRL+- . Which I feel is more intuitive anyway.

CTRL+/ could then be reused for multiline comments. So maybe a keyboard command instead of the button.

trianta-JavaNet

Do we have an update on whether there is option to comment block of sql code in oracle sql developer? the signs for block commenting should be /* sql code to be commented */

Thank you all.

Gerald Venzl-Oracle

Being an idea or enhancement for SQL Developer it belongs to the SQL Developer Exchange as already mentioned below. We will close this idea here. Please refer to either the link provided here or to the similar idea that was already posted above.

Thanks for your contribution to the community!