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.

Can we interchange parameters in procedure while calling

1 Answers   TCS,

---

Write a program that shows the usage of while loop to calculate the average of user entered numbers and entry of more numbers are stopped by entering number 0?

0 Answers  

---

What does the hierarchical profiler does?

0 Answers  

---

Can we create table in function?

0 Answers  

---

Write a query to find five highest salaries from EMP table. (there is a column SALARY)

24 Answers   Cap Gemini, iNautix,

---

---

What is nested table in pl sql?

0 Answers  

---

what is the maximum length of a table name, database name, and fieldname in mysql? : Sql dba

0 Answers  

---

What is sql scripting?

0 Answers  

---

What will you get by the cursor attribute sql%found?

0 Answers  

---

How do you update f as m and m as f from the below table testtable?

0 Answers  

---

How do you take the union of two tables in sql?

0 Answers  

---

wtite down triggr not any entry on Sunday

2 Answers   NIT,

---