Interested to Buy Any Domain ? << Click Here >> for more details...
what are %TYPE and %ROWTYPE? what is the difference?
- 7 Answers
- 49247 Views
- ICICI, Saama Tech, Sail, I also Faced
- E-Mail Answers
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 is PL/SQL Records?
How does cross join work?
What is dml statement?
Does truncate remove indexes?
Is sql port 1433 encrypted?
What does the hierarchical profiler does?
what is csv? : Sql dba
Can cursors be part of a trigger body?
what are the type of locks ? : Sql dba
How exception handling is done in advance pl/sql?
Can we use ddl commands in pl sql?
What is a heap in sql?
what are different types of keys in sql?
What is difference between table and view?
what is data control language? : Sql dba
