Break

Transformation for this command is pending

Description

Specifies where changes occur in a report and the formatting action to perform. (Oracle SQL Plus User's Guide and Reference)

BRE[AK] [ON report_element [action [action]]] ...

report_element := {column|expr|ROW|REPORT}

action := [SKI[P] n|[SKI[P]] PAGE] [NODUP[LICATES]|DUP[LICATES]]

Snowflake does not support the use of this command and does not have any that might resemble its functionality. At the time of transformation, an EWI will be added.

1. BREAK command

Oracle

IN -> Oracle_01.sql
BREAK ON customer_age SKIP 5 DUPLICATES;

SnowSQL (CLI Client)

OUT -> Oracle_01.sql
!!!RESOLVE EWI!!! /*** SSC-EWI-0073 - PENDING FUNCTIONAL EQUIVALENCE REVIEW FOR 'BREAK STATEMENT' NODE ***/!!!
BREAK ON customer_age SKIP 5 DUPLICATES;

Known Issues

No Known Issues.

Last updated