Snowflake SQL Stored Procedure | Snowflake Scripting | Mail Update

Опубликовано: 15 Октябрь 2024
на канале: Praveen Kumar Bommisetty

1,031

#snowflaketraining #snowflakescripting #sqlscripting #snowflakeprocedures #proceduresinsnowflake #snowflake #snowflakerealtimescenario #snowflakeinterview #snowflakeinterviewquestions #snowfalkesql #snowflakejavascripting #snowflakeexceution

Snowflake Stored Procedure :
Need to update the Mail ID of an employee using Snowflake Procedure
CREATE DATABASE PRAVEEN_DEV_DB;
USE DATABASE PRAVEE_DEV_DB;
CREATE SCHEMA PRAVEEN_DEV_SC;

SELECT CURRENT_DATABASE(),CURRENT_SCHEMA();

CREATE TABLE EMPLOYEE_DETAILS_T(EMP_ID NUMBER,
EMP_NAME VARCHAR,
MAIL_ID VARCHAR);

--DRL
SELECT * FROM EMPLOYEE_DETAILS_T;
INSERT INTO EMPLOYEE_DETAILS_T VALUES(1,'PRAVEEN','[email protected]');
INSERT INTO EMPLOYEE_DETAILS_T VALUES(2,'KUMAR',NULL);

BY USING SNOWFLAKE PROCEDURE ;

UPDATE EMPLOYEE_DETAILS_T
SET MAIL_ID = '[email protected]'
WHERE EMP_ID = 2;