Re: Dynamic DELETE statement

What platform are you running on?
I routinely perform such operations by writing a perl script to generate 'on the fly' SQL, then firing off an SQLPLUS to execute it. Perl is available on almost all platforms.
Let me know, if you need an perl script to do it.

Reply to richwoodland_at_interfacefamily.com

colin wrote:
>
> Does anyone know how to create a dynamic DELETE statement?
> I am trying to purge all my tables' records using the same procedure.
> i.e. I need to pass in table name,etc.
>
> My PL/SQL version 1.?? does not support the RDBMS standard package
> (DBMS_SQL), any alternatives????
>
> Thank u.
  Received on Thu Mar 13 1997 - 00:00:00 CET