Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: procedure with tables

Re: procedure with tables

From: Dirk Tschentscher <dirk.tschentscherREM_THIS_at_volkswagen.de>
Date: Mon, 25 Nov 2002 13:08:07 +0100
Message-ID: <art3r0$5uu2@doiweb4.volkswagen.de>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US