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)

Oracle Syntax

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

Command

SELECT 'hello world' FROM dual;
REMARK and now exit the session
EXIT;

SnowSQL (CLI Client)

Command

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

Command

IN -> Oracle_01.sql

REMARK single line

REMARK first line
HOST dir *.sql

REMARK first line
SELECT 'hello world' FROM dual;

SnowSQL (CLI Client)

Command

OUT -> Oracle_01.sql

!!!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

1. SSC-EWI-0073: Pending Functional Equivalence Review.