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 can I create a table from another table without copying any values from the old table?

8 Answers  

---

Where the Pre_defined_exceptions are stored ?

2 Answers  

---

What is offset and limit in sql?

0 Answers  

---

What is the difference between functions, procedures, and packages in pl/sql?

0 Answers  

---

What is the use of & in pl sql?

0 Answers  

---

Can we insert delete data in view?

0 Answers  

---

what is an extent ? : Sql dba

0 Answers  

---

What is sql server and ase?

0 Answers  

---

i have xml source. xml source having lacks of records. i want extract/retrive xml source data using sql query. please tell me how to write query.

4 Answers   TCS,

---

Are null values same as that of zero or a blank space?

0 Answers  

---

what is uncommittable transactions? : Transact sql

0 Answers  

---

what is d diff between grant,commit,rollback n savepoint

1 Answers  

---