Differentiate between %type and %rowtype attribute in
Oracle PL/AQL programming ?
- 7 Answers
- 18253 Views
- PreVator, I also Faced
- E-Mail Answers
Answer Posted / ajeet
%type is use to declare the data type of single column and % row type is use for more then one table ,in simple words with the help of % row type we can easily declare the data type of any table in database.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is write ahead logging in sql server?
Is foreign key mandatory?
Write the command to remove all players named sachin from the players table.
What is recursive join in sql?
What are the usages of sql?
what is 'mysqlshow'? : Sql dba
what is csv? : Sql dba
What is sql clause?
How many postgresql users are there, worldwide?
how can we optimize or increase the speed of a mysql select query? : Sql dba
What is full form of rtm?
What is an index? What are the types of indexes? How many clustered indexes can be created on a table?
How can you view the errors encountered in a trigger?
If a cursor is open, how can we find in a pl/sql block?
what are the 'mysql' command line options? : Sql dba
