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 to Update table Sales_summary with max(sales) data from table sales_dataTable 1. sales_data table Table 2. Sales_summary Region sales Region sales N 500 N 0 N 800 W 0 N 600 W 899 W 458 W 900 I want the Sales_summary After Update like this Region Sales N 800 W 900

8 Answers  

---

What is trigger with example?

0 Answers  

---

Can a varchar be a primary key?

0 Answers  

---

What is a full join?

0 Answers  

---

what are the advantages a stored procedure? : Sql dba

0 Answers  

---

What is normalization? dec 2009

3 Answers   Cognizant,

---

how to write date and time literals? : Sql dba

0 Answers  

---

What is on delete set null?

0 Answers  

---

Does SQL*Plus contains pl/sql Engine?

1 Answers   TCS,

---

What is the maximum number of columns in sql table?

0 Answers  

---

What is the starting oracle error number?

0 Answers  

---

How to return an array from java to pl/sql?

0 Answers  

---