Stored Procedures — Question 3
Create a stored procedure called decrease_mango_sticky_rice_price that decreases the price by 1 dollar for the item with the MENU_ITEM_NAME of “Mango Sticky Rice”. If you run the SHOW PROCEDURES command, what value do you see in the “arguments” column in the row associated with decrease_mango_sticky_rice_price?
This exercise is part of the course
Intro to Snowflake for Devs, Data Scientists, Data Engineers
Hands-on interactive exercise
Turn theory into action with one of our interactive exercises
Start Exercise