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 compound trigger?

573

GLOBAL TEMPORARY TABLE over Views in advantages insolving mutating error?

2582

What are functions in sql?

517

What is clustered and nonclustered index in sql?

508

Can we commit in trigger?

556

What are basic techniques of indexing?

853

what are myisam tables? : Sql dba

560

Explain the difference between cursor declared in procedures and cursors declared in the package specification?

585

What is a sql schema used for?

555

How do I count rows in sql query?

497

how to rename an existing column in a table? : Sql dba

519

What is the difference between functions, procedures, and packages in pl/sql?

494

what are the advantages of mysql in comparison to oracle? : Sql dba

534

What is acid property in a database?

593

Are stored procedures faster than dynamic sql?

541