what are %TYPE and %ROWTYPE? what is the difference?
Answer Posted / hjhjnj
Column Type (i.e. %TYPE) is used to declare a field with the same type as that of a specified table’s column
Row type (i.e. %ROWTYPE) is used to declare a record with the same types as found in the specified database table, view or cursor
| Is This Answer Correct ? | 7 Yes | 1 No |
Post New Answer View All Answers
How do I remove all records from a table?
Can we want to pass a parameter payroll_id to this external pl/sql function, how do we do it?
How do I run a program in pl sql?
what is denormalization. : Sql dba
Is primary key always clustered index?
What is denormalization in a database?
Why do we use joins in sql?
How many joins can you have in sql?
What is synonyms?
what are the differences between char and varchar? : Sql dba
What are types of exception?
How do I run a query in pl sql developer?
Do foreign keys improve performance?
How to get help at the sql prompt?
how can we know the number of days between two given dates using mysql? : Sql dba