create table employee3(Name varchar(256), salary int, Id int);
insert into employee3(Name,salary)values('Dheerendra',25000,01);
select * from employee3;

declare
sal employee salary % type;
begin
select salary into sal from employee3 where Id=1;
dbms_output.put_line('Salary of employee with id = '||sal);
end;

-- syntax
-- <var name> <tab name><col. name>%Type