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
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 |
how will I find the first 5 highest salaried employees in each dept in oracle.
What is a package in oracle?
How can we find out the duplicate values in an oracle table?
How to use select statement to count the number of rows in oracle?
How to view the dropped tables in your recycle bin?
How to save query output to a local file?
How to create a stored procedure in oracle?
Calculate difference between 2 date / times in oracle sql?
What is the quickest way to export a table to a flat file?
How many categories of data types?
What is SQL access advisor in Oracle?
How to see the table columns used in an index?