Friday, May 10, 2019

Loops in Stored Procedures

Whenever we execute a procedure each query or statement is executing once. 
Loop is a programming concept which is used to execute a group of statements repeatedly for the specific no of times.

3 Types of Loops :-
- Simple Loop
- For Loop
- While Loop

No comments:

Post a Comment

Snowflake Database

 CREATING A WAREHOUSE : --------------------------------------- CREATE OR REPLACE WAREHOUSE FIRST_WAREHOUSE WITH WAREHOUSE_SIZE = XSMALL AUT...