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
- 4988 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
What are the system predefined user roles?
How to write an inner join with the where clause in oracle?
How to bring a tablespace offline?
query optmization techniques and quwry analyser+projects+ppts
What is a nvl function? How can it be used?
Where is the export dump file located?
How to get a list of all user accounts in the database?
Can we write insert statement in function in oracle?
What is a sub query? Describe its types?
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
How to rename a column in an existing table?
how to make an oracle object
How to update values on multiple rows in oracle?
What is the sql query to concatenate column values from multiple rows in oracle?
Is it possible to split the print reviewer into more than one region ?
