What is rowtype?



What is rowtype?..

Answer / Babita Baghel

ROWTYPE in PL/SQL is a user-defined data type that defines the structure of a single row in a table. It is used to declare a variable whose value matches the columns and their order in a specific table. ROWTYPE is useful for working with rows from multiple tables or views, especially when using anonymous blocks.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

Temporary table vs Table variable in sql server?

0 Answers   Wipro,


Is sqlite good enough for production?

1 Answers  


Types of cursors and explanation each of them ?

4 Answers   DELL,


How to revise and re-run the last sql command?

1 Answers  


How to run sql functions in pl/sql?

1 Answers  


Can we group by two columns in sql?

1 Answers  


what is sp_pkeys? : Transact sql

1 Answers  


what is 'mysqlimport'? : Sql dba

1 Answers  


What is procedure in pl sql?

1 Answers  


is it necessary to write group by and order by clause together

3 Answers   HCL, Wipro,


Is inner join same as self join?

1 Answers  


Where is all the data on the internet stored?

1 Answers  


Categories