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
- 4999 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 |
Differentiate between function and procedure in oracle.
Calculate difference between 2 date / times in oracle sql?
what are the database links ?
What is difference between UNIQUE constraint and PRIMARY KEY constraint ?
How to update values on multiple rows in oracle?
What is the difference between view and materialized view in Oracle?
what is the difference between oracle enterprise edition and oracle express edition?
What is E-R diagram ?
2 Answers CGI, Keane India Ltd,
What is index-organized table in Oracle?
What is difference between cartesian join and cross join?
How to find out what oracle odbc drivers are installed?
Can you create a synonym without having a table?
Oracle General 
