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

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

Question Posted / srikanth

Answer Posted / srikanth

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

Is This Answer Correct ?

11 Yes

2 No

Please Help Members By Posting Answers For Below Questions

What is substitution variable in pl sql?

1107

What is %s in sql?

1076

Why truncate is faster than delete?

1159

How to fetch alternate records from a table?

1305

How many rows can sqlite handle?

1160

what are the drivers in mysql? : Sql dba

1059

What do you mean by dbms? What are its different types?

1062

How many types of indexes are there in sql?

1040

explain the difference between bool, tinyint and bit. : Sql dba

1063

Is pl sql a programming language?

1042

Why stored procedure is better than query?

1000

What is a pl/sql block?

1326

What is rowtype?

1079

What is the purpose of using pl/sql?

1189

What is an exception in PL/SQL? What are the two types of exceptions?

1395