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.

what is the different between unique+not null & primary key,

4 Answers  

---

What is the different between Stored Procedure and Procedure?

7 Answers   Informatica, MIS,

---

how u can find the n row from a table?

19 Answers   Tech Mahindra,

---

how to delete duplicate rows from a join tables(I have three tables on that join) how do you know which join is need to be used? The select statement I have is: SELECT gc_skill_type.skill_type, gc_area_tec.area, gc_technology.technology, gc_technology.id_technology, gc_area_tec.id_area_tec FROM gc_skill_type, gc_area_tec, gc_technology WHERE gc_area_tec.id_skill_type (+) = gc_skill_type.id_skill_type AND gc_technology.id_area_tec (+) = gc_area_tec.id_area_tec order by gc_skill_type.skill_type asc, gc_area_tec.area asc, gc_technology.technology asc

1 Answers   IAS,

---

Explain the insert into statements in sql?

0 Answers  

---

---

Enlist some predefined exceptions?

0 Answers  

---

what is auto increment? : Sql dba

0 Answers  

---

Is there a 64 bit version of ssms?

0 Answers  

---

Is sqlite thread safe?

0 Answers  

---

what is the forward decleration in packages?

1 Answers  

---

what is the bond code in materialized view?

0 Answers  

---

What are the different schemas objects that can be created using pl/sql?

0 Answers  

---