Interacting with the Oracle Server - Oracle PL SQL Course - Lesson 18 | SQL courses

Duration: 17:08 min

Summary: A PL/SQL block may contain many lines of code to implement a business logic or an algorithm and it is subject to the syntax rules of the PL/SQL language. Besides traditional syntax elements it is also possible to use some SQL statements inside a PL/SQL block from the DML (Data Management Language) set of commands. This video shows how to use the SELECT, INSERT, UPDATE and DELETE statement commands inside a PL/SQL and focus on the two main requirements for a SELECT statement inside a PL/SQL block: the INTO clause to assign variable values and the need to affect only one row. This video also discusses some aspects of Oracle implicit and explicit cursors and their attributes.