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 is nested table in pl sql?

551

---

what is union? : Sql dba

580

---

what is the difference between myisam static and myisam dynamic? : Sql dba

581

---

Can a table have no primary key?

551

---

What is full join?

525

---

---

What are data types in pl sql?

559

---

Can we use insert statement in function?

514

---

What does pragma mean?

504

---

what is the use of friend function? : Sql dba

539

---

What is use of package in pl sql?

530

---

what are different types of collation sensitivity? : Sql dba

552

---

What is left join example?

499

---

How to rename a column in the output of sql query?

533

---

What are different types of keys?

519

---

what are the nonstandard string types? : Sql dba

601

---