Change

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 CHANGE command Changes the first occurrence of the specified text on the current line in the buffer. (Oracle SQL Plus User's Guide and Reference)

Oracle Syntax

C[HANGE] sepchar old [sepchar [new [sepchar]]]

Snowflake does not have a direct equivalent to this command. The Snowflake !edit command can be used to edit the last query using a predefined text editor. Whenever this approach does not cover all the CHANGE functionality but it is an alternative.

1. Change command

Oracle

Command

IN -> Oracle_01.sql

CHANGE /old/new/

SnowSQL (CLI Client)

Command

OUT -> Oracle_01.sql

!!!RESOLVE EWI!!! /*** SSC-EWI-0073 - PENDING FUNCTIONAL EQUIVALENCE REVIEW FOR 'CHANGE STATEMENT' NODE ***/!!!
CHANGE /old/new/;

Known Issues

1. Unsupported scenarios

The CHANGE command can be presented in various ways, of which 2 of them are not currently supported by the translator, these are presented below:

3  WHERE col_id = 1

Entering a line number followed by a string will replace the line regardless of the text that follows the line number. This scenario is not supported as this does not follow the command grammar.

CHANGE/OLD/NEW/

Enter the text to replace followed by the command without using spaces. This scenario is not supported since it does not follow the logic of tokenization by spaces.

Related EWIs

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