Answer Posted / suresh kumar somayajula

%ROWTYPE is to be used whenever query returns a row of
Database Table.

RECORD TYPE is to be used whenever query returns a columns
of different Tables.

Eg : TYPE <TYPE_NAME> IS RECORD (Name Varchar2,
No Number);

Thank you,
Suresh

What are the steps for performance tuning.

847

---

Explain correlated query work?

601

---

What is data definition language?

626

---

What does (+) mean in sql joins?

528

---

What is mutating table error?

666

---

---

What does partition by mean in sql?

515

---

how to enter characters as hex numbers? : Sql dba

574

---

What is the difference between cluster and non-cluster index?

624

---

How to call shell script from pl sql procedure?

629

---

What is latest version of sql?

530

---

How do you copy a table in sql?

564

---

What is query optimization in sql?

551

---

How many commands are there in sql?

553

---

Why procedure is used in sql?

537

---

What type of join is sql join?

533

---