%type is used to declare variable for one column in the table %type is use

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

Question Posted / vikneswaran

Answer Posted / vikneswaran

%type is used to declare variable for one column in the table
%type is used to declare variable for entire table

Is This Answer Correct ?

7 Yes

14 No

Please Help Members By Posting Answers For Below Questions

what is subquery? : Sql dba

1132

What is procedure in pl sql?

1040

What is the purpose of primary key?

1019

What is a .db file?

984

What is execute immediate?

1082

Why is sql important?

1100

What are types of indexes in sql?

1080

What are the possible values for the boolean data field?

961

What is duration in sql profiler trace?

1078

how to create a test table in your mysql server? : Sql dba

1006

Can you load data into multiple tables at once? : aql loader

1066

What are the usages of sql?

1056

what is the difference between cluster and non cluster index? : Sql dba

1023

What are few of the schema objects that are created using PL/SQL?

1030

how to dump a table to a file with 'mysqldump'? : Sql dba

1035