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.

What are the datatypes available in pl/sql ?

0 Answers  

what are the different tables present in mysql, which type of table is generated when we are creating a table in the following syntax: create table employee (eno int(2),ename varchar(10)) ? : Sql dba

0 Answers  

Hi All, I am new to both this blog and technology. I was able to see a response for one of the questions on triggers as below. I would like to know why are we using " if rtrim(to_char(sysdate,'day'))=rtrim('sunday') then" instead, can't we use " if sysdate = 'sunday' then". I can understand the use of "rtrim", but dont know y v r using to_char. I have seen this in many cases but did not get a convincible explaination. Please help me with this and do excuse if this question sounds silly. Thanks in advance...... create or replace trigger trg_sun before insert on <table name> begin if rtrim(to_char(sysdate,'day'))=rtrim('sunday') then raise_application_error(-20345,'no transaction in sunday'); end if; end trg_sun;

2 Answers  

difference between oracle 8i and oracle 9i

8 Answers  

What is an alias command?

0 Answers  

what is user defined functions? : Sql dba

0 Answers  

What is the function that is used to transfer a pl/sql table log to a database table?

0 Answers  

What is the use of function "module procedure" in pl/sql?

0 Answers  

What is java sql drivermanager?

0 Answers  

Hi, Can anybody please explain me the flow of the below query. I am not able to understand how this query works. This query is for finding the Nth highest salary.. SELECT DISTINCT (a.sal) FROM EMP A WHERE &N = (SELECT COUNT (DISTINCT (b.sal)) FROM EMP B WHERE a.sal<=b.sal); If N = 2 then second highest salary will be the o/p. If N = 3 then third highest salary will be the o/p. and so on.. Thanks, Nitin

5 Answers   Deloitte, Ness Technologies,

What is the use of nvl function?

0 Answers  

Why primary key is required?

0 Answers