|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.|
Declaring column/field with defined data-type, and which should be the same data type, used in the source (table).
Declaring fields to %type
|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.
|Passing Vales to a field:
emp_info.empno:= value like 7521;