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.

Answer / lakshminarayana reddy

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

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

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;

Answer / srikanth

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

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

Answer / vikneswaran

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

Is there a pl/sql pragma similar to deterministic, but for the scope of one single sql select?

0 Answers  

i want to display 1 to 10 numbers using one select statement.

18 Answers   HCL, Nyros, Oracle,

What are instead of triggers?

0 Answers  

How much does sql certification cost?

0 Answers  

what are date and time data types in mysql? : Sql dba

0 Answers  

what is an extent ? : Sql dba

0 Answers  

What is sap sql?

0 Answers  

What is recursive stored procedure?

0 Answers  

what is sql optimization

1 Answers   Fidelity,

table :- city name country code abc 11 bcd 22 cde 232 def 33 write a procedure , so that when we give a phone no. eg - 1123456789 - o/p sud be city name = abc if phone no. - 2322345897 , o/p sud be =cde note - bcd and cde city name sud be diff. as dey diff only with th last no. Pls ans. this questnion.

1 Answers  

What is compute?

0 Answers  

Why do we create views in sql?

0 Answers