%row type is used to focus on particular record. row%type is used to focus

Differentiate between %type and %rowtype attribute in
Oracle PL/AQL programming ?

Question Posted / savani rakshit

Answer Posted / savani rakshit

%row type is used to focus on particular record.
row%type is used to focus on single row

Is This Answer Correct ?

6 Yes

1 No

Please Help Members By Posting Answers For Below Questions

How to return multiple rows from the stored procedure?

971

What are the different types of tables in sql?

1009

What are the various levels of constraints?

1126

What is dml and ddl?

960

Enlist the data types that can be used in pl/sql?

1073

how to convert character strings to dates? : Sql dba

1065

What is latest version of sql?

1048

what is data integrity? : Sql dba

1040

what is the difference between char and varchar data types? : Sql dba

1119

What are the two characteristics of a primary key?

983

Can a composite key be null?

981

How many clustered indexes can you have?

975

What is triggering circuit?

1071

How do you rename a table in sql?

1118

How many sql statements are used?

1015