RecordDataType_Info1.htm |
In Oracle Table (not database table) and Records are composite data types, which means it is a combination of different scalar data types like char, varchar, number etc. Each scalar data types in the record holds a value of a designated field/column. |
Demo:
Declaring column/field with defined data-type, and which should be the same data type, used in the source (table). DECLARE Declaring fields to %type DECLARE |
SQL Syntax in the above scenario SELECT col1, col2 |
In case we need to use all the fields from the source table, we may
declare the variable as shown below.
DECLARE |
Passing Vales to a field: emp_info.empno:= value like 7521; |