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
- 4872 Views
- I also Faced
- E-Mail Answers
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
How to use "if" statements on multiple conditions?
How to import one table back from a dump file?
How many file formats are supported to export data?
Explain a data segment?
What is the difference between formal parameters and actual parameters?
Explain the use of parfile option in exp command.
How do you find out from the RMAN catalog if a particular archive log has been backed-up?
What is key preserved table?
What is a cognitive schema?
How to best split csv strings in oracle 9i?
Why do we use coalesce function in oracle?
What is a lookup table in oracle?
Is oracle a programming language?
Using the relations and the rules set out in the notes under each relation, write table create statements for the relations EMPLOYEE, FIRE and DESPATCH. You should aim to provide each constraint with a formal name, for example table_column_pk.
How to rollback the current transaction in oracle?
