What are % TYPE and % ROWTYPE ? What are the advantages of
using these over datatypes?
Answer Posted / swapna
"% Type "is used to extract definition of the column of a
table.
"%Rowtype" is used to extract definition of the columns of
all columns.
Is This Answer Correct ? | 6 Yes | 1 No |
Post New Answer View All Answers
What does an inner join do?
Can we use loop in sql?
explain primary keys and auto increment fields in mysql : sql dba
How many scalar data types are supported in pl/sql?
What are the different types of triggers?
What is a stored procedure in sql with example?
Is sql scripting language?
How insert into statements in sql?
How to use distinct and count in sql query? Explain
What is an exception in pl/sql?
What is pl sql package?
what are ddl statements in mysql? : Sql dba
Is it possible to pass parameters to triggers?
What is over () in sql?
What is data modelling in sql?