I am having a table which is getting data from the package:
In this package I am inserting the values from a view
ex : create or replace package body schema.pkg as ... procedure tab1() as Insert into abc (amount,id,name) select amount,id,name from view ,..
end tab1
here the issue is some of the ID`s amount is 0 and I want to update the package with some other table amount like Ex update abc set amount = select amount from bbc
so can I write in this way
procedure tab1() as Insert into abc (amount,id,name) select amount,id,name from view ,..
update abc set amount = select amount from bbc
end tab1
do I need to improvise anything else