What are % TYPE and % ROWTYPE ? What are the advantages of
using these over datatypes?
Answer Posted / manoj
"%Type" :-It reffer one datatype which take
data type of a column in table,
Previously defined variable(Anchor type)
"%Rowtype" :-Have all type Refered May be for
Table,
Cursor,
Ref Cursor,
curor variable etc.
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
how to add a new column to an existing table in mysql? : Sql dba
who introduced sql?
Is there a 64 bit version of ssms?
What is function and procedure in pl sql?
How do you optimize a stored procedure query?
What is difference between sql and excel?
What is the usage of when clause in trigger?
what is denormalization. : Sql dba
Compare sql & pl/sql
Explain what is rdbms?
What is a file delimiter?
What are schema-level triggers?
What is varchar used for?
what is the difference between rownum pseudo column and row_number() function? : Sql dba
What is a mutating table and a constraining table?