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 / sunil

Answer Posted / sunil

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

Is This Answer Correct ?

8 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Is hadoop a nosql?

950

What is a temporal data type?

981

What is trigger in flip flop?

959

How do you drop a trigger?

924

How do I use google cloud in sql?

1034

Does a user_objects view have an entry for a trigger?

963

What is the difference between join and natural join?

883

Is sql workbench free?

932

Is it mandatory for the primary key to be given a value when a new record is inserted?

1139

what are sequences

1622

What is benefit of creating memory optimized table?

910

Can there be 2 primary keys in a table?

952

What is dense_rank in sql?

917

How do rank () and dense_rank () differ?

977

What are the subsets of sql?

1038