%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

Is stored procedure faster than query?

969

How many sql core licenses do I need?

944

Are stored procedures faster than queries?

948

What does count (*) do in sql?

1012

how to fetch common records from two tables? : Sql dba

1172

Differentiate between pl/sql and sql?

1149

What do you know by pl/sql cursors?

1105

What are three advantages to using sql?

1019

What is the sql case statement?

1003

What are the most important characteristics of pl/sql?

1157

What is foreign key sql?

985

how to fetch alternate records from a table? : Sql dba

1112

Sql technical questions

1280

What are the differences between in and exists clause?

1111

How is a PL/SQL code compiled?

1230