SnowflakeDocumentation Home

Remark

Important Notice: Migration of Documentation Website

Please be advised that our documentation website is currently undergoing a migration to a new platform. To ensure you have access to the most up-to-date information, we kindly request that you visit our new documentation website located at:

Official Snowflake Snowconvert Documentation

For any immediate assistance or if you encounter any issues, please contact our support team at [email protected].

Thank you for your understanding.

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

IN -> Oracle_01.sql
REMARK single line

REMARK first line
HOST dir *.sql

REMARK first line
SELECT 'hello world' FROM dual;

SnowSQL (CLI Client)

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.

PreviousPromptNextSet

Last updated