1:-How to write to update command in a procedure in oracle which update two dif

1:-How to write to update command in a procedure in oracle
which update two different table at a time

2:-How to write the select command in a procedure in oracle
which give multiple records

Question Posted / deep_0607

1 Answers
4603 Views
I also Faced
E-Mail Answers

1:-How to write to update command in a procedure in oracle which update two different table at a ti..

Answer / guneetinder singh

update query depends upon no. of column two tables contain.

declare
salary number:=&salary;
procedure guneet(s in number) as
begin
update emp set sal = sal+s;
update gesture set sal1 = sal1+s;
end guneet;
begin
guneet(salary);
end;

--------------------------------------------------------------
declare
procedure multiple() as
begin
select * from emp;
end multiple;
begin
guneet();
end;

Is This Answer Correct ?

1 Yes

7 No

Post New Answer