You need to add more information to your question. ANY PL/SQL procedure can execute arbitrarily many independent SQL statements. Simple example:
create or replace procedure my_proc
select sum(price) from sales;
update tax_rates set tax_percent = 0.0875 where state = 'CA';
delete from sales_history where sale_date < (sysdate() - 180);
What are you really trying to accomplish?
Last Wiki Answer Submitted: June 29, 2009 7:14 pm by Kccrosser3,830 pts.