what are %TYPE and %ROWTYPE? what is the difference?
Answer Posted / hjhjnj
Column Type (i.e. %TYPE) is used to declare a field with the same type as that of a specified table’s column
Row type (i.e. %ROWTYPE) is used to declare a record with the same types as found in the specified database table, view or cursor
Is This Answer Correct ? | 7 Yes | 1 No |
Post New Answer View All Answers
State some properties of relational databases?
How do I run sql profiler?
Is left join same as join?
Define overloaded procedure?
How many times can we commit in a loop?
What does fetching a cursor do?
What is sql query limit?
what is a foreign key ? : Sql dba
What is a primary key example?
What is write ahead logging in sql server?
Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me
ERROR:Insert or update on table"accnt" violates foreign key constraints "acct_to_curr_symbol" DETAILS:KEY(accnt_curr_id)(-2)is not present in the table "curr_symbol" ......solve The Problem..
What are types of joins?
What are different types of keys?
What is user in sql?