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 order siblings in oracle hierarchy queries?
What is cursor and its types?
Under what condition it is possible to have a page level lock and row lock at the same time for a query? : Transact sql
How can we debug in PL/SQL?
what is online transaction processing (oltp)? : Sql dba
What is the execution plan in sql?
what are myisam tables? : Sql dba
What kind of join is join?
How does rowid help in running a query faster?
how to include comments in sql statements? : Sql dba
What do you mean by stored procedures?
How exception is different from error?
What is pl sql in dbms?
what are the join types in tsql? : Transact sql
What if we write return in procedure?