Differentiate between %type and %rowtype attribute in
Oracle PL/AQL programming ?
- 7 Answers
- 18237 Views
- PreVator, I also Faced
- E-Mail Answers
Answer Posted / kirankumar.vangeti
%ROWTYPE is used to declare a record with the same types as
found in the specified database table, view or cursor
%TYPE is used to declare a field with the same type as that
of a specified table's column.
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
What is sql and how does it work?
how to calculate the difference between two dates? : Sql dba
What is execution plan in sql?
What is not equal in sql?
What is pl sql architecture?
what are all the common sql function? : Sql dba
Why left join is used in sql?
Differentiate between % rowtype and type record.
In a distributed database system, can we execute two queries simultaneously?
What is the primary use of normalization?
Why do we use partitions in sql?
What is pls integer?
what are the different tables present in mysql, which type of table is generated when we are creating a table in the following syntax: create table employee (eno int(2),ename varchar(10)) ? : Sql dba
How to write a single statement that concatenates the words ?hello? And ?world? And assign it in a variable named greeting?
Inline the values in PL/SQL, what does it mean.?
