Duration: 25:36 min
Summary: One of the most important concepts for a developer what work with an Oracle database is the PL/SQL block. This construct allow the creation of complex programing logic like any other programming language and also with the benefits of the SQL statements. This video explains the concept and components of a PL/SQL and focus on how to work with normal variables created in the DECLARE session of the block. The video also explain the two other types of variables that can be used only SQLPlus: host and bind variables. The examples shown in this video demonstrate how to create, assign, use and display the contents of the three types of variables (normal, host and bind).