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
- 4991 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 are extents allocated to a segment?
Give the sequence in which triggers fired during insert operations, when the following 3 triggers are defined at the same block level ?
Display the number value in Words?
What is RULE-based approach to optimization ?
Difference between primary key and unique key ?
77 Answers Accenture, B2B Software Technologies, Cognizant, HP Finsoft, IndiaNIC, Karomi Technology, Keane India Ltd, L&T, Onward eServices, R Systems, Shakti, Techtic Solutions,
Compare and contrast between sql and sql server and explain its various functions?
What is Partitions in Table ?
What is set operator oracle?
Explain a data segment?
Explain oracle insert into command?
difference between procedures and function?
What is self-referential integrity constraint ?
Oracle General 
