I want to create 5 sql statements in one procedures which are performing diff tasks. can u provide the pl/sql PROC which can be include 5 sql statements. — Note: one time only one sql staement should execute depends on requirement not all sql statements.

The question is still very vague. What is exactly the problem ?

Another example:

create or replace procedure my_proc (p_mode in number)
is
	l_price number;
begin
	if p_mode = 1 then
		select sum(price) into l_price from sales;
	elsif p_mode = 2 then
		update tax_rates set tax_percent = 0.0875 where state = 'CA';
	elsif p_mode = 3 then
		delete from sales_history where sale_date < (sysdate() - 180);
	...
	end if;
...
end;