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

What are the benefits of pl sql?

519

How to make a copy values from one column to another in sql?

567

Is grant a ddl statement?

449

List the different type of joins?

566

What is %rowtype in pl sql?

511

What is the use of <> sql?

548

What is java sql connection?

508

How do I view a sql trace file?

559

What is meant by user defined function?

575

Can we insert data into view?

518

What is the difference between unique and primary key constraints?

582

How do you rename a table in sql?

527

What are the operators in sql?

520

How is pl sql different from sql?

536

Can a trigger call a stored procedure?

531