What Is The Purpose Of %rowtype Data Type? Explain With Example.

1.	What Is The Purpose Of %rowtype Data Type? Explain With Example.
Answer» It DECLARES a composed variable that is EQUIVALENT to the row of a table. After the variable is created, the FIELDS of the table can be ACCESSED, using the name of this variable. For example emptype := emp%rowtype; name := emptype.empname; It declares a composed variable that is equivalent to the row of a table. After the variable is created, the fields of the table can be accessed, using the name of this variable. For example emptype := emp%rowtype; name := emptype.empname;

Answer»

It DECLARES a composed variable that is EQUIVALENT to the row of a table. After the variable is created, the FIELDS of the table can be ACCESSED, using the name of this variable.
For example
emptype := emp%rowtype;
name := emptype.empname;

It declares a composed variable that is equivalent to the row of a table. After the variable is created, the fields of the table can be accessed, using the name of this variable.
For example
emptype := emp%rowtype;
name := emptype.empname;

Discussion

No Comment Found

Related InterviewSolutions

What Are The Three Basic Sections Of A Pl/sql Block?
State Some Features Or Programming Constructs Supported By Pl/sql.
Name Few Schema Objects That Can Be Created Using Pl/sql?
State Few Notable Characteristics Of Pl/sql.
What Does The Colon Sign (: ) Implies In The Following Statement? :deficit := Balance – Loan;
What Is The Purpose Of %type Data Type? Explain With Example.
What Is The Purpose Of %rowtype Data Type? Explain With Example.
What Is A Pl/sql Package?
What Are The Pl/sql Cursors?
What Is Returned By The Cursor Attribute Sql%rowcount?

What Is The Purpose Of %rowtype Data Type? Explain With Example.

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment