Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Add a comment button in SQL Developer

GregVFeb 4 2016 — edited Aug 11 2017

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
Post Details
Added on Feb 4 2016
6 comments
19,334 views