Snowflake Procedure Working Session | SQL Scripting

CREATE OR REPLACE PROCEDURE TABLE_COUNT_PROC()
RETURNS NUMBER
LANGUAGE SQL
AS
$$
BEGIN
SELECT ROW_COUNT
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_NAME ='EMP_T' ;
END ;
$$;

Скачать видео