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
- 4969 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
How to use attributes of the implicit cursor in oracle?
i wrote a pl/sql procedure. it must run every sunday 4.40 How can i schedule it with the help of dbms_jobs (or another other procedure with out creating bat file,exe file)
What is the difference between post-database commit and post-form commit?
What is sharded cluster?
What is ceil and floor in oracle?
What is the implicit cursor in oracle?
Hi Can any one tell me what are the API's used in requisition import.
I have a database backup file in .db (ext) form how to conver it into .dmp (ext.) for oracle database
How to see free space of each tablespace?
List the types of joins used in writing subqueries?
What is Library Cache in Oracle?
Which environment variables are absolutely critical in order to run the OUI?
How can you use check constraints for self referential integrity?
Why does Oracle not permit the use of PCTUSED with indexes?
How to connect the oracle server as sysdba?
