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
- 4975 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 |
ABOUT IDENTITY?
What is the parameter mode that can be passed to a procedure?
What is an external table?
what is null value?
how to retrieve data from different tables ,place this data in different excel worksheets.
What is Read-Only Transaction ?
What is Virtual Private Database in Oracle?
Explain what are clusters?
How to rename an existing table?
What is translate in oracle?
How to display row numbers with the records?
What is a cursor in oracle?
Oracle General 
