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;

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;

Discussion

No Comment Found

Related InterviewSolutions

Say True or False. If False, explain why.The %ROWCOUNT attribute returns the total number of rows returned by the FETCH command.
Say True or False. If False, explain why.The %NOTFOUND attribute returns true when the cursor is not created explicitly.
What is the difference between implicit and explicit cursors?
Which command is used to delete a package?
Say True or False. If False, explain why.PL/SQL allows subprogram overloading feature within a package.
How do you refer to the types, objects and subprograms declared within a package?
Which command(s) are used for creating PL/SQL packages?
PL/SQL packages usually have two parts. What are these two parts?
What are the steps that need to be performed to use an explicit cursor? Discuss briefly.
What do you understand by explicit cursors?

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

For example

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment