Snowflake Cloud Data Warehouse Migration From Oracle To Snowflake Tips and Tricks #10|VCKLY Tech скачать в хорошем качестве

Snowflake Cloud Data Warehouse Migration From Oracle To Snowflake Tips and Tricks #10|VCKLY Tech

In this video, I am going to show you how to migrate an Oracle DML Returning clause to snowflake. Oracle PL/SQL Block: declare l_old_code t1.code%type; -- %ROWTYPE -- RETURNS TABLE (id INT, name STRING) -- %TYPE -- NUMBER l_old_description t1.description%type; l_new_code t1.code%type; l_new_description t1.description%type; begin update t1 set code = code || '2', description = description || '2' where id = 2 returning old code , old description, new code, new description into l_old_code, l_old_description, l_new_code, l_new_description; dbms_output.put_line('l_old_code = ' || l_old_code); dbms_output.put_line('l_old_description = ' || l_old_description); dbms_output.put_line('l_new_code = ' || l_new_code); dbms_output.put_line('l_new_description = ' || l_new_description); rollback; END; Snowflake Block: eclare l_old_code varchar; l_old_description varchar; l_new_code varchar; l_new_description varchar; begin select code,description into :l_old_code,:l_old_description from t1 where id =2; update t1 set code = code || '2', description = description || '2' where id = 2; select code,description into :l_new_code,:l_new_description from t1 where id =2; return 'l_old_code = ' || l_old_code || '
' || 'l_old_description = ' || l_old_description || '
' || 'l_new_code = ' || l_new_code || '
' || 'l_new_description = ' || l_new_description; rollback; END;