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.

Explain the uses of control file.

0 Answers  

What is a sql profiler?

0 Answers  

IN A TABLE HAVE ONE COLUMN PRIMARY KEY..IT WILL NOT ALLOWS NULL VALUES AND DUPLICATE VALUES..INSTEAD OF PRIMARY KEY WHY CANT WE USE UNIQUE AND NOT NULL.THESE TWO ALSO DOESNT ACCEPT NULL VALUES IN NOT NULL AND UNIQUE DOESNT ACCEPT DUPLICATE VALUES? SO WHAT IS THE DIFEERENCE BETWEEN(UNIQUE,NOT NULL) AND PRIMARY KEY??????

8 Answers   rsystems,

what is Difference between Having and Where clause?

5 Answers   IBM,

In testing where do we use sql language and how it helps in testing?

2 Answers  

What is sqlerrd?

0 Answers  

Is hadoop a nosql?

0 Answers  

How can I get the number of records affected by a stored procedure?

0 Answers  

how u can find the n row from a table?

19 Answers   Tech Mahindra,

What does the hierarchical profiler does?

0 Answers  

What trigger means?

0 Answers  

In packages the source code is compiled into p code ? how do we describe the p code

3 Answers