Working With CURSOR Object | Snowflake Scripting Developer Guide | Stored Procedure Tutorial | Ch-15

In this Snowflake SQL scripting developer's guide, you would learn about CURSOR objects and how it has to be used while working with stored procedure as well as anonymous block. Upon completing the "Working With CURSOR Objects " chapter-15, you'll be ready to answer the following questions: 1. How to use CURSOR objects in a stored procedure? 2. How to use fetch keyword when working with CURSOR object 3. How to iterate through a cursor and fetch individual field value from rows? 🚀🚀 Data Engineering Simplified - Social Links https://www.instagram.com/learn_dataengineering/ - Connect Via Instagram https://medium.com/@data-engineering-simplified - Read Medium Blog Pages For Articles https://www.facebook.com/groups/627874916138090/ - Join Exclusive Snowflake Facebook Group 🚀🚀 Find all SQL Scripts + Examples in Medium Blog Page https://medium.com/@data-engineering-simplified/f3a1bd5659e0 (Medium Blog Page For SQL Script) 🚀🚀 Chapters -------------------------- ➥ 00:00 Introduction ➥ 00:55 Scope of this video ➥ 01:18 Welcome Note ➥ 01:54 Part-01 CURSOR Object Construct ➥ 05:59 Part-02 Iterating Cursor ➥ 10:22 Part-03 Local CURSOR Definition ➥ 11:38 Part-04 Error Msg With Cursor ➥ 16:25 Part-05 Fetch Keyword ➥ 19:02 Part-06 Cursor inside Cursor ➥ 20:49 Part-07 Cursor & Resultset ➥ 22:38 Summary & Next Part ➥ 22:55 Thank You Note 🚀🚀 Snowflake Stored Procedure Playlist https://www.youtube.com/playlist?list=PLba2xJ7yxHB5NksIHMPirkHhOoEG3-K09 ✏ Ch-01 Snowflake Scripting For Stored Procedure Introduction https://youtu.be/-BhYp0X00P0 ✏ Ch-02 Stored Procedures Are Anti-Pattern https://youtu.be/rBwknyABYMU ✏ Ch-03 Snowflake Scripting Block Structure https://youtu.be/yBaUbCFSMjM ✏ Ch-04 How To Declare Variable https://youtu.be/CyJ9LPFMhwc ✏ Ch-05 Declare & Define Local Variables https://youtu.be/pBDeMog56AQ ✏ Ch-06 How To Use Variables https://youtu.be/U2gbypinWZs ✏ Ch-07 Multiple Variable Assignment https://youtu.be/HlrcLrbPpD0 ✏ Ch-08 Variable Visibility in nested block https://youtu.be/TvzTr8HPdtM ✏ Ch-09 Return Value/Expression/Table From Stored Proc https://youtu.be/Gl0x4yxz_Ok ✏ Ch-10 IF ELSEIF ELSE IF-END https://youtu.be/dmybW_lQuGA ✏ Ch-11 CASE/WHEN Conditional Logic https://youtu.be/oRzIqDvhyWU ✏ Ch-12 FOR Loop https://youtu.be/UzKb_TGtqpg ✏ Ch-13 WHILE Loop https://youtu.be/Q5UU5h7jdNU ✏ Ch-14 REPEAT Loop https://youtu.be/eNovcmu4Qk4 ✏ Ch-15 Work With CURSOR Object https://youtu.be/MIy3k5SzqYk ✏ Ch-16 Param Binding & CURSOR Object https://youtu.be/MIy3k5SzqYk ✏ Ch-17 Work With RESULTSET Object https://youtu.be/MIy3k5SzqYk ✏ Ch-18 Exception Handling In Stored Procedure https://youtu.be/mP-PqZsl4b8 #storedprocedure #snowflakecomputing #snowflakedatawrehouse #snowflake #dataengineeringsimplifed #DESimplified #dataengineering #clouddatawarehouse Disclaimer: All snowflake-related learning materials and tutorial videos published in this channel are the personal opinions of the data engineering simplified team and they're neither authorized by nor associated with Snowflake, Inc.