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

How do we use distinct statement? What is its use?

1025

Why do we need a foreign key?

1086

What language is oracle sql developer?

993

Show code of a cursor for loop.

1050

hi,i plan to put experience on PLSQL ,can anyone suggest me for any institutes in bangalore or how to prepare for interviews

2012

How do I view tables in mysql?

970

What is rollback?

1105

What is the use of prepared statement?

1005

List the different type of joins?

1058

how to escape special characters in sql statements? : Sql dba

1029

What is the difference between count 1 and count (*) in a sql query?

980

Explain what is a field in a database and record in a database?

1088

how can we encrypt and decrypt a data present in a mysql table using mysql? : Sql dba

1179

How many sectors are in a partition?

1071

What is the order of sql select?

1039