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 |
Temporary table vs Table variable in sql server?
Is sqlite good enough for production?
Types of cursors and explanation each of them ?
How to revise and re-run the last sql command?
How to run sql functions in pl/sql?
Can we group by two columns in sql?
what is sp_pkeys? : Transact sql
what is 'mysqlimport'? : Sql dba
What is procedure in pl sql?
is it necessary to write group by and order by clause together
Is inner join same as self join?
Where is all the data on the internet stored?
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)