SnowConvert helpers Code removed from the example. You can find them here.
OUT -> Oracle_01.sql
CREATEORREPLACEPROCEDURE CONCAT_TEST ()RETURNS STRINGLANGUAGE JAVASCRIPTCOMMENT = '{"origin":"sf_sc","name":"snowconvert","version":{"major":1, "minor":0},{"attributes":{"component":"oracle"}}'
EXECUTEASCALLERAS$$// SnowConvert Helpers Code section is omitted. let NUM1 =123; let NUM2 =321; let VAR1 =`value`; let CONCAT_VAR; let SQL_STMT; CONCAT_VAR =`${concatValue(NUM1)}${concatValue(NUM2)}${concatValue(VAR1)}literal`; SQL_STMT =`INSERT INTO t1VALUES ('${concatValue(CONCAT_VAR)}')`;EXEC(SQL_STMT);$$;
Logical Operators
Oracle
IN -> Oracle_02.sql
--Additional Params: -t JavaScriptCREATEORREPLACEPROCEDURE BOOLEAN_PROC (b_name VARCHAR2, b_value BOOLEAN)ISBOOL1 BOOLEAN := FALSE;x NUMBER :=5;y NUMBER :=NULL;BEGINIF b_value ISNULLTHENnull; ELSIF b_value = TRUE THENnull; ELSIF b_value = TRUE AND b_value = BOOL1 OR b_value = BOOL1 THENnull; ELSIF x > y THENnull; ELSIF x != y AND x <> y THENnull;ELSEnull;ENDIF;END;