ROWTYPE is declared at the record level and the TYPE is declared for the

Differentiate between %type and %rowtype attribute in
Oracle PL/AQL programming ?

Question Posted / swapna

Answer Posted / swapna

ROWTYPE is declared at the record level and the TYPE is
declared for the coloumn level.

Is This Answer Correct ?

24 Yes

1 No

Please Help Members By Posting Answers For Below Questions

what is oracle database ? : Sql dba

966

How to assign sql query results to pl sql variables?

990

Which sql most popular?

934

What is trigger types of trigger?

992

What are conditional predicates?

986

what is 'mysqlimport'? : Sql dba

973

What is not equal in sql?

1005

How does postgresql compare to mysql?

986

Mention what does the hierarchical profiler does?

1020

What is a sql select statement?

994

What is the source code of a program?

1001

What is the difference between clustered and non-clustered index in sql?

956

How do I create a memory optimized filegroup?

903

What is foreign key sql?

942

How does a covering index work?

905