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

Explain normalization and what are the advantages of it?

525

what is a composite key ? : Sql dba

616

Is the primary key an index?

609

how to use myisamchk to check or repair myisam tables? : Sql dba

517

What is the left table in sql?

525

How can I speed up sql query?

536

How do you add a column to a table?

610

Explain the purpose of %type and %rowtype data types?

513

what is a constraint? : Sql dba

721

How do I order columns in sql?

537

How can check sql version from command line?

540

What is example of database?

524

what is denormalization. : Sql dba

557

Is stored procedure faster than query?

572

What type of join is sql join?

543