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
- 5057 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
types of indexes and the rationale behind choosing a particular index for a situation.
How to enter a new row into a table interactively?
Can we create database in oracle using command line ?
Can a parameter be passed to a cursor?
What is the simplest tool to run commands on oracle servers?
Where do you use decode and case statements?
What is hot backup and logical backup?
What privilege is needed for a user to create tables in oracle?
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
can u send the sql dumps to sivakumarr1987@gmail.com plz help me
How to define a specific record type?
Please explain compound trigger in oracle?
How to view the tablespaces in the current database?
Explain an integrity constrains?
What happens to the data files if a tablespace is dropped?
