Re: Dynamic DELETE statement

In article <01bbfe2e$197b91e0$279e15a5_at_Singnet.singnet.com.sg>,   "colin" <evonliow_at_singnet.com> 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????

In SQL Plus, you can write a script that creates and executes another script to do what you want. We use this method to do just what you are doing, and it runs on an IBM MVS system, where doing things dynamically is, well...... difficult.

HTH,
Steve Cosner

-------------------==== Posted via Deja News ====-----------------------
      http://www.dejanews.com/     Search, Read, Post to Usenet