Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: procedure with tables
Hi,
CREATE OR REPLACE
PROCEDURE xyz (p_tab_name in varchar2,p_where_bed in varchar2) as
v_text varchar2(4000);
BEGIN
v_text := 'delete from '||p_tab_name||' where '||p_where_bed;
execute immediate v_text;
END;
"alainc" <alain2208_at_caramail.com> schrieb im Newsbeitrag
news:arsvuf$jf8$1_at_s1.read.news.oleane.net...
> Hi,
> I need to make a procedure to do the same action( ie delete or update all
> elements) but on different tables. so i want to use a proc and give as
> parameters the table name.
> how to do it
> thanks
>
>
>
>
Received on Mon Nov 25 2002 - 06:08:07 CST
![]() |
![]() |