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;

Do we need to rebuild index after truncate?

529

---

What is the difference between instead of trigger and after trigger?

514

---

how many sql ddl commands are supported by 'mysql'? : Sql dba

528

---

What makes a good primary key?

524

---

What are field types?

539

---

---

what are string data types? : Sql dba

514

---

How to Declare Fixed Length String Value In PL SQL

668

---

Difference between table function and pipelined function?

588

---

Can you have more than one trigger on a table?

532

---

Can we use loop in sql?

537

---

How can we link a sql database to an existing android app?

550

---

How is use pl and sql?

556

---

What is sql performance tuning?

497

---

Why do we need unique key in a table?

528

---

what are the features and advantages of object-oriented programming? : Sql dba

549

---