declare
n tab2.ename%type;
s tab2.sal%type;
c tab1.city%type;
b number;
e tab2.eno%type;
begin
select ename,sal, city into n, s, c from tab1,tab2 where tab1.deptno=tab2.deptno and eno= &e;
b:=&b;
b:=b+s;
dbms_output.put_line('name is '||n|| ' salary is ' ||s|| 'city is '||c||'bonus is ' ||b);
end;
/
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment