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)
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
CREATE OR REPLACE PROCEDURE RANCOM_PROC
AS
BEGIN
INSERT INT NE_TABLE SELECT 1 FROM DUAL;
END;
SHOW ERRORS
SnowSQL (CLI Client)
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;
$$;
!!!RESOLVE EWI!!! /*** SSC-EWI-0073 - PENDING FUNCTIONAL EQUIVALENCE REVIEW FOR 'SHOW STATEMENT' NODE ***/!!!
SHOW ERRORS;
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
show all;
SnowSQL (CLI Client)
!options
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
SSC-EWI-0073: Pending Functional Equivalence Review.
Last updated