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 join types in tsql? : Transact sql

755

---

How to convert comma separated string to array in pl/sql?

812

---

discuss about myisam index statistics collection. : Sql dba

695

---

What does count (*) mean?

682

---

Can you have more than one trigger on a table?

709

---

---

can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible? : Sql dba

771

---

how to convert character strings to numeric values? : Sql dba

771

---

What is Collation Sensitivity ? What are the various type ?

697

---

Which are sql * plus commands?

714

---

what is heap table? : Sql dba

801

---

Explain what is a view?

797

---

How many unique keys can a table have?

740

---

what is table? : Sql dba

763

---

What are the 3 types of behavioral triggers?

943

---

how to fetch alternate records from a table? : Sql dba

825

---