Answer Posted / debasis dutta

%type is associates a variable with column data of a table..
ex..
empno emp_mast.eno%type;
%rowtype is associates a variable with whole table data of
a database..
ex
tot emp_mast%rowtype;

What are the different type of joins in sql?

953

---

What are all different types of collation sensitivity?

1031

---

How does rowid help in running a query faster?

1416

---

Which constraints we can use while creating database in sql?

1079

---

How do I turn a list into a table?

958

---

What are different methods to trace the pl/sql code?

1117

---

Why use subqueries instead of joins?

1078

---

how can we take a backup of a mysql table and how can we restore it. ? : Sql dba

971

---

what is datawarehouse? : Sql dba

1008

---

how to escape special characters in sql statements? : Sql dba

1035

---

Explain what is an index?

1054

---

What is the difference between function, procedure and package in pl/sql?

1253

---

How to handle bulk data?

1308

---

Which data dictionary views have the information on the triggers that are available in the database?

1234

---

Explain mutating table error.

1200

---