Differentiate between %type and %rowtype attribute in
Oracle PL/AQL programming ?

Answers were Sorted based on User's Feedback



Differentiate between %type and %rowtype attribute in Oracle PL/AQL programming ?..

Answer / swapna

ROWTYPE is declared at the record level and the TYPE is
declared for the coloumn level.

Is This Answer Correct ?    24 Yes 1 No

Differentiate between %type and %rowtype attribute in Oracle PL/AQL programming ?..

Answer / madhuri

%type and %rowtype provides data independence,reduces
maintainance cost and allows programs to adapt as the
database changes due to new business requirements.

%rowtype is used to declare a record with the same types as
found in the specified database table,view or a cursor.

%type is used to declare a field with the same type as found
in the specified table's column.

Is This Answer Correct ?    14 Yes 0 No

Differentiate between %type and %rowtype attribute in Oracle PL/AQL programming ?..

Answer / sunil

ROWTYPE is declared at the record level and the TYPE is
declared for the coloumn level.

Is This Answer Correct ?    8 Yes 0 No

Differentiate between %type and %rowtype attribute in Oracle PL/AQL programming ?..

Answer / suresh somayajula

%Type is used to change the size of any datatype but only
for one record.

%Rowtype is used to declare a recoed that represents a
particular row of a table.

Is This Answer Correct ?    9 Yes 4 No

Differentiate between %type and %rowtype attribute in Oracle PL/AQL programming ?..

Answer / savani rakshit

%row type is used to focus on particular record.
row%type is used to focus on single row

Is This Answer Correct ?    6 Yes 1 No

Differentiate between %type and %rowtype attribute in Oracle PL/AQL programming ?..

Answer / kirankumar.vangeti

%ROWTYPE is used to declare a record with the same types as
found in the specified database table, view or cursor

%TYPE is used to declare a field with the same type as that
of a specified table's column.

Is This Answer Correct ?    4 Yes 1 No

Differentiate between %type and %rowtype attribute in Oracle PL/AQL programming ?..

Answer / ajeet

%type is use to declare the data type of single column and % row type is use for more then one table ,in simple words with the help of % row type we can easily declare the data type of any table in database.

Is This Answer Correct ?    2 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

what is sp_pkeys? : Transact sql

0 Answers  


Define overloaded procedure?

0 Answers  


What is a schema? How is it useful in sql servers?

0 Answers  


Can we use join in subquery?

0 Answers  


What is Pragma EXECPTION_INIT ? Explain the usage ?

2 Answers  






what is oracle sql,pl/sql with interfaces

2 Answers   TCS,


In pl/sql, what is bulk binding, and when/how would it help performance?

0 Answers  


List the differences between plsql - function & procedures

2 Answers   TCS, Verizon,


What are tuples in sql?

0 Answers  


What are the types of subqueries?

0 Answers  


Can we create table inside stored procedure?

0 Answers  


how to rename an existing table in mysql? : Sql dba

0 Answers  


Categories