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.

i want to display 1 to 10 numbers using one select statement.

18 Answers   HCL, Nyros, Oracle,

---

What is pl/sql language case sensitive?

0 Answers  

---

What are pl/sql exceptions? Tell me any three.

1 Answers  

---

how to drop an existing table in mysql? : Sql dba

0 Answers  

---

Difference between global and parameter variables?

0 Answers   TCS,

---

what are the methods using performance tunning in sql and pl/sql

2 Answers  

---

Is sql the best database?

0 Answers  

---

how can we take a backup of a mysql table and how can we restore it. ? : Sql dba

0 Answers  

---

what is a cursor

9 Answers   IBM, TCS, Wipro,

---

What are the types of variable use in pl sql?

0 Answers  

---

Is sql free?

0 Answers  

---

What are views in sql?

0 Answers  

---