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 coalesce in sql?

0 Answers  

---

Is grant a ddl statement?

0 Answers  

---

How many scalar data types are supported in pl/sql?

0 Answers  

---

What are the different ways to optimize a sql query?

0 Answers  

---

Why do we use sql constraints? Which constraints we can use while creating database in sql?

0 Answers  

---

Is left join inner or outer by default?

0 Answers  

---

how to remove records from table? no name 1 a 2 b 1 a 2 b 3 c

8 Answers   Oracle,

---

What is the difference between CHAR and VARCHAR2? If VARCHAR2 serves the uses of CHAR why CHAR is still used and not been discarded yet?

9 Answers   Oracle,

---

what are integrity rules?

0 Answers  

---

what is text? : Sql dba

0 Answers  

---

What do you mean by dbms? What are its different types?

0 Answers  

---

What does count (*) do in sql?

0 Answers  

---