Скачать с ютуб How to use the Postgresql pl/sql FOR LOOP statement- 6 Examples including keywords EXIT and CONTINUE в хорошем качестве

How to use the Postgresql pl/sql FOR LOOP statement- 6 Examples including keywords EXIT and CONTINUE

FOR LOOP statements are available in PostgreSQL to iterate over a range of integers, a result set, or the result set of a dynamic query. A FOR loop in PostgreSQL is a control structure that allows you to execute a block of code repeatedly for a specific number of times or until a specific condition is met. It is useful for performing a set of operations on a collection of data, such as iterating over a table and performing an operation on each row. For example, you could use a FOR loop to iterate over a table of data and insert each row into another table. Table of Contents 00:00 Hey Team 00:08 First example - basic FOR statement 01:05 Example 2 - Fahrenheit to Celsius, using FOR STATEMENT 02:57 - Example 3 - Use For loop in REVERSE order - show ascii characters 03:51 - add consecutive numbers, also see Carl Gauss method 05:54 - How to use the EXIT keyword when using the FOR statement 07:23 - How to use the CONTINUE keyword when using the FOR statement 09:01 - End of video message how to use the "Raise Notice" method to display output results #softwareNuggets, ‪@SoftwareNuggets‬, #share_to_be_better