how to Update table Sales_summary with max(sales) data from
table sales_dataTable 1. sales_data table Table 2.
Sales_summary
Region sales Region sales
N 500 N 0
N 800 W 0
N 600
W 899
W 458
W 900
I want the Sales_summary After Update like this
Region Sales
N 800
W 900
- 8 Answers
- 8296 Views
- I also Faced
- E-Mail Answers
Answer Posted / sunil
-- It can be done by simple procedure
DELIMITER $$
drop procedure if exists updatesale$$
create procedure updatesale()
BEGIN
declare l_loop_end INT default 0;
declare l_region varchar(10);
declare l_sale int ;
declare cur_1 cursor for select region 'Region',max(sales)
'SALES' from sales_data group by region;
declare continue handler for sqlstate '02000' set l_loop_end
= 1;
open cur_1;
repeat
fetch cur_1 into l_region,l_sale;
if not l_loop_end then
update sales_summery set sales=l_sale where region=l_region;
end if;
until l_loop_end end repeat;
close cur_1;
end$$
DELIMITER ;
call updatesale;
-- now check
select * From sales_summery;
region sales
w 900
N 800
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
what is the difference between delete and truncate commands? : Sql dba
How to handle bulk data?
Can we use threading in pl/sql?
What is oracle sql developer?
Can we insert data into view?
Are views faster than queries?
What are the most important characteristics of pl/sql?
What does dml mean?
what is the difference between inner and outer join? Explain with example. : Sql dba
What are the string functions in sql?
What is difference sql and mysql?
What is pl/sql table? Why is it used?
What is rownum?
What is replication id?
How is sql used in oracle?
