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.

difference between pl/sql table and normal pl/sql table

2 Answers  

---

How to access the current value and next value from a sequence?

6 Answers  

---

What are operators available in sql?

0 Answers  

---

A table was given with 3 columns like Manager id,Manager Name and Employee name. Question was to create hierarchy.

2 Answers   TCS,

---

Types of joins ?

11 Answers   Polaris, TCS,

---

how to present a past time in hours, minutes and seconds? : Sql dba

0 Answers  

---

How do you update sql?

0 Answers  

---

What is a table in a database?

0 Answers  

---

How can one get sql*loader to commit only at the end of the load file? : aql loader

0 Answers  

---

Write a pl/sql script to display the following series of numbers: 99,96,93……9,6,3?

1 Answers  

---

Whis is not false in primary key?

0 Answers   Fintellix,

---

How can you know that statistics should be updated?

0 Answers  

---