What is the purpose of %type data type? Explain with example.

1.	What is the purpose of %type data type? Explain with example.
Answer» It assigns a variable the same data type used by the column, for which the variable is created. For example, dcode := dept.detpno%type; The variable dcode is created with the same data type as that of the deptno column of the dept table.

Answer»

It assigns a variable the same data type used by the column, for which the variable is created. For example,

dcode := dept.detpno%type;

The variable dcode is created with the same data type as that of the deptno column of the dept table.

Discussion