%type is associates a variable with column data of a table.. ex.. empn

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

Question Posted / debasis dutta

7 Answers
49019 Views
ICICI, Saama Tech, Sail, I also Faced
E-Mail Answers

Answer Posted / debasis dutta

%type is associates a variable with column data of a table..
ex..
empno emp_mast.eno%type;
%rowtype is associates a variable with whole table data of
a database..
ex
tot emp_mast%rowtype;

Is This Answer Correct ?

13 Yes

3 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Define commit, rollback and savepoint?

1032

What is a field in a database?

1065

Is oracle sql free?

991

How to change the order of columns in Oracle SQL Plus ?

1058

How do you use collections in procedure to return the resultset?

2242

What is a variable in sql?

1005

how to get a list of columns in an existing table? : Sql dba

966

What is field delimiter?

1048

how to use myisamchk to check or repair myisam tables? : Sql dba

972

Why is nosql good?

1029

What is output spooling in sql*plus?

1038

What is a boolean in sql?

985

Can we create foreign key without primary key?

987

What is rank () in sql?

944

What is a record in pl/sql?

1150