Working with composite DataTypes - Oracle PL SQL Course - Lesson 20 | SQL courses

Duration: 16:34 min

Summary:A variable in a PL/SQL block can have only one data type and can store a single value. However, there are many scenarios when the developer needs to store more than one value inside a single variable or even an entire row that comes from a table. For these situations the Oracle provide composite datatypes such as PL/SQL records and PL/SQL collections. This video explains how to use the TYPE command to create records that store multiple fields. Also, the video explain and show examples of how to create an INDEX BY TABLE which is very similar to the concept of arrays in a programming language. Then the video shows how to create those composite datatypes, how to store data from the tables on those variables and how to create a loop to perform a row-by-row type of processing with the composite data types.