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:-How to write to update command in a procedure in oracle which update two different table at a ti..

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

Post New Answer

More Oracle General Interview Questions

how will I find the first 5 highest salaried employees in each dept in oracle.

22 Answers   IBM,


What is a package in oracle?

0 Answers  


How can we find out the duplicate values in an oracle table?

0 Answers  


How to use select statement to count the number of rows in oracle?

0 Answers  


How to view the dropped tables in your recycle bin?

1 Answers  


How to save query output to a local file?

0 Answers  


How to create a stored procedure in oracle?

0 Answers  


Calculate difference between 2 date / times in oracle sql?

0 Answers  


What is the quickest way to export a table to a flat file?

0 Answers  


How many categories of data types?

0 Answers  


What is SQL access advisor in Oracle?

0 Answers   MCN Solutions,


How to see the table columns used in an index?

0 Answers  


Categories
  • Oracle General Interview Questions Oracle General (1808)
  • Oracle DBA (Database Administration) Interview Questions Oracle DBA (Database Administration) (261)
  • Oracle Call Interface (OCI) Interview Questions Oracle Call Interface (OCI) (10)
  • Oracle Architecture Interview Questions Oracle Architecture (90)
  • Oracle Security Interview Questions Oracle Security (38)
  • Oracle Forms Reports Interview Questions Oracle Forms Reports (510)
  • Oracle Data Integrator (ODI) Interview Questions Oracle Data Integrator (ODI) (120)
  • Oracle ETL Interview Questions Oracle ETL (15)
  • Oracle RAC Interview Questions Oracle RAC (93)
  • Oracle D2K Interview Questions Oracle D2K (72)
  • Oracle AllOther Interview Questions Oracle AllOther (241)