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.

What is sqlca in powerbuilder?

1065

---

What is sql partition function?

1287

---

How do you pronounce sql?

1058

---

Why we use join in sql?

1022

---

What is %type in pl sql?

1007

---

What is a relationship and what are they?

1225

---

How do I start pl sql?

995

---

What is varchar data type in sql?

1136

---

How do I count rows in sql?

1048

---

What is not equal in sql?

1190

---

What has stored procedures in sql?

1098

---

how to extract a unit value from a date and time? : Sql dba

1035

---

Does a primary key have to be a number?

1003

---

how to increment dates by 1 in mysql? : Sql dba

1028

---

How do you change a value in sql?

1064

---