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.

How do I debug a stored procedure?

0 Answers  

---

what are the different types of joins?

4 Answers   Choice Solutions,

---

What is integrity constraints?

5 Answers   Ramco, Satyam,

---

What is sharding in sql?

0 Answers  

---

Give the structure of the procedure ?

1 Answers  

---

---

How do you rename a table in sql?

0 Answers  

---

what is top in tsql? : Transact sql

0 Answers  

---

How to run sql statements with oracle sql developer?

0 Answers  

---

How can u find column name from a table which have max value in a row.( not max value)

5 Answers  

---

Does sql*plus also have a pl/sql engine?

0 Answers  

---

what are different types of collation sensitivity? : Sql dba

0 Answers  

---

What is the default value of CHAR type?

3 Answers   Bosch,

---