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
what are the system privileges that are required by a schema owner (user) to create a trigger on a table?
Define the select into statement.
What are the basic techniques of indexing?
How do I audit the sql sent to the server?
What is the execution plan in sql?
What is the difference between stored procedure and view?
differentiate between float and double. : Sql dba
What is the primary use of normalization?
What is the difference between the repeatable read and serializable isolation levels? : Transact sql
what happens if you no create privilege in a database? : Sql dba
How many types of literals are available in pl sql?
Which data dictionary views have the information on the triggers that are available in the database?
Is sql sequential or random?
What are sql functions? Describe the different types of sql functions?
Are views faster than queries?