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
- 4380 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 |
What is an index associated with a constraint?
What are Clusters ?
How to count duplicated values in a column in oracle?
What is the usage of save points in oracle database?
What are named parameters?
Difference between varchar and varchar2 data types?
Why do we use coalesce function in oracle?
What is COST-based approach to optimization ?
Does oracle database need java?
In what script is snap$ created? In what script is the scott/tiger schema created?
How does one get the view definition of fixed views/tables?
Iam learning oracle developer 2000.. can anyone give me then tutorials sites or PDF related to developer 2000 please send me the details @ mak2786@gmail.com thanks Arun
Oracle General 
