I have found that block comments in strings are not taken into account when using "convert selection to comment text".
On the other hand, the comment characters are also removed in strings when the opposite function "convert selection from comment text to normal text" is used.
example: want to comment the execute immediate call
execute immediate adamadm.M_UT.A_SEL_SET_STMT('
insert
into xyz
(col1, col2 /*,col3*/)
select colA, colB /*,colC*/
from zyx
where colC= :ID
') using l_ID;
return;
... mark it and use Edit|Selection|Comment
/* execute immediate adamadm.M_UT.A_SEL_SET_STMT('
insert
into xyz
(col1, col2 /*,col3*/)
select colA, colB /*,colC*/
from zyx
where colC= :ID
') using l_ID;*/
return;
... this will not compile. So mark it again and use Edit|Selection|UnComment
execute immediate adamadm.M_UT.A_SEL_SET_STMT('
insert
into xyz
(col1, col2 ,col3)
select colA, colB ,colC
from zyx
where colC= :ID
') using l_ID;
return;
This compiles with no error but, now the original comments in the sql statement are missing!
On the other hand, the comment characters are also removed in strings when the opposite function "convert selection from comment text to normal text" is used.
example: want to comment the execute immediate call
execute immediate adamadm.M_UT.A_SEL_SET_STMT('
insert
into xyz
(col1, col2 /*,col3*/)
select colA, colB /*,colC*/
from zyx
where colC= :ID
') using l_ID;
return;
... mark it and use Edit|Selection|Comment
/* execute immediate adamadm.M_UT.A_SEL_SET_STMT('
insert
into xyz
(col1, col2 /*,col3*/)
select colA, colB /*,colC*/
from zyx
where colC= :ID
') using l_ID;*/
return;
... this will not compile. So mark it again and use Edit|Selection|UnComment
execute immediate adamadm.M_UT.A_SEL_SET_STMT('
insert
into xyz
(col1, col2 ,col3)
select colA, colB ,colC
from zyx
where colC= :ID
') using l_ID;
return;
This compiles with no error but, now the original comments in the sql statement are missing!
Last edited:
