Differentiate between %type and %rowtype attribute in
Oracle PL/AQL programming ?
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 are the types of sql commands?
how can you create an empty table from an existing table? : Sql dba
What is execution plan in sql?
Explain the difference in execution of triggers and stored procedures?
What is trigger in flip flop?
What is the cause of mutating table error and how can we solve it?
What is the order of sql select?
What happens when a trigger is associated to a view?
What are types of indexes in sql?
how would you get the current date in mysql? : Sql dba
Can a foreign key have a different name?
How do I run a sql trace?
What is the limitation on the block size of pl/sql?
When is the explicit cursor used ?
Is merge a dml statement?