Skip to Main Content

SQL Developer for VS Code

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!

Different query results for statements preceded by comment lines.

DataProcessingAug 2 2025

REM Parser recognizes comment lines changing the color to GREEN.

/* Statement execution results are wrapped in block comment */

Assume the query results should be identical. Whether the query results are ok as is, or needs redress?

--REMARK Uppercase. Select all commented lines then Run statement. Ctrl+Enter.
--rem lower case 
--Rem mixed case 
select * from ALL_OBJECTS where OWNER = 'NEO'; 
/* QUERY_RESULT panel HAS ROWS */ 


REMARK Uppercase.  Select all commented lines then Run statement. Ctrl+Enter. 
rem lower case 
Rem mixed case 
select * from ALL_OBJECTS where OWNER = 'NEO'; 
/* EMPTY - QUERY_RESULT panel */ 
This post has been answered by DataProcessing on Aug 6 2025
Jump to Answer
Comments
Post Details
Added on Aug 2 2025
5 comments
77 views