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

Write the command to remove all players named sachin from the players table.

1185

Is it possible to sort a column using a column alias?

1055

Is sql sequential or random?

1041

What are primary key and foreign key and how they work?

978

How do you update a sql procedure?

1032

What is the difference between a database and a relational database?

1108

How to run sql statements with oracle sql developer?

1076

What is the difference between local variables and global variables?

1128

What are the two types of exceptions.

1174

What mean sql?

1019

How do I install sql?

1003

When you have to use a default "rollback to" savepoint of plvlog?

1204

What are pl/sql packages?

1107

what is sql in mysql? : Sql dba

1200

what are the different functions in sorting an array? : Sql dba

1028