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


Please Help Members By Posting Answers For Below Questions

What does an inner join do?

562


Can we use loop in sql?

537


explain primary keys and auto increment fields in mysql : sql dba

536


How many scalar data types are supported in pl/sql?

526


What are the different types of triggers?

595






What is a stored procedure in sql with example?

606


Is sql scripting language?

528


How insert into statements in sql?

595


How to use distinct and count in sql query? Explain

614


What is an exception in pl/sql?

544


What is pl sql package?

600


what are ddl statements in mysql? : Sql dba

579


Is it possible to pass parameters to triggers?

575


What is over () in sql?

530


What is data modelling in sql?

524