What is difference between % ROWTYPE and TYPE RECORD ?

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

What is sql and explain its components?

799


Can a procedure in a package be overloaded?

754


How do you write an index?

703


what are properties of a transaction? : Sql dba

760


Can we use rowid as primary key?

735






Can a commit statement be executed as part of a trigger?

799


Explain how to use transactions efficiently : transact sql

718


What is native sql query?

736


What are different types of functions in sql?

723


What is trigger with example?

739


How many clustered indexes can you have?

726


What are the types of optimization?

688


Can %notfound return null after a fetch?

756


GLOBAL TEMPORARY TABLE over Views in advantages insolving mutating error?

2760


What is the difference between sql and isql*plus?

704