Control Structures - Oracle PL SQL Course - Lesson 19 | SQL courses

Duration: 20:04 min

Summary:The control structure commands inside a PL/SQL block are the statements used to handle the flux of execution. They are used to implement business logic inside the block to program an algorithm. This video shows how to use the IF, ELSE, ELSEIF, CASE, LOOP, WHILE and FOR statements inside a PL/SQL block by explaining the purpose, the syntax and how these commands can be used in very simple examples. Once the developer know how to use those control structures he/she can develop many complex business logic inside the Oracle that can address different requirements inside the database without needing to program it on the application programming language.