Records

Question 1

What is a record

Answer 1

Another type of data type which oracle allows to be defined as a placeholder.

Composite data types - means a combination of different scalar data types like (char, varch2, number etc.). Each scalar data type holds a value.

Contains all the contents of a row.

Question 2

What types of records can PLSQL handle

Answer 2

Table based
Cursor based
User-defined

Question 3

Table based record

Answer 3

%ROWTYPE attributes enables a programmer to create table-based and cursor-based records

Rec_emp emp%ROWTYPE;

Select * into rec_emp from emp where emp no = 12345

Question 4

Cursor Based record

Answer 4

Cursor cur_emp is
Select * from emp where emp_no = 12345;

Rec_emp cur_emp%ROWTYPE;

Question 5

User defined records

Answer 5

Can define records %rowtype attribute

Set up your own record