%type can hold one perticular variable %rowtype decalre total row declarat

what are %TYPE and %ROWTYPE? what is the difference?

Question Posted / srikanth

Answer Posted / srikanth

%type can hold one perticular variable
%rowtype decalre total row declaration

Is This Answer Correct ?

11 Yes

2 No

Please Help Members By Posting Answers For Below Questions

What is replication id?

937

Explain what is a database?

1087

What is trigger in pl sql with examples?

1043

How we can create a table in pl/sql block. Insert records into it? Is it possible by some procedure or function? Please give example?

1050

What is snowflake sql?

1074

What are the two types of periodical indexes?

940

what does the t-sql command ident_current does? : Transact sql

982

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

1103

Why do we use joins in sql?

970

Is sql a case sensitive language?

947

What are types of indexes in sql?

1082

Why is stored procedure faster than query?

960

what is a primary key? : Sql dba

1034

What is difference between joins and union?

1127

What is optimistic concurrency control? : Transact sql

984