Re: DDL Statements in PL/SQL !?!

From: Jarek Palka <triss_at_zeus.polsl.gliwice.pl>
Date: Tue, 4 May 1999 15:06:04 +0200
Message-ID: <7gmrgn$3i3@router.kamsoft.com.pl>

>How does one go about performing administrative tasks (like removing all
>sequences or indexes) in a iterative fashion without spooling out the
contents
>of a query into a file a then creating a script to execute?
>
>Merci,
>

You should use DBMS_UTILITY package. There is procedure EXEC_DDL_STATEMENT. It's easier to use then DBMS_SQL.

Jarek Palka
Kamsoft, Katowice
POLAND Received on Tue May 04 1999 - 08:06:04 CDT

This message: [ Message body ]
Next message: Jarek Palka: "Trigger on SYS tables ?"
Previous message: Ron Reidy: "DBD::Oracle for Oracle8"
In reply to: peter_veenstra_at_my-dejanews.com: "DDL Statements in PL/SQL !?!"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

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