Sign Up Login


  1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

What is difference between % ROWTYPE and TYPE RECORD ?

Question Posted / guest

Answers were Sorted based on User's Feedback



What is difference between % ROWTYPE and TYPE RECORD ?..

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

Is This Answer Correct ?    15 Yes 4 No

What is difference between % ROWTYPE and TYPE RECORD ?..

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.

Is This Answer Correct ?    9 Yes 2 No

Post New Answer

More SQL PLSQL Interview Questions

Write a query to genarate target column.Please answer me. Advance Thanks. Src Tgt Q10 Quarter to 2010 Q90 Quarter to 1990 Q80 Quarter to 1980 Q74 Quarter to 1974

5 Answers   Infosys,

in table there r so many rows write a query which two rows r updated last two day befor?

3 Answers   Exilant,

how to do backup entire database? : Transact sql

0 Answers  

Is progress software supports to ( pl/sql )?

0 Answers  

What is %rowtype in pl sql?

0 Answers  




what is meant by forward declaration in functions?

4 Answers   TCS,

How can a pl sql block be executed?

0 Answers  

Explian rowid, rownum?

0 Answers  

What are different types of functions in sql?

0 Answers  

Define implicit and explicit cursors.

0 Answers  

What is before and after trigger?

0 Answers  

how to shutdown mysql server? : Sql dba

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories