what are %TYPE and %ROWTYPE? what is the difference?
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
What is primary key and unique key?
What is right join sql?
Which sql statement is used to delete data from a database?
Which are the different character-manipulation functions in sql?
What is record type in pl sql?
What is the difference between sql and mysql?
what is an index? : Sql dba
mention if it is possible to import data directly from t-sql commands without using sql server integration services? If yes, what are the commands? : Transact sql
What is case function?
What is execution plan in sql?
Is sql similar to python?
What is ttitle and btitle?
What are the features of pl sql?
What is pl sql variable?
What is the clause we need to add in function body to return variable?