Answer / swapna

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

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.

Answer / sunil

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

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.

Answer / savani rakshit

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

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.

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 postgresql a nosql database?

0 Answers  

Can a view be updated/inserted/deleted?If Yes under what conditions?

3 Answers  

What is primary key and unique key?

0 Answers  

I have a tablle like this: cust acc ----------- a 1 b 2 b 3 c 4 c 5 c 6 I Want below o/p: cust acc --------------- a 1 b 2|3 c 4|5|6 Please any one can you have any ideas share me. I have urgent requirement.

7 Answers   MTS,

what is “go” in t-sql? : Transact sql

0 Answers  

What do you understand by pl/sql records?

0 Answers  

How will we see framework of a table?

2 Answers   Accenture,

How do I copy a table in sql?

0 Answers  

What is sqlca in db2?

0 Answers  

Is there a 64 bit version of ssms?

0 Answers  

Can %notfound return null after a fetch?

0 Answers  

Are subqueries faster than joins?

0 Answers