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

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

Question Posted / vikneswaran

Answer Posted / 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

Please Help Members By Posting Answers For Below Questions

How many tables can you join in sql?

1006

What are different types of queries in sql?

1171

What is difference between rank () row_number () and dense_rank () in sql?

1157

Determine if oracle date is on a weekend?

1087

What is delimiter in pl sql?

1097

How to place comments in pl/sql?

1215

What is pl sql in oracle?

1094

How do I save a stored procedure?

1065

What is sql stand for?

1033

What is the use of non clustered index?

1042

What is autocommit sql?

1040

Does view store data in sql?

1036

What is group function in sql?

1061

Why we use cross join?

997

Can primary key be changed?

951