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
How do I write a sql query in pgadmin 4?
What is information schema in sql?
how to get a list of indexes of an existing table? : Sql dba
How to avoid using cursors? What to use instead of cursor and in what cases to do so?
What type of database is cloud sql?
What is the primary key?
What is a table partition?
What are dml commands?
What is the need of merge statement?
what's the difference between a primary key and a unique key? : Sql dba
what is sql profiler? : Sql dba
How do I audit the sql sent to the server?
What are all the ddl commands?
What are the advantages of sql? Explain
What is composite primary key in sql?