what are %TYPE and %ROWTYPE? what is the difference?
Answer Posted / debasis dutta
%type is associates a variable with column data of a table..
ex..
empno emp_mast.eno%type;
%rowtype is associates a variable with whole table data of
a database..
ex
tot emp_mast%rowtype;
Is This Answer Correct ? | 13 Yes | 3 No |
Post New Answer View All Answers
What are sql indexes?
Do we need to rebuild index after truncate?
Is oracel sql developer written in java?
How many types of literals are available in pl sql?
what is clause? : Sql dba
How does sql*loader handles newline characters in a record? : aql loader
Can we commit in trigger?
What are different categories of sql commands?
What is a schema sql?
Why we use join in sql?
What is difference between group by and partition by?
What is foreign key in sql with example?
How do I find duplicates in two columns?
What are triggers and its uses?
What schema means?