Answer Posted / p.rajasekar

%RowType
1.%ROWTYPE is used to declare a record with the same types
as found in the specified database table, view or cursor.
Example:
DECLARE
v_EmpRecord emp%ROWTYPE;
2.Whenever we change the datatype in database,No need to
change in Application code using the %RowType, because
It will automatically take care of the dtatype change
%Type
1.%TYPE is used to declare a field with the same type as
that of a specified table's column. Example:
DECLARE
v_EmpNo emp.empno%TYPE;
2.Whenever we change the datatype in database,No need to
change in Application code using the %RowType, because
It will automatically take care of the dtatype change

Explain 3 basic parts of a trigger.

1323

---

How do I find duplicates in sql?

929

---

Is pl sql still used?

975

---

Is pl sql better than sql?

1033

---

What is a file delimiter?

1094

---

What is mutating error in pl sql?

1016

---

Why do we use procedures in sql?

1083

---

What are literals in sql server?

1170

---

Why is sharding used?

995

---

What is record variable?

989

---

Is it possible to sort a column using a column alias?

1047

---

mention if it is possible to import data directly from t-sql commands without using sql server integration services? If yes, what are the commands? : Transact sql

1041

---

Which function is used to return remainder in a division operator in sql?

1140

---

define data blocks ? : Sql dba

996

---

What is sql select statement?

1031

---