Answer / 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

Answer / sohail

The %ROWTYPE attribute provides a record type that
represents a row in a table.
Create Type is used to create a type with multiple
variables and is stored in the database.

Why cannot I use bind variables in ddl/scl statements in dynamic sql?

0 Answers  

---

why use cursors?

5 Answers   Oracle,

---

Define implicit and explicit cursors.

0 Answers  

---

Can I create table without primary key?

0 Answers  

---

How to run sql statements with oracle sql developer?

0 Answers  

---

What is compiled query?

0 Answers  

---

How can we debug in PL/SQL?

0 Answers  

---

What are Anti joins

1 Answers   IBM,

---

What is the difference between clustered and non-clustered index in sql?

0 Answers  

---

What is offset in sql query?

0 Answers  

---

How many aggregate functions are available there in sql?

0 Answers  

---

what is an index? : Sql dba

0 Answers  

---