Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 1 Answers
- 4970 Views
- I also Faced
- E-Mail Answers
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 |
Explain what does a control file contain?
What is rowid and rownum in oracle?
What is the quickest way to fetch the data from a table?
What should be the return type for a cursor variable.Can we use a scalar data type as return type?
How many memory layers are in the shared pool?
WHAT IS ecc 6.0
I have table-A(1,2,3)& table-B(3,4,5).what is the different b/w below questions? A union all B? B union all A?
i want department wise maxmum salary and empolyee name
How to turn on or off recycle bin for the instance?
How to insert multiple rows with one insert statement in oracle?
Can an Integrity Constraint be enforced on a table if some existing table data does not satisfy the constraint ?
Difference between oracle's plus (+) notation and ansi join notation?
Oracle General 
