what are %TYPE and %ROWTYPE? what is the difference?

Answer Posted / lakshminarayana reddy

%Type:- used to variable according to column sturcture
%Rowtype:- used to variable accordin to compleat record
sturcture.

Is This Answer Correct ?    35 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do I write a sql query in pgadmin 4?

558


What is information schema in sql?

582


how to get a list of indexes of an existing table? : Sql dba

518


How to avoid using cursors? What to use instead of cursor and in what cases to do so?

607


What type of database is cloud sql?

579






What is the primary key?

538


What is a table partition?

597


What are dml commands?

529


What is the need of merge statement?

554


what's the difference between a primary key and a unique key? : Sql dba

511


what is sql profiler? : Sql dba

592


How do I audit the sql sent to the server?

526


What are all the ddl commands?

631


What are the advantages of sql? Explain

650


What is composite primary key in sql?

524