what are %TYPE and %ROWTYPE? what is the difference?




Answers were Sorted based on User's Feedback



what are %TYPE and %ROWTYPE? what is the difference? ..

Answer / pavan_1981

these two are used with cursors to store the returing
result from the query.
%TYPE:a variable is declared to be of %type when we are
referring to a single specific column.when we declare a
variable to be of %type of a column,the variable datatype
becomes the datatype of that column..here it can only one
datatype that of the column.

%ROWTYPE:same as above but takes a single row at a time and
can accomidate multiple datatypes.it can store whole row at
a time containing different datatypes.

Is This Answer Correct ?    82 Yes 2 No

what are %TYPE and %ROWTYPE? what is the difference? ..

Answer / lakshminarayana reddy

%Type:- used to variable according to column sturcture
%Rowtype:- used to variable accordin to compleat record
sturcture.

Is This Answer Correct ?    35 Yes 5 No

what are %TYPE and %ROWTYPE? what is the difference? ..

Answer / p.rajasekar

%RowType
1.%ROWTYPE is used to declare a record with the same types
as found in the specified database table, view or cursor.
Example:
DECLARE
v_EmpRecord emp%ROWTYPE;
2.Whenever we change the datatype in database,No need to
change in Application code using the %RowType, because
It will automatically take care of the dtatype change
%Type
1.%TYPE is used to declare a field with the same type as
that of a specified table's column. Example:
DECLARE
v_EmpNo emp.empno%TYPE;
2.Whenever we change the datatype in database,No need to
change in Application code using the %RowType, because
It will automatically take care of the dtatype change

Is This Answer Correct ?    25 Yes 5 No




what are %TYPE and %ROWTYPE? what is the difference? ..

Answer / debasis dutta

%type is associates a variable with column data of a table..
ex..
empno emp_mast.eno%type;
%rowtype is associates a variable with whole table data of
a database..
ex
tot emp_mast%rowtype;

Is This Answer Correct ?    13 Yes 3 No

what are %TYPE and %ROWTYPE? what is the difference? ..

Answer / srikanth

%type can hold one perticular variable
%rowtype decalre total row declaration

Is This Answer Correct ?    11 Yes 2 No

what are %TYPE and %ROWTYPE? what is the difference? ..

Answer / hjhjnj

Column Type (i.e. %TYPE) is used to declare a field with the same type as that of a specified table’s column

Row type (i.e. %ROWTYPE) is used to declare a record with the same types as found in the specified database table, view or cursor

Is This Answer Correct ?    7 Yes 1 No

what are %TYPE and %ROWTYPE? what is the difference? ..

Answer / vikneswaran

%type is used to declare variable for one column in the table
%type is used to declare variable for entire table

Is This Answer Correct ?    7 Yes 14 No

Post New Answer



More SQL PLSQL Interview Questions

Explain the uses of control file.

0 Answers  


When do we create bitmap indexes

2 Answers   CTS,


Are ddl triggers fired for ddl statements within a pl/sql code executed using the dbms.sql package?

0 Answers  


what is difference between procedure and function, procedure and trigger?

8 Answers   iFlex,


How can we store rows in PL/SQL using array?

0 Answers   MCN Solutions,






Types of locks in database ?

8 Answers   HCL, TCS, Tieto,


what is SCALAR Queries?

2 Answers   ITC Infotech,


How can we Get the Updated Rows? ie, There is 100s of Rows i updated the Rows who have salary 5000. then i want to select the Updated Rows. How can we achieve it?

4 Answers   KCP, Fidelity,


Can you alter start with clause?

1 Answers   TCS,


What is the fastest way of accessing a row in a table?

5 Answers   TCS,


what is overloading procedure or overloading function ?

3 Answers   Genpact,


Does a user_objects view have an entry for a trigger?

0 Answers  






Categories