Answer Posted / madhuri

%type and %rowtype provides data independence,reduces
maintainance cost and allows programs to adapt as the
database changes due to new business requirements.

%rowtype is used to declare a record with the same types as
found in the specified database table,view or a cursor.

%type is used to declare a field with the same type as found
in the specified table's column.

How do sql databases work?

998

---

How many types of keys are there in sql?

1038

---

how to select unique records from a table? : Sql dba

1112

---

What are the uses of merge?

1167

---

Which join is default?

953

---

what is “go” in t-sql? : Transact sql

1104

---

Will truncate release space?

950

---

What are procedures used for?

985

---

Does sql profiler affect performance?

992

---

what is a primary key? : Sql dba

1033

---

What is rtm stands for?

1098

---

How can I see all tables in sql?

1077

---

Why do you partition data?

1020

---

what is self-join? : Sql dba

1163

---

Is pl sql better than sql?

1033

---