Interested to Buy Any Domain ? << Click Here >> for more details...
what are %TYPE and %ROWTYPE? what is the difference?
- 7 Answers
- 49245 Views
- ICICI, Saama Tech, Sail, I also Faced
- E-Mail Answers
Answer Posted / pavan_1981
these two are used with cursors to store the returing
result from the query.
%TYPE:a variable is declared to be of %type when we are
referring to a single specific column.when we declare a
variable to be of %type of a column,the variable datatype
becomes the datatype of that column..here it can only one
datatype that of the column.
%ROWTYPE:same as above but takes a single row at a time and
can accomidate multiple datatypes.it can store whole row at
a time containing different datatypes.
| Is This Answer Correct ? | 83 Yes | 2 No |
Post New Answer View All Answers
Where not exists in sql?
What is the purpose of the primary key?
how many values can the set function of mysql take? : Sql dba
What does the file extension accdb stand for?
How many sectors are in a partition?
What is the difference between cluster and non-cluster index?
How is a process of pl/sql compiled?
Which command is used to call a stored procedure?
What is foreign key in sql with example?
what is the command line end user interface - mysql? : Sql dba
What are different joins used in sql?
What sql does db2 use?
What is right join sql?
How many row comparison operators are used while working with a subquery?
What are pl sql data types?
