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
What are literals in sql server?
What are the different ways to optimize a sql query?
What is nosql vs sql?
What is trigger types in sql?
What are the advantages of sql? Explain
Enlist some predefined exceptions?
What is a call statement? Explain with an example.
what are null values? : Sql dba
How can you create an empty table from an existing table?
what is normalization? : Sql dba
Can dml statements be used in pl/sql?
what are the differences between char and varchar? : Sql dba
what is schema? : Sql dba
What is mutating trigger?
Explain alias in sql?