Show

Transformation for this command is pending

Description

Shows the value of a SQLPlus system variable or the current SQLPlus environment. (Oracle SQL Plus User's Guide and Reference)

Oracle Syntax

SHO[W] system_variable  ALL BTI[TLE]  CON_ID  CON_NAME EDITION  ERR[ORS] [ {ANALYTIC VIEW | ATTRIBUTE DIMENSION | HIERARCHY | FUNCTION | PROCEDURE | PACKAGE | PACKAGE BODY | TRIGGER | VIEW | TYPE | TYPE BODY | DIMENSION | JAVA CLASS } [schema.]name]HISTORY  LNO  LOBPREF[ETCH]  PARAMETER[S] [parameter_name]  PDBS PNO  RECYC[LEBIN] [original_name]  REL[EASE]  REPF[OOTER]  REPH[EADER]  ROWPREF[ETCH] SGA SPOO[L]  SPPARAMETER[S] [parameter_name]  SQLCODE STATEMENTC[ACHE] TTI[TLE] USER XQUERY

Snowflake does not have a direct equivalent for this command. However, some of its functionalities can be emulated.

1. Show ERRORS

Shows the compilation errors of a stored procedure (includes stored functions, procedures, and packages). After you use the CREATE command to create a stored procedure, a message is displayed if the stored procedure has any compilation errors.

In Snowflake, performing an extra statement to display all the compilation errors is unnecessary. The compilation errors are displayed immediately when executing the CREATE statement.

Oracle

Command

CREATE OR REPLACE PROCEDURE RANCOM_PROC
AS
BEGIN
  INSERT INT NE_TABLE SELECT 1 FROM DUAL;
END;

show errors

Result

Note that the INTO keyword is misspelled in order to cause a compilation error.

SnowSQL (CLI Client)

Command

CREATE OR REPLACE PROCEDURE PUBLIC.RANCOM_PROC ()
    RETURNS VARCHAR
    LANGUAGE SQL
    EXECUTE AS CALLER
    AS
    $$
    BEGIN
            INSERT INT PUBLIC.NE_TABLE
            SELECT 1 FROM DUAL;
    END;
    $$;

-- ** MSC-ERROR - MSCEWI1073 - PENDING FUNCTIONAL EQUIVALENCE REVIEW FOR 'SHOW STATEMENT' NODE **
--    show errors
               ;

Result

Show ALL

Lists the settings of all SHOW options, except ERRORS and SGA, in alphabetical order.

In order to display all the possible options in SnowCLI you can run the !options command.

Oracle

Command

show all;

Result

SnowSQL (CLI Client)

Command

!options

Result

Known Issues

1. It's not possible in SnowCLI to display de value of a single option.

SnowCLI does not provide a way to display the value of a specific option. You may use !options to watch the value of the option.

2. Research is pending to match each SQLPLUS option to a SnowflakeCLI equivalent.

It is pending to define an equivalent for each SQLPLUS option.

Related EWIs

No related EWIs