Remark
Transformation for this command is pending
Description
The
REMARK
command begins a comment in a script. SQL*Plus does not interpret the comment as a command.. (Oracle SQL Plus User's Guide and Reference)
REM[ARK] comment
Snowflake does not have a direct equivalent for this command. However, some of its functionalities can be emulated.
1. Remark after the first line
This case is functionally equivalent.
When the REMARK
command is not at the beginning of a script you can use the standard SQL comment markers and double hyphens.
Oracle
SELECT 'hello world' FROM dual;
REMARK and now exit the session
EXIT;
SnowSQL (CLI Client)
select 'hello world';
-- and now exit the session
!exit
2. Remark on the first line
This case is not functionally equivalent.
When the REMARK
command is at the beginning of a script, scenarios could appear such as:
Case 1: The next line is a query, in which case the conversion to Snowflake of the REMARK
command succeeds.
Case 2: The next line is another SQL*Plus command, in which case the conversion cannot be performed since Snowflake is not capable of executing either of the two statements (This also applies to the scenario where there is only one statement in the script statement that corresponds to the REMARK
command).
Below are some examples, where the first two could not be translated correctly.
Oracle
REMARK single line
REMARK first line
HOST dir *.sql
REMARK first line
SELECT 'hello world' FROM dual;
SnowSQL (CLI Client)
!!!RESOLVE EWI!!! /*** SSC-EWI-0073 - PENDING FUNCTIONAL EQUIVALENCE REVIEW FOR 'REMARK STATEMENT' NODE ***/!!!
REMARK single line;
!!!RESOLVE EWI!!! /*** SSC-EWI-0073 - PENDING FUNCTIONAL EQUIVALENCE REVIEW FOR 'REMARK STATEMENT' NODE ***/!!!
REMARK first line;
!!!RESOLVE EWI!!! /*** SSC-EWI-0073 - PENDING FUNCTIONAL EQUIVALENCE REVIEW FOR 'HOST STATEMENT' NODE ***/!!!
HOST dir *.sql;
!!!RESOLVE EWI!!! /*** SSC-EWI-0073 - PENDING FUNCTIONAL EQUIVALENCE REVIEW FOR 'REMARK STATEMENT' NODE ***/!!!
REMARK first line;
SELECT 'hello world' FROM dual;
Known Issues
No Known Issues.
Related EWIs
SSC-EWI-0073: Pending Functional Equivalence Review.
Last updated