Forum Stats

  • 3,827,013 Users
  • 2,260,733 Discussions
  • 7,897,146 Comments

Discussions

Add a comment button in SQL Developer

GregV
GregV Member Posts: 3,085 Gold Crown
edited Aug 11, 2017 12:44PM in Database Ideas - Ideas

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;

BoneistBPeaslandDBAKayKuser12189461vinaykumar2balaji.jayaraman -OracleMartin PreissSven W.Deepak Kamath-Oracletrianta-JavaNet
9
11 votes

Archived · Last Updated

Comments