Discussions
Categories
- 17.9K All Categories
- 3.4K Industry Applications
- 3.3K Intelligent Advisor
- 62 Insurance
- 536.1K On-Premises Infrastructure
- 138.2K Analytics Software
- 38.6K Application Development Software
- 5.7K Cloud Platform
- 109.4K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 71.1K Infrastructure Software
- 105.2K Integration
- 41.6K Security Software
Add a comment button in SQL Developer

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;
Comments
-
SQL Developer requests should be posted to the Exchange. https://apex.oracle.com/pls/apex/f?p=43135:1
-
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
-
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.
-
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.
-
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.
-
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!