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
- 4871 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 |
How to update rows in table, suppose i have lacks of rows in table how to update total table with update statement. Can u please any one answer this question with update statement.
What is logical backup in oracle?
Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size ?
What is the exact use of Collections?
Explain the dml?
what is reindexing?
How to drop an index in oracle?
Explain the use of rows option in exp command.
What is an oracle cursor variable?
What is a view and how is it different from a table?
what is the difference between substr and instr function in oracle?
When do you get a .pll extension in oracle?
Oracle General 
