Column Type (i.e. %TYPE) is used to declare a field with the same type as

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

Question Posted / hjhjnj

7 Answers
48970 Views
ICICI, Saama Tech, Sail, I also Faced
E-Mail Answers

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

Is This Answer Correct ?

7 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What are the indexing methods?

1039

Are pl sql variables case sensitive?

1045

What kind of join is join?

957

Does sql support programming?

1064

Is not equal in sql?

1010

What is the purpose of a secondary key?

962

Will truncate release space?

940

How can we find duplicate records in a table?

944

Why is pl sql needed?

927

Can we use view in stored procedure?

891

what is an extent ? : Sql dba

1087

what tools available for managing mysql server? : Sql dba

1076

What sql database should I use?

1136

What is the use of sql trace?

950

Which is better join or inner query?

1039