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 are inner outer left and right joins in sql?

1006

---

what are the types of subquery? : Sql dba

1096

---

Which table is left in join?

970

---

Which constraints we can use while creating database in sql?

1066

---

Which is better trigger or stored procedure?

941

---

Can a composite key be null?

970

---

What is auto increment in sql?

1112

---

Can we join tables without foreign key?

955

---

What is the largest value that can be stored in a byte data field?

1008

---

What does the argument [or replace] do?

1071

---

How can I see all tables in sql?

1062

---

what is transaction? : Sql dba

1003

---

What is pl/sql language case sensitive?

1107

---

what is offset-fetch filter in tsql? : Transact sql

939

---

What do you mean by field in sql?

1075

---