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.

Why primary key is required?

571

---

What is plpgsql language?

539

---

What is trigger in sql?

588

---

What is pessimistic concurrency control? : Transact sql

595

---

What do you think about pl/sql?

539

---

---

Can I join the same table twice?

535

---

what is self join and what is the requirement of self join? : Sql dba

694

---

what is schema? : Sql dba

572

---

What company owns postgresql?

570

---

What is sqlerrd?

540

---

How do you optimize a query?

545

---

what are the different functions in sorting an array? : Sql dba

591

---

Does truncate require commit?

555

---

how to dump a table to a file with 'mysqldump'? : Sql dba

563

---

What is a sql*loader control file?

624

---