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 are the different sql commands?

513

How does sql developer connect to oracle database?

516

how many sql dml commands are supported by 'mysql'? : Sql dba

567

How bulk collect improves performance?

570

What is transaction control language (tcl)?

634

How do I truncate a sql log file?

530

How many primary keys can a table have?

532

When is the explicit cursor used ?

588

Define commit?

547

What do you mean by “trigger” in sql?

617

What is varchar data type in sql?

514

what is an index? : Sql dba

520

what is innodb? : Sql dba

575

What schema means?

522

Differentiate between sga and pga.

665