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
- 4995 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 |
query optmization techniques and quwry analyser+projects+ppts
i must get table name, constraint type, constrain name with using concads "||" and it must be in string type, then with join processes i need code please help immidiately
What is merge in oracle?
Explain oracle data types with examples?
How to upsert (update or insert into a table)?
what is the bitmap index?
Explain mutating triggers.
Is java required for oracle client?
How to write a query with a full outer join in oracle?
Can we protect our pl/sql source code?
does the query needs a hint to access a materialized view?
What are a cluster and non-cluster index?
Oracle General 
