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
Answer Posted / 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 View All Answers
What is concurrency in oracle?
How do you get nicely formatted results from an oracle procedure that returns a reference cursor?
What is a dead lock in oracle?
What is oracle analytical function?
How to list all indexes in your schema?
Explain the use of consistent option in exp command.
How can Oracle users be audited?
Explain integrity constraints?
Explain oracle’s server parameter file.
Can we create trigger on materialized view in oracle?
How to omit columns with default values in insert statement in oracle?
How to define an anonymous procedure with variables?
What is a database table in oracle?
How will you differentiate between varchar & varchar2?
Why do we need integrity constraints in a database?