How do you declare a PL/SQL record? Explain with an example.
What will be an ideal response?
You create a RECORD type first and then declare a record with that RECORD type.
For example,
TYPE peson_rectype IS RECORD
(p_lastname VARCHAR2 (15),
p_firstname VARCHAR2 (15),
p_gender VARCHAR2;
person_rec person_rectype;
Computer Science & Information Technology
You might also like to view...
Methods are also called modules.
Answer the following statement true (T) or false (F)
Computer Science & Information Technology
Crowdsourcing is based on contributions from groups of individuals, but it differs from collaborative work.
Answer the following statement true (T) or false (F)
Computer Science & Information Technology
____ is the formal term for combining two or more columns to form a primary key.
A. Qualification B. Joining C. Normalization D. Concatenation
Computer Science & Information Technology
A(n) ____ is a property of an entity.
A. record B. tuple C. entity D. attribute
Computer Science & Information Technology